Version History of Base Table Rows in Dalarna Dataset Collection
The 'clc12_66f_nv__history' table is a pivotal piece within the 'dalarna' dataset collection. Being a history table, it provides an extensive record of the version history of its base table rows, making it an invaluable tool for tracking changes over time. This table contains a unique identification system for each row using a combination of the start date and row number. It also includes start and end dates for when each row was extracted and subsequently updated or replaced. If an end date is null, this indicates that the current row represents the most recent version.
The table also provides geographic information, translated from the shapefile format, which can be used to represent geographic features as points, lines, or polygons. This data comes from the Swedish website 'Lantmäteriet' (The Land Survey), ensuring a reliable source.
In terms of data analysis, this table offers a host of opportunities. For instance, one could track changes in geographic features over time, assessing the rate of change or identifying patterns. Alternatively, the unique identification system could be used to track specific locations or features, identifying when and how often they're updated. These analyses could provide valuable insights for urban planning, environmental studies, or even historical research.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row's data was extracted from the source. It helps in tracking the version history of the base table rows. In combination with the '_row_number', it uniquely identifies each row in the history table. |
| _end_date | date | This column records the date when a newer version of the row was extracted from the source, marking the end of the validity of the data in the current row. If this column is null, it indicates that the current row is the most recent version in the history. |
| _row_number | long | This column contains the number of the row as it appears in the raw data sourced from 'Lantmäteriet' (The Land Survey) in Sweden. It is part of the unique identifier for each row in the history table, in combination with the '_start_date'. |
| OBJECTID | long | This column contains the object ID, a unique identifier assigned to each object or feature within the dataset. |
| ID | string | This column records the unique ID for each entry in the table. |
| CODE_12 | string | This column contains the code_12, a specific code related to the entry. |
| Area_Ha | double | This column records the area of the feature in hectares. |
| Remark | string | This column contains any additional notes or remarks associated with the row's data. |
| Shape_Leng | double | This column records the length of the feature's shape. |
| Shape_Area | double | This column records the area of the feature's shape. |
| geom_geojson | string | This column contains the geometric representation of the feature in GeoJSON format, a common format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geometric representation of the feature in plain text. |
| geom_type | string | This column describes the type of geometry represented, such as 'Point', 'LineString', or 'Polygon'. |
| geom_centroid | string | This column contains the centroid of the feature's geometry, which is the geometric center of the shape. |
| geom_center_x | double | This column records the x-coordinate of the feature's geometric center. |
| geom_center_y | double | This column records the y-coordinate of the feature's geometric center. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Adapter | shapefile |
| Country | se |
| Database | se_lantmateriet |
| Extract date | 2024-08-26 |
| Id | 67147464-3fd9-4de1-bca2-7a4a239099f6 |
| Package id | b5850e4f-b288-47bd-aa8e-1b5ae61e62d6 |
| Position | 7 |
| Revision id | cb5cd2cc-694a-4d0f-970e-f2871bbf0caa |
| State | active |
| Table | dalarna_zip__clc12_66f_nv__history |