Historical Version Records of Base Table Rows in Norrbotten Dataset

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

Click here for a data sample

The history table is part of a dataset collection hailing from Norrbotten. It contains the version history of its base table rows, with unique identifiers being the combination of the row's start date and its position in the raw data sequence. Each row's history starts with the date it was extracted from the data source, and ends with the date a new version was extracted. If the end date is null, this indicates that the row is the most current version. Geographical data is translated from the shapefile format, which is a format for storing the geometric location and attribute information of geographic features, into the final geographic format. The table is sourced from 'Lantmäteriet' (The Land Survey of Sweden) in Sweden.

The data in this table can be leveraged in a variety of ways for data analytics. For instance, the version history can be used to track changes over time, which could be useful in understanding trends or patterns. The geographical data could be used to create visual maps or to conduct spatial analysis, such as determining the proximity of different points, or understanding patterns in the geographic distribution of the data. The row number and start date could potentially be used to debug data extraction issues or to monitor the data extraction process over time.

Field Descriptions

Name Data type Description
_start_datedateThis column holds the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number'
_end_datedateThe '_end_date' 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 signifies that the row is the most recent version.
_row_numberlongThe '_row_number' 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'.
IDstringThe 'ID' column is used to store the unique identifier assigned to each row.
CODE_06stringThe 'CODE_06' column is used to represent specific code information related to the data row.
Area_HadoubleThe 'Area_Ha' column represents the area in hectares.
RemarkstringThe 'Remark' column is used to store any additional notes or remarks related to the data row.
Shape_LengdoubleThe 'Shape_Leng' column represents the length of the shape.
Shape_AreadoubleThe 'Shape_Area' column represents the area of the shape.
geom_geojsonstringThe 'geom_geojson' column stores the geometric data in GeoJSON format.
geom_geotextstringThe 'geom_geotext' column stores the geometric data in text format.
geom_typestringThe 'geom_type' column indicates the type of geometric data.
geom_centroidstringThe 'geom_centroid' column contains the centroid of the geometric shape.
geom_center_xdoubleThe 'geom_center_x' column represents the x-coordinate of the geometric shape's center.
geom_center_ydoubleThe 'geom_center_y' column represents the y-coordinate of the geometric shape'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
Id7c2a1a85-e383-4953-97b4-ba588c4c6362
Package idaec689b3-8d6e-4322-88cd-6b96004c9ec7
Position41
Revision idd5d96e86-63fa-4e70-a9c7-3d7e6236f06a
Stateactive
Tablenorrbotten_zip__06_75fso__history