Version History of Land Cover Changes in Norrbotten Dataset

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

Click here for a data sample

The table in question forms part of the 'norrbotten' dataset and primarily serves as a historical log of various geographical features. This history table records the version history of its base table rows, marking the beginning and end dates for each version of a row. The beginning date signifies when the row was extracted from the data source, while the end date indicates when a new version of the row was extracted. A null value in the end date column signifies that the current version of the row is the most recent one. This system of tracking changes enables users to keep track of historical data changes and trends over time.

The table contains geographical information, which is initially stored in the shapefile format before being transformed into the final geographic format. This geographical data can be represented by points, lines, or polygons (areas). The table also maintains a unique identifier for each row, combining the start date and the row number.

This table, sourced from 'Lantmäteriet' (The Land Survey) in Sweden, could prove to be a valuable asset for data analytics in various fields. For instance, urban planners and environmental scientists could use this data to study land use patterns over time, tracking changes in land cover and use. The data could also be used in predictive modeling, forecasting future land use based on historical trends. Furthermore, government agencies could use this data to monitor compliance with land use regulations, identifying any notable changes or anomalies over time.

Field Descriptions

Name Data type Description
_start_datedateThis column represents the date when the data row was initially extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table.
_end_datedateThis column contains the date when a new version of the data row was extracted from the data source. If this value is null, it signifies that the row is the current version.
_row_numberlongThis column holds the raw data row number from the data source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table.
OBJECTIDlongThis column contains the unique identifier for each object in the dataset.
IDstringThis column holds the unique identification code for each object, following a specific pattern unique to the dataset.
CODE_12stringThis column contains specific codes associated with the objects in the dataset.
Area_HadoubleThis column represents the area of each object in the dataset measured in hectares.
RemarkstringThis column is designated for any additional notes or remarks about the objects in the dataset.
Shape_LengdoubleThis column holds the geometric length of the objects in the dataset.
Shape_AreadoubleThis column contains the geometric area of the objects in the dataset.
geom_geojsonstringThis column contains the geometric representation of the objects in GeoJSON format, a widely used format for encoding a variety of geographic data structures.
geom_geotextstringThis column contains the geometric representation of the objects in textual format.
geom_typestringThis column specifies the type of the geometric representation of the objects.
geom_centroidstringThis column contains the geometric center point (centroid) of the objects.
geom_center_xdoubleThis column represents the X-coordinate of the geometric center point of the objects.
geom_center_ydoubleThis column represents the Y-coordinate of the geometric center point of the objects.

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
Iddf9af9f6-87d0-4f63-bccc-5a77ee49fffb
Package idaec689b3-8d6e-4322-88cd-6b96004c9ec7
Position11
Revision id8c23522f-bd3e-49c0-bbe5-e09fe55643fc
Stateactive
Tablenorrbotten_zip__clc12_72h_no__history