Version History of Base Table Rows in Vasternorrland Dataset from a Swedish Source
The 'clc12_71f_so__history' table is a history table that belongs to the 'vasternorrland' dataset collection. It meticulously maintains the version history of its base table rows, allowing for changes and modifications to be tracked over time. This table uniquely identifies each row using a combination of the row number and the date of extraction. It contains detailed data, including when a row was added and when it was updated. If a row is the most recent version, it will have a null end date.
The data in the table is sourced from 'Lantmäteriet' website in Sweden. This table contains both attribute and geographic information derived from a shapefile, a widely-used data format for storing geometric location and attribute details of geographic features. The geographic data has been subsequently transformed into its final format from the initial shapefile format.
This table can serve a variety of purposes in data analytics. For instance, it could be utilized to track changes in geographic features over time, providing valuable insights for environmental studies or urban planning. The version history could also be used in auditing and data verification processes, ensuring the integrity of the data. In addition, the geographic information could be used in spatial data analysis, enabling researchers to study patterns, trends, and relationships within the data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it signifies 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. This, in combination with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | An identifier for the object. |
| ID | string | A unique identifier for each entry. |
| CODE_12 | string | A code associated with the entry. |
| Area_Ha | double | The area of the entry in hectares. |
| Remark | string | Any additional comments or notes associated with the entry. |
| Shape_Leng | double | The length of the shape associated with the entry. |
| Shape_Area | double | The area of the shape associated with the entry. |
| geom_geojson | string | The geometric representation of the entry in GeoJSON format. |
| geom_geotext | string | The geometric representation of the entry in text format. |
| geom_type | string | The type of geometry associated with the entry. |
| geom_centroid | string | The centroid of the geometry associated with the entry. |
| geom_center_x | double | The x-coordinate of the geometric center of the entry. |
| geom_center_y | double | The y-coordinate of the geometric center of the entry. |
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 | eb79b915-c647-4fdd-b26a-89c8ab373c4d |
| Package id | 363c72ba-f2e9-4503-ae45-694b4a3163d3 |
| Position | 13 |
| Revision id | b2f87154-8251-45e2-984a-7efaf8bd184b |
| State | active |
| Table | vasternorrland_zip__clc12_71f_so__history |