Version History of Base Table Rows in Uppsala Dataset Collection

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

Click here for a data sample

This table is a historical record of a dataset sourced from Lantmäteriet, the National Land Survey of Sweden. It provides a comprehensive version history of its base table rows, offering a unique combination of start date and row number to identify each row in this history table. The start date indicates when the row was extracted from the data source, while the end date shows when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version.

The table contains various geographic details, originally in shapefile format—a common standard for storing geometric location and attribute information of geographic features—which have been transformed into a final format. The geographic features could be represented by points, lines, or polygons (areas).

This table could be utilized in several ways in data analytics. For example, it could be used to track changes in geographical features over time, given its historical nature. This can offer valuable insights for environmental studies or urban planning. Additionally, the unique identifiers for each row enable easy tracking and comparison of data versions, which can be useful in maintaining data integrity and ensuring accurate analysis. The geographic information could be used in mapping or spatial analysis, offering a basis for geographical distribution studies or location-based market analysis.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this history table.
_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 means the row is the most recent version.
_row_numberlongThis column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table.
OBJECTIDlongThis column contains the object identifier.
IDstringThis column contains the identifier of the object.
CODE_12stringThis column contains the 12-digit code of the object.
Area_HadoubleThis column contains the area of the object in hectares.
RemarkstringThis column contains any additional remarks or notes about the object.
Shape_LengdoubleThis column contains the length of the shape of the object.
Shape_AreadoubleThis column contains the area of the shape of the object.
geom_geojsonstringThis column contains the geometry of the object in GeoJSON format.
geom_geotextstringThis column contains the geometry of the object in geotext format.
geom_typestringThis column contains the type of the geometry of the object.
geom_centroidstringThis column contains the centroid of the geometry of the object.
geom_center_xdoubleThis column contains the X-coordinate of the center of the geometry of the object.
geom_center_ydoubleThis column contains the Y-coordinate of the center of the geometry of the object.

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
Id953ac9ae-d750-44f3-b39d-1a24e44654f6
Package id27592a39-b642-4ce0-8d0a-4b4a2e1d279c
Position4
Revision idfe2a537a-0eff-4036-bffc-ff7d276578fa
Stateactive
Tableuppsala_zip__clc12_66f_no__history