Version History of Base Table Rows - History Table (Sourced from a Swedish Website)
The table under consideration is a historical record that forms part of a larger dataset from the region of Västra Götaland. It serves as a log of changes made to its corresponding base table, with two additional fields that mark the start and end dates for each row entry. This setup allows for the tracking of the complete life cycle of each row, from when it was first pulled from the source to when it was last updated. If the end date for a row is not specified, it signifies that the version in question is the most recent. The data in the table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey).
The table also includes geographic data, transformed from the shapefile format, typically used to store geometric location and attribute information of geographical features. The transformed geographic information can represent points, lines, or polygon areas.
This table can be instrumental in various data analytics applications. For instance, it can be used to monitor changes in land use over time, assess the impact of policy changes on land allocation, or analyze the correlation between land usage patterns and environmental factors. The geographic data can contribute to spatial analysis or used to generate detailed visualizations of the changes over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a unique identifier for each row in this version history table, along with the '_row_number' column. |
| _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 means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms part of a unique identifier for each row in this version history table, combined with the '_start_date' column. |
| OBJECTID | long | This column contains an object identifier. |
| ID | string | This column contains an identification number. |
| CODE_12 | string | This column contains a 12-character code. |
| Area_Ha | double | This column contains the area of the object in hectares. |
| Remark | string | This column contains remarks or comments related to the row. |
| Shape_Leng | double | This column contains the length of the shape in the row. |
| Shape_Area | double | This column contains the area of the shape in the row. |
| geom_geojson | string | This column contains the geojson format of the geometry of the object. |
| geom_geotext | string | This column contains the geotext format of the geometry of the object. |
| geom_type | string | This column contains the type of the geometry of the object. |
| geom_centroid | string | This column contains the centroid of the geometry of the object. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the object. |
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 | 6546a86c-868f-49b7-9acc-7ca3a2ce7132 |
| Package id | 60f2a9ad-e1f7-4dc9-a918-721986a483be |
| Position | 7 |
| Revision id | 83de2d7c-5c52-49bb-aa2b-459cb89c0ac7 |
| State | active |
| Table | vastra_gotaland_zip__clc12_64d_no__history |