History Version Records 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

The table in question is a historical record that is part of a larger dataset collection. It captures the version history of its base table rows, allowing for tracking of changes over time. Each row in the table is uniquely identified by a combination of the extraction date and the row number in the original raw data. This table has two additional columns compared to its base table which capture the start and end dates of each entry. If the end date is null, it signifies that the entry is the most recent version. The table also incorporates geographic information that has been transformed from the original shapefile format. The shapefile is a geospatial vector data format for geographic information system (GIS) software and it can represent geographic features as points, lines, or polygons. This table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey).

This data could be utilized in a variety of ways in data analytics. For instance, the chronological data can be used to analyze trends over time or to track changes in geographic features. The geographic data can be utilized in spatial analysis or GIS applications, such as mapping changes in land usage or identifying patterns in geographic distribution. Additionally, the version history can be used in data quality management, by enabling the tracking of changes and identification of any anomalies or inconsistencies in the data over time.

Field Descriptions

Name Data type Description
_start_datedateThis column represents the date when the row was extracted from the data source. It forms part of the unique identifier for each row in this version history table, along 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 contains the number of the row as it appears in the raw data extracted from the data source. It, along with the '_start_date' column, uniquely identifies each row in this version history table.
OBJECTIDlongThis column represents a unique identifier for each object in the table.
IDstringThis column represents the unique ID assigned to each entry.
CODE_12stringThis column contains a code related to the data row.
Area_HadoubleThis column represents the area of the data entry in hectares.
RemarkstringThis column contains any remarks or additional information related to the data row.
Shape_LengdoubleThis column represents the length of the shape related to the data entry.
Shape_AreadoubleThis column represents the area of the shape related to the data entry.
geom_geojsonstringThis column contains the geographical data of the entry in GeoJSON format.
geom_geotextstringThis column contains the geographical data of the entry in text format.
geom_typestringThis column identifies the type of geographical data represented (e.g., point, line, polygon).
geom_centroidstringThis column contains the centroid of the geographical data.
geom_center_xdoubleThis column represents the X coordinate of the center of the geographical data.
geom_center_ydoubleThis column represents the Y coordinate of the center of the geographical data.

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
Id15943994-5134-4864-828f-6a6281c66bfc
Package idaec689b3-8d6e-4322-88cd-6b96004c9ec7
Position47
Revision idf219d9c3-bad3-4002-b654-6a92d6d7d974
Stateactive
Tablenorrbotten_zip__clc12_75f_so__history