Version History of Geospatial Attributes for Västernorrland Dataset Collection

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_datedateThis 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_numberlongThis 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.
OBJECTIDlongThis column contains an identification number for the object.
IDstringThis column contains the unique identifier for each row.
CODE_12stringThis column contains a code related to the data in the row.
Area_HadoubleThis column contains the area of the object in hectares.
RemarkstringThis column contains any remarks or comments related to the row.
Shape_LengdoubleThis column contains the length of the shape of the object.
Shape_AreadoubleThis column contains the area of the shape of the object.
geom_geojsonstringThis column contains the geometric data of the object in GeoJSON format.
geom_geotextstringThis column contains the geometric data of the object in text format.
geom_typestringThis column contains the type of the geometric data of the object.
geom_centroidstringThis column contains the geographic center point of the object.
geom_center_xdoubleThis column contains the X-coordinate of the geographic center point of the object.
geom_center_ydoubleThis 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
Adaptershapefile
Countryse
Databasese_lantmateriet
Extract date2024-08-26
Idc3b28d90-0cf1-46da-99ad-beb7de2b23b8
Package id363c72ba-f2e9-4503-ae45-694b4a3163d3
Position3
Revision idabfa2d4f-d374-4d56-9eb9-aa5877a9f653
Stateactive
Tablevasternorrland_zip__clc12_68g_nv__history