Version History of Base Table Rows in the Uppsala 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 part of a dataset collection and serves as a history table, maintaining the version history of its base table rows. Originating from the 'Lantmäteriet' website based in Sweden, it includes various data points structured in a tabular format, consisting of columns and rows.

Key features of the table involve entries, such as a unique row number and start date, which together uniquely identify each row in the version history. It also tracks the timeline of data extraction with a start and end date for each row. If the end date is null, it signifies that the row is the most current version.

The table also contains geographic data transformed from the shapefile format, a standard for storing geometric location and attribute details of geographic features. These could be points, lines, or polygons (areas), offering a versatile range of geographic information.

In terms of data analytics, the table could serve numerous purposes. For instance, the version history can be used to track changes over time, allowing analysts to monitor trends or anomalies. Additionally, the geographic data can be utilized in spatial analytics, like identifying patterns or relationships within the geographic features. Furthermore, the timeline of data extraction can be useful in understanding data collection processes, aiding in improvements and optimization of these processes.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the specific row was extracted from the data source. It is used in combination with the '_row_number' column to uniquely identify each row in this history table.
_end_datedateThis column contains the date when a new version of the specific row was extracted from the data source. If the value of this column is null, it indicates that 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. It is used in combination with the '_start_date' column to uniquely identify each row in this history table.
OBJECTIDlongThis column contains an identification number for each object in the dataset. It is typically a unique identifier.
IDstringThis column contains an identification number or code, usually unique, associated with each record in the table.
CODE_12stringThis column contains specific codes related to the data in the table. The meaning of these codes is usually defined by the data provider.
Area_HadoubleThis column contains information about the area of each data item, measured in hectares.
RemarkstringThis column is reserved for any notes or additional information about the data in the row.
Shape_LengdoubleThis column contains the length of the shape associated with each data item.
Shape_AreadoubleThis column contains the area of the shape associated with each data item.
geom_geojsonstringThis column contains the geometric data in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotextstringThis column contains the geometric data in plain text format.
geom_typestringThis column indicates the type of the geometric data (e.g., point, line, polygon).
geom_centroidstringThis column contains the centroid of the geometric data. The centroid is the geometric center of a plane figure or shape.
geom_center_xdoubleThis column contains the x-coordinate of the geometric center of a shape.
geom_center_ydoubleThis column contains the y-coordinate of the geometric center of a shape.

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
Idbf3391bd-e33d-4256-bc4b-6f485827b591
Package id27592a39-b642-4ce0-8d0a-4b4a2e1d279c
Position8
Revision id8638a694-2284-4f06-97c3-09ee9fb744ea
Stateactive
Tableuppsala_zip__clc12_66h_nv__history