Version History Table of Geographic Data from Sweden
This historical table is part of a dataset that originates from the 'Lantmäteriet' website in Sweden. It is a record of version history for the base table rows, providing a chronological overview of each version's lifespan by capturing the date when a version was extracted and when it was replaced by a new version. The most recent version of a row can be identified by a null value in the end date column. A unique identifier for each row in the table is formed by the combination of the start date and row number. The table also contains geographical data which was originally in shapefile format and has been converted to a more final geographic format. This geographical data can represent points, lines, or polygons.
In terms of data analytics, this table is a valuable resource. For example, the version history can be used to track changes in geographical features over time, which can be crucial in environmental studies. The geographical data can be utilized in spatial analysis to identify patterns or anomalies. Additionally, by analyzing the lifespan of different versions, one can gain insights into the frequency and nature of updates to the data source.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date on which the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table. |
| _end_date | date | This column contains the date on which a new version of the row was extracted from the data source. If the value in this column 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 data source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table. |
| OBJECTID | long | This column contains the unique identifier for each object in the table. |
| ID | string | This column contains an identification number for each row in the table. |
| CODE_12 | string | This column contains a code related to the data in the row. |
| Area_Ha | double | This column contains information about the area in hectares. |
| Remark | string | This column contains any additional comments or notes related to the row. |
| Shape_Leng | double | This column contains the length of the shape represented in the row. |
| Shape_Area | double | This column contains the area of the shape represented in the row. |
| geom_geojson | string | This column contains the geometry of the shape represented in the row, formatted as GeoJSON. |
| geom_geotext | string | This column contains the geometry of the shape represented in the row, formatted as text. |
| geom_type | string | This column contains the type of geometry for the shape represented in the row. |
| geom_centroid | string | This column contains the centroid of the shape represented in the row. |
| geom_center_x | double | This column contains the X-coordinate of the center of the shape represented in the row. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the shape represented in the row. |
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 | dc04ff90-177a-41e7-b9a5-05f55781bd47 |
| Package id | 75c6aab8-75b3-4d4f-8b22-3c7b3fb4eb0b |
| Position | 3 |
| Revision id | d9101966-ad63-4017-be77-295df6a9e218 |
| State | active |
| Table | orebro_zip__clc12_65e_no__history |