Version History of Base Table Rows in Kalmar Dataset Collection

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

Click here for a data sample

The table in consideration is a historical record, part of a dataset collection. It meticulously tracks the version history of its base table rows. Unique identifiers for each row in this version history table are composed of two elements: the date of extraction and the row number from the raw data. The table also indicates the date when a new version of the row was extracted. If there's no end date, it implies that the version of the row is the most recent one.

The data within this table encompasses a wide range of information, including geographic specifics. These geographic details, originally in shapefile format, have been transformed into the final geographic format. Shapefiles, a standard for storing geographic location and attribute info, can represent features as points, lines, or polygons.

The source of this table is the 'Lantmäteriet' website (Sweden's Land Surveying Authority). This vast collection of data can be harnessed in numerous ways for data analytics. For instance, it can be used to track changes in land use over time, analyze the impact of policy changes on land utilization, or assist in the development of predictive models for real estate and urban planning. Additionally, the geographic information can be used to create visualizations of the spatial distribution of different attributes, aiding in better environmental planning and resource allocation.

Field Descriptions

Name Data type Description
_start_datedateThe date when the version of the row was extracted from the data source.
_end_datedateThe date when a new version of the row was extracted from the data source. If null, it indicates 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 each object in the table.
IDstringAn identification number for each data entry.
CODE_12stringA code associated with the data.
Area_HadoubleThe area of the object, measured in hectares.
RemarkstringAny notes or comments associated with the data entry.
Shape_LengdoubleThe length of the shape of the object.
Shape_AreadoubleThe area of the shape of the object.
geom_geojsonstringThe geometric representation of the object in GeoJSON format.
geom_geotextstringThe geometric representation of the object in text format.
geom_typestringThe type of the geometric object.
geom_centroidstringThe centroid of the geometric object.
geom_center_xdoubleThe X coordinate of the center of the geometric object.
geom_center_ydoubleThe Y coordinate of the center of the geometric 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
Id6a297ca4-2b5a-46e6-9099-e58f3bef7197
Package id920fd79a-aa00-4de6-a177-f311300c82c6
Position11
Revision id14b72172-6996-44a1-b397-37ba93c84df3
Stateactive
Tablekalmar_zip__clc12_62f_so__history