Historical Version Records of Base Table Rows from a Swedish Dataset Collection

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

Click here for a data sample

This historical data table originates from the 'Lantmäteriet' (The Land Survey) website in Sweden. It is a comprehensive collection of information with a specific focus on maintaining the history of each row from its base table. This is achieved by the inclusion of starting and ending dates for each data extraction, creating a version history of the data over time. A unique identifier for each row is formed by combining the start date and row number. If the end date for a row is null, it signifies that the current version of the row is the most recent. Geographic information is a key feature of the dataset, originally sourced in shapefile format - a common format for storing geographic location and attribute information. This geographic data has been transformed from the shapefile format to a final geographic format for the purposes of this dataset.

The data in this table could be utilized in a variety of ways for data analytics. For instance, it could be used to analyze changes in geographic features over time, allowing for the tracking of spatial patterns and trends. The version history could also be used to validate and verify historical data, ensuring its accuracy and reliability. Additionally, the geographic information could be used in spatial data analysis, such as studying the distribution of features across different geographic areas. The table could also be used to support decision-making in areas such as urban planning, environmental management, and resource allocation.

Field Descriptions

Name Data type Description
_start_datedateThe 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_datedateThe 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_numberlongThe number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
OBJECTIDlongA unique identifier for the object represented by the row.
IDstringAn identifier for the data entry.
CODE_12stringA code representing specific information about the data entry.
Area_HadoubleThe area of the object represented by the row, in hectares.
RemarkstringAdditional comments or remarks about the data entry.
Shape_LengdoubleThe length of the shape representing the object, in the same units as the coordinate system of the dataset.
Shape_AreadoubleThe area of the shape representing the object, in the same units as the coordinate system of the dataset.
geom_geojsonstringThe geographical representation of the object in GeoJSON format.
geom_geotextstringThe geographical representation of the object as text.
geom_typestringThe type of the geographical object represented (e.g., point, line, polygon).
geom_centroidstringThe centroid of the geographical object, a point representing its center.
geom_center_xdoubleThe x-coordinate of the center of the geographical object.
geom_center_ydoubleThe y-coordinate of the center of the geographical object.

No sample for this dataset

Additional Information

Last updated August 26, 2024
Created August 26, 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
Id8f2b15ae-d9d2-43e7-b578-ee65623847f1
Package id1453d6cd-4a88-47c4-a433-b16478346411
Position7
Revision id91ec9eeb-9498-43d3-8db9-e355cd475727
Stateactive
Tablejonkoping_zip__clc12_63e_no__history