Version History Table of Land and Geographic Objects from Swedish National Land Survey

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

Click here for a data sample

The 'clc12_63e_so__history' is a historical data table that is part of the 'jonkoping' dataset collection. As a history table, it contains the version history of its base table rows, which are uniquely identified by a combination of a start date and a row number. This table has two additional columns compared to its base table, namely a start date, which indicates when the row was extracted from the data source, and an end date, which signifies when a new version of the row was extracted. If the end date is null, it indicates that the row is the current version. The table also contains geographic information transformed from the shapefile format, which can represent geographic features as points, lines, or polygons (areas). The data for this table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden.

The data in this table can be used in a variety of data analytics applications. For example, it could be used to track the historical changes in geographic features over time, which could be useful in urban planning or environmental studies. Additionally, by analyzing the version history, one could identify patterns or trends in the data changes, which could be beneficial in predictive analytics or decision-making processes. Furthermore, the geographic information could be utilized in spatial data analysis or geographic information system (GIS) applications, aiding in tasks such as location planning, route optimization, or environmental impact analysis.

Field Descriptions

Name Data type Description
_start_datedateThis column holds the date when the row was extracted from the data source. It is part of a combination with the '_row_number' column that uniquely identifies each row in this version history table.
_end_datedateThis column holds 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 as it appears in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column.
OBJECTIDlongThis column contains a unique identification number for each object in the table.
IDstringThis column holds a unique identifier for each row.
CODE_12stringThis column holds a specific code related to the row's data.
Area_HadoubleThis column records the area of the object in hectares.
RemarkstringThis column contains any additional comments or remarks related to the row's data.
Shape_LengdoubleThis column holds the length of the geographical shape associated with the row.
Shape_AreadoubleThis column contains the area of the geographical shape associated with the row.
geom_geojsonstringThis column holds the geographical data in GeoJSON format.
geom_geotextstringThis column contains the geographical data in plain text format.
geom_typestringThis column specifies the type of geographical shape associated with the row.
geom_centroidstringThis column contains the centroid or geometric center of the geographical shape associated with the row.
geom_center_xdoubleThis column holds the X-coordinate for the center of the geographical shape associated with the row.
geom_center_ydoubleThis column holds the Y-coordinate for the center of the geographical shape associated with the row.

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
Id4619cde4-bb5b-44f8-9b39-1d6c09fa3c0e
Package id1453d6cd-4a88-47c4-a433-b16478346411
Position11
Revision id5a3dcce3-3105-4611-9073-23a3be290ee3
Stateactive
Tablejonkoping_zip__clc12_63e_so__history