Historical Versioning of Land Structure Data

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

Click here for a data sample

The table under discussion is a historical record sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden. It is part of a larger dataset that encompasses related tables, reflecting an organized collection of data. This particular table is unique as it maintains the version history of its base table rows, providing an invaluable chronological perspective of data evolution.

Each row in this table is uniquely identified by a combination of the date when the row data was extracted and its raw data row number. The table also indicates the date when a new version of the row was extracted. This allows for tracking the changes in data over time. If there is no 'end date' specified for a row, it signifies that the version of the row is the most recent one.

Additionally, this table incorporates geographic information. Originally, this information was in the shapefile format, a common method for storing geometric location and attribute information of geographic features. However, the geographic data has been transformed into a more final, refined format.

In terms of data analytics, this table presents numerous possibilities. It could be utilized to track the temporal changes in geographic features, which can provide insights into environmental shifts or urban development patterns. The history of changes could also be used to predict future trends based on past data evolution. Furthermore, the geographic data could be employed to perform spatial analysis, allowing for a geographical perspective on the data. For example, it could be used to analyze the impact of certain geographic factors on the data under consideration. In essence, this table provides a historical, temporal, and spatial overview of data, opening up a wide range of analytical possibilities.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in this version 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 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 forms part of a unique identifier for each row when combined with '_start_date'.
OBJECTIDlongThis column contains a unique identifier for each object in the table.
IDstringThis column contains an identification code for each row in the table.
CODE_12stringThis column contains a specific code associated with each row in the table.
Area_HadoubleThis column contains the area measurement of the object, measured in hectares.
RemarkstringThis column contains any additional comments or remarks related to the row.
Shape_LengdoubleThis column contains the length of the shape associated with each row.
Shape_AreadoubleThis column contains the area of the shape associated with each row.
geom_geojsonstringThis column contains the geometric representation of the object in GeoJSON format.
geom_geotextstringThis column contains the geometric representation of the object in text format.
geom_typestringThis column indicates the type of geometric object associated with each row.
geom_centroidstringThis column contains the centroid of the geometric object associated with each row.
geom_center_xdoubleThis column contains the X coordinate of the center of the geometric object.
geom_center_ydoubleThis column contains the Y coordinate of the center of the geometric object.

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
Id0cb1a968-4460-4d4f-b8ec-79c7e46e2d9c
Package idde8a2b72-39b6-45ce-aea7-5d1acc49ae35
Position7
Revision ide05faa39-5846-47d5-bb71-559b533d4271
Stateactive
Tableostergotland_zip__clc12_64e_so__history