Version History of Base Table Rows in the Dataset Collection from Sweden

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

Click here for a data sample

This table resides within a larger dataset collection, exploring a rich history of data revisions. It provides a comprehensive version history of the base table's rows, each uniquely identified by a combination of a start date and a row number. This identification system helps users track the evolution of data over time, from the date it was initially extracted from the source until the creation of its latest version. If a row has a null end date, it implies that the data is the most current version.

The table's content has a geographical focus, originally sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The dataset's geographical information, initially in shapefile format, has been transformed into a final geographic format. Shapefiles help to store the geometric location and attribute information of geographical features, which can be represented as points, lines, or polygons.

The data in this table has a vast range of analytical possibilities. For example, it can be used to analyze spatial patterns over time, providing insights into geographical changes and trends. In environmental studies, it can assist in tracking land use changes. In infrastructure planning, the data can inform about historical developments, helping to predict future trends. Moreover, the version history can be used for auditing purposes or quality control, ensuring the data's integrity over time.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. Along with '_row_number', it uniquely identifies each row in the history version of the table.
_end_datedateThis column contains the date when a new version of the row was extracted from the data source. If the value in 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 '_start_date' to uniquely identify each row in the history version of the table.
OBJECTIDlongThis column contains a unique identifier for each object in the table.
IDstringThis column contains an identification number for each entry in the table.
CODE_12stringThis column contains specific codes associated with each row in the table.
Area_HadoubleThis column represents the area (in hectares) associated with each row.
RemarkstringThis column contains any additional remarks or notes pertaining to each row in the table.
Shape_LengdoubleThis column represents the length of the shape associated with each row.
Shape_AreadoubleThis column represents the area of the shape associated with each row.
geom_geojsonstringThis column contains the geometric representation of each row in GeoJSON format.
geom_geotextstringThis column contains the geometric representation of each row in textual format.
geom_typestringThis column indicates the type of geometry used to represent each row.
geom_centroidstringThis column contains the centroid of the geometry associated with each row.
geom_center_xdoubleThis column contains the X coordinate of the center of the geometry associated with each row.
geom_center_ydoubleThis column contains the Y coordinate of the center of the geometry associated with each 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
Id53793549-484a-4451-bfbe-df07ff266dc8
Package idc81a4f51-7faf-4d3d-8134-cd94ab4567c2
Position3
Revision id866aa2dc-48bd-42fa-8b57-46b77b01fbba
Stateactive
Tableblekinge_zip__clc12_62e_no__history