Historical Version Records of Uppsala Dataset Table

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

Click here for a data sample

This historical dataset table is part of a larger collection sourced from 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. It provides a version history of its base table rows, tracking changes over time. Each row in this table is uniquely distinguished by a combination of the extraction date and the row number from the original raw data.

The table records the date a row was extracted as well as the date when a new version of the same row was extracted. If the ending date is not specified, this indicates that the version of the row is the most recent.

Additionally, the table contains columns that contain geographic information, which has been transformed from the original shapefile format. Shapefile is a format used to store the geometric location and attribute information of geographic features, which can be points, lines, or polygons (areas).

This dataset could be valuable for a variety of data analytics purposes. For example, it could be used for analyzing temporal changes in geographic features, or for monitoring the evolution of a specific attribute over time. Another potential use could be to validate or verify the accuracy of the data by comparing different versions of the same row. This table, with its unique blend of temporal and geographic information, offers a wide range of possibilities for in-depth data analysis.

Field Descriptions

Name Data type Description
_start_datedateContains the date when the row was extracted from the data source. Together with '_row_number', this forms a unique identifier for each row in this version history table.
_end_datedateContains 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_numberlongContains the number of the row in the raw data extracted from the data source. Together with '_start_date', this forms a unique identifier for each row in this version history table.
OBJECTIDlongUnique identifier for each object within this table.
IDstringUnique identifier for each row within this table.
CODE_12stringContains a coded value that represents a certain type of data or information within the row.
Area_HadoubleThe area of the geographical feature represented by the row, measured in hectares.
RemarkstringContains any additional comments or observations associated with the data in the row.
Shape_LengdoubleThe length of the shape represented by the row. This could be the length of a feature's border or perimeter, for example.
Shape_AreadoubleThe area of the shape represented by the row. This could be the area of a feature's surface, for example.
geom_geojsonstringContains the geometric data of the row in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotextstringContains the geometric data of the row in text form.
geom_typestringSpecifies the type of the geometric data represented in the row, such as 'Point', 'LineString', or 'Polygon'.
geom_centroidstringThe central point of the geometric shape represented by the row.
geom_center_xdoubleThe X-coordinate of the center of the geometric shape represented by the row.
geom_center_ydoubleThe Y-coordinate of the center of the geometric shape represented by the row.

No sample for this dataset

Additional Information

Last updated August 26, 2024
Created August 26, 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
Id1119dab1-1d1e-4299-a83a-2f326962d149
Package id27592a39-b642-4ce0-8d0a-4b4a2e1d279c
Position1
Revision idf7f5c339-90dd-4d4d-b6a2-0db81222565e
Stateactive
Tableuppsala_zip__clc12_66f_so__history