Version History of Base Table Rows in the Värmland Dataset Collection

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

Click here for a data sample

This table is a historical record of geographical features sourced from 'Lantmäteriet' (The Land Survey of Sweden) website. It maintains a version history of its base table rows, with each row uniquely identified by a combination of a start date and a row number. The table contains information about when each row was extracted from the source data, along with the date when a new version of the row was extracted. If there is no end date, it indicates that the version of the row is the most recent. The table also includes geographical data, initially in the shapefile format, which has been transformed into the final geographic format. This format includes details such as the geometric location and attribute information of geographic features, which could be represented by points, lines, or polygons (areas).

The data in this table can be utilized in numerous ways in data analytics. For instance, it could be used to track changes in geographical features over time, allowing for a detailed analysis of geographical shifts and transformations. It could also be used to study the historical context of specific geographical areas, providing insights into how these areas have evolved. Additionally, the data could be used in predictive analytics, using historical trends to forecast future changes in geographical features.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. It is part of the unique identifier for each row in this version 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 means that the row is the most recent version.
_row_numberlongThis column contains the number of the row in the raw data extracted from the source. It is part of the unique identifier for each row in this version history table.
OBJECTIDlongThis column contains the unique identifier of the object in the table.
IDstringThis column holds an identification number associated with each object.
CODE_12stringThis column contains specific codes associated with the objects in the table.
Area_HadoubleThis column represents the area of the object in hectares.
RemarkstringThis column contains additional remarks or comments related to the object.
Shape_LengdoubleThis column holds the length of the object's shape.
Shape_AreadoubleThis column holds the area of the object's shape.
geom_geojsonstringThis column contains the geometric representation of the object in GeoJSON format.
geom_geotextstringThis column contains the geometric representation of the object in text format.
geom_typestringThis column indicates the type of geometry used for representing the object.
geom_centroidstringThis column contains the centroid, or geometric center, of the object.
geom_center_xdoubleThis column holds the x-coordinate of the object's center.
geom_center_ydoubleThis column holds the y-coordinate of the object's center.

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
Id2e1f5e9b-6da1-4e80-86b4-ae648cdbd425
Package idbdfc37ab-2d87-436a-ba7b-6312fe00922e
Position5
Revision idb78ce5e9-0739-42f7-bc07-0ead7f9bbe56
Stateactive
Tablevarmland_zip__clc12_65e_nv__history