Version History of Geospatial Attributes for Västernorrland Dataset Collection
The 'clc12_68g_nv__history' table is a history table that is part of the 'vasternorrland' dataset collection. It is a rich source of versioned data, capturing the changes over time in its base table. The table is characterized by unique identifiers for each row, which are composed of a combination of the date a row was extracted and the number of the row in the raw data. This unique identification system allows for precise tracking and referencing of each entry.
The table not only tracks temporal changes but also contains a wealth of geographic information. This geographic data, initially in shapefile format, has been transformed into a final format suitable for this dataset. It represents geographic features such as points, lines, or polygons (areas), providing a detailed spatial context to the data.
The data in this table is sourced from 'Lantmäteriet' (The Land Survey) in Sweden, ensuring a reliable and authoritative information source.
In terms of data analytics, the table offers multiple opportunities. For example, understanding temporal changes in the data can provide insights into patterns and trends over time, which is essential in fields like urban planning or environmental studies. The rich geographic data can be used in spatial analysis, allowing for detailed geographical visualizations or the identification of spatial correlations and patterns. Furthermore, the version history can be crucial in historical data analysis, enabling researchers to verify the authenticity and accuracy of past data or to track changes in data 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's part of a combination, along with '_row_number', that uniquely identifies each row in this 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 in the raw data extracted from the data source. It's part of a combination, along with '_start_date', that uniquely identifies each row in this history table. |
OBJECTID | long | This column contains an identification number for the object. |
ID | string | This column contains the unique identifier for each row. |
CODE_12 | string | This column contains a code related to the data in the row. |
Area_Ha | double | This column contains the area of the object in hectares. |
Remark | string | This column contains any remarks or comments related to the row. |
Shape_Leng | double | This column contains the length of the shape of the object. |
Shape_Area | double | This column contains the area of the shape of the object. |
geom_geojson | string | This column contains the geometric data of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric data of the object in text format. |
geom_type | string | This column contains the type of the geometric data of the object. |
geom_centroid | string | This column contains the geographic center point of the object. |
geom_center_x | double | This column contains the X-coordinate of the geographic center point of the object. |
geom_center_y | double | This column contains the Y-coordinate of the geographic center point 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 | c3b28d90-0cf1-46da-99ad-beb7de2b23b8 |
Package id | 363c72ba-f2e9-4503-ae45-694b4a3163d3 |
Position | 3 |
Revision id | abfa2d4f-d374-4d56-9eb9-aa5877a9f653 |
State | active |
Table | vasternorrland_zip__clc12_68g_nv__history |