Historical Version Records of Land Cover Changes in Norrbotten

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

Click here for a data sample

The 'clc12_72h_sv__history' table is a historical data archive belonging to the 'norrbotten' dataset collection. As a history table, it carries the version history of its base table rows, which allows for tracking changes over time. This includes an additional two columns compared to its base table, indicating the start and end dates of each data entry. The start date and row number together form a unique identifier for each row in this version history table. If a row's end date is null, it indicates that the current row is the most recent version.

The table contains various types of data, including geographic information which has been transformed from the shapefile format. Shapefile, a simple non-topological format, stores the geometric location and attribute information of geographic features such as points, lines, or polygons.

This table is sourced from the Lantmäteriet (Land Survey) website in Sweden. It's a valuable resource for those interested in analyzing trend changes over time, tracking the history of data modifications, and studying geographic features in Sweden.

For instance, the data can be used to analyze geographic changes over time, track the development of certain areas in Sweden, or identify trends in land use. Moreover, it can cater to research in environmental science, urban planning, or geography. The unique identifiers in each row also allow for precise data tracking and verification, which can be significant in ensuring data integrity and accuracy.

Field Descriptions

Name Data type Description
_start_datedateThis column holds the date when the row was extracted from the data source. Together with '_row_number', it forms a combination that uniquely identifies 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 of this column is null, it indicates that the row is the most recent version.
_row_numberlongThis column contains the number of the row as it was in the raw data extracted from the data source. It is part of the combination with '_start_date' that uniquely identifies each row in this version history table.
OBJECTIDlongThis column holds the object identifier.
IDstringThis column contains the identifier.
CODE_12stringThis column holds the code 12.
Area_HadoubleThis column contains the area in hectares.
RemarkstringThis column holds any remarks.
Shape_LengdoubleThis column contains the length of the shape.
Shape_AreadoubleThis column holds the area of the shape.
geom_geojsonstringThis column contains the geometry of the object in GeoJSON format.
geom_geotextstringThis column holds the geometry of the object in text format.
geom_typestringThis column contains the type of geometry.
geom_centroidstringThis column holds the centroid of the geometry.
geom_center_xdoubleThis column contains the x-coordinate of the geometry's center.
geom_center_ydoubleThis column holds the y-coordinate of the geometry'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
Id5c02c1ad-afff-42d3-bba6-1d4f9bcf6e1b
Package idaec689b3-8d6e-4322-88cd-6b96004c9ec7
Position13
Revision id7ddfdda7-e8e9-4a78-889d-a820717511a9
Stateactive
Tablenorrbotten_zip__clc12_72h_sv__history