Version History of the Base Table in the Vasterbotten Dataset Collection
The 'clc12_70g_no__history' table is a comprehensive historical data collection part of the 'vasterbotten' dataset. It holds a detailed record of changes made to its base table, allowing users to track and analyze past versions of the data. This table is a treasure trove of information, with each row representing a unique version of a data entry, identified by a unique combination of the row number and the date the data was extracted.
Key to its structure are two additional columns that capture the start and end dates of each version. The start date signals when a version was extracted, and the end date indicates when a new version was created. If the end date is null, the version is the most recent in the system.
The table also contains geographic data, originally in shapefile format, which has been transformed into a final geographic format. This allows for the representation of geographic features such as points, lines, and polygons, providing a rich layer of context to the data.
The data for this table is sourced from Lantmäteriet, the Swedish land surveying authority. This provides a level of credibility and reliability to the data, making it a valuable resource for a wide range of data analytics tasks.
For example, an analyst could use the table to study changes in geographic features over time, providing valuable insights into environmental trends. Or, the table could be used to analyze patterns in the data changes themselves, potentially uncovering inconsistencies or anomalies in the data gathering process. Furthermore, this historical data could be used as a training set for predictive models, aiding in the forecasting of future changes in the data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with the '_row_number', it forms a unique identifier for each row in this version history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. It forms a unique identifier in combination with the '_start_date'. |
| OBJECTID | long | This column may contain a unique identifier for each object in the table. |
| ID | string | This column typically contains a unique identifier for each row in the table. |
| CODE_12 | string | This column likely contains an encoded value related to the data in the row. |
| Area_Ha | double | This column likely contains information about the area of an object or region, typically measured in hectares. |
| Remark | string | This column likely contains additional notes or comments about the data in the row. |
| Shape_Leng | double | This column typically contains information about the length of the shape, potentially in a geographical context. |
| Shape_Area | double | This column typically contains information about the area of the shape, potentially in a geographical context. |
| geom_geojson | string | This column likely contains the geographical data of the object or region in GeoJSON format. |
| geom_geotext | string | This column likely contains geographical data in a text format. |
| geom_type | string | This column likely contains information about the type of geographical data stored in the row. |
| geom_centroid | string | This column likely contains the centroid of the geographical data. |
| geom_center_x | double | This column likely contains the x-coordinate of the center of the geographical data. |
| geom_center_y | double | This column likely contains the y-coordinate of the center of the geographical data. |
No sample for this dataset
Additional Information
| Last updated | August 27, 2024 |
|---|---|
| Created | August 27, 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 | c8a0ac25-61dd-4f86-acb6-0e0e7a4d8daa |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 7 |
| Revision id | 4b77d122-bf2d-42ef-99ef-7cb966e276b1 |
| State | active |
| Table | vasterbotten_zip__clc12_70g_no__history |