Version History of Base Table Rows in Norrbotten Dataset Collection

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

Click here for a data sample

This history table is part of a dataset from the Lantmäteriet (The Land Survey) in Sweden. It archives the version history of its base table rows, keeping track of changes over time. Each entry is uniquely identified by a combination of the date of extraction and a row number. The table provides a rich set of geographic data, originally in shapefile format, that has since been transformed into the final geographic format. The geographic data represent various geographical features which could be points, lines, or polygons (areas).

The table contains a variety of information including identifiers, codes, the area in hectares, and geographical data. The table includes dates indicating when the row was extracted from the data source and when a new version of the row was extracted. If the latter is null, it indicates that the row is the most recent version. The table also includes a column for remarks, although this often returns null values.

The data in this table could be utilized in numerous ways in data analytics. For example, it could be used to track changes in geographical features over time, such as the expansion of an urban area or the shrinkage of a forested region. The data could also be used to inform planning decisions, such as where to build new infrastructure or how to manage natural resources. Additionally, the data could be used in environmental studies to monitor changes in the landscape and to predict future trends. This rich dataset provides a wealth of opportunities for data-driven decision making and analysis.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. It is part of the unique identifier for each row in this version history table, together with the '_row_number' column.
_end_datedateThis column contains 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 represents the row number in the raw data extracted from the data source. Together with the '_start_date' column, it forms a combination that uniquely identifies each row in this version history table.
OBJECTIDlongThis column contains unique identification numbers for the objects in the dataset.
IDstringThis column stores unique identifiers for the elements in the dataset, prefixed with 'SE'.
CODE_12stringThis column contains specific codes associated with the dataset objects.
Area_HadoubleThis column represents the area of the objects in the dataset, measured in hectares.
RemarkstringThis column is reserved for any remarks or additional comments related to the dataset objects.
Shape_LengdoubleThis column is intended to store the length of the shape of the dataset objects.
Shape_AreadoubleThis column represents the area of the shape of the dataset objects.
geom_geojsonstringThis column contains the geometric representation of the dataset objects in GeoJSON format.
geom_geotextstringThis column stores the geometric representation of the dataset objects in text format.
geom_typestringThis column indicates the type of the geometric representation of the dataset objects.
geom_centroidstringThis column contains the centroid of the geometric representation of the dataset objects.
geom_center_xdoubleThis column represents the x-coordinate of the center of the geometric representation of the dataset objects.
geom_center_ydoubleThis column represents the y-coordinate of the center of the geometric representation of the dataset 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
Idd5efa873-9e17-4e0a-8b05-61a32d3f3cea
Package idaec689b3-8d6e-4322-88cd-6b96004c9ec7
Position5
Revision idba085134-35a4-4219-a8b5-248dcf893689
Stateactive
Tablenorrbotten_zip__clc12_72h_nv__history