Version History of Geographical Data Records in Vasterbotten Dataset
The table 'clc12_72g_so__history' is a historical database that is part of the 'vasterbotten' dataset collection. It stores the version history of its base table rows, hence allowing for tracking changes over time. This historical aspect is enabled by two crucial columns, one that records the date when a row was extracted from the data source, and another that notes the date when a new version of the row was extracted. A unique combination of these two columns identifies each row in the table. The table also has a column that contains the row number from the raw data source. If the end date for a row is null, it signifies that the row is the most recent version.
The table also contains geographic information which initially was in a shapefile format, a common format for storing geometric location and attribute information of geographic features. This information has now been transformed into a more usable format.
The table is sourced from 'Lantmäteriet' (The Swedish National Land Survey) in Sweden.
This table could be extremely useful in data analytics. For instance, by tracking the changes in geographic features over time, analysts could gain insights into the changing landscape, which could inform land management and conservation strategies. Furthermore, the historical data could be used for predictive analytics to forecast future changes. The table could also be used in auditing and data quality assessment by comparing different versions of the same row over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | Another unique identifier for each row in the table. |
| CODE_12 | string | A code associated with each row in the table. |
| Area_Ha | double | The area of the geographical feature represented by the row, measured in hectares. |
| Remark | string | Additional comments or observations related to the row. |
| Shape_Leng | double | The length of the geographical feature represented by the row. |
| Shape_Area | double | The area of the geographical feature represented by the row. |
| geom_geojson | string | The geographical features represented by the row, stored in the GeoJSON format. |
| geom_geotext | string | The geographical features represented by the row, stored in a text format. |
| geom_type | string | The type of the geographical feature represented by the row. |
| geom_centroid | string | The central point of the geographical feature represented by the row. |
| geom_center_x | double | The x-coordinate of the center of the geographical feature represented by the row. |
| geom_center_y | double | The y-coordinate of the center of the geographical feature represented by the row. |
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 | 8e2bc735-ad44-41cf-8671-70aca3aad5c0 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 1 |
| Revision id | cd25b3dd-18f1-4951-8f43-8f1c72ba91c0 |
| State | active |
| Table | vasterbotten_zip__clc12_72g_so__history |