History Version of Base Table Rows With Geographical Attributes

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

Click here for a data sample

This historical table, originating from the dataset collection 'ostergotland', has been sourced from 'Lantmäteriet' (The Land Survey) website in Sweden. This database table provides a detailed version history of its base table rows, displaying data from when it was first extracted from the data source to the most recent extraction.

Each row in the table is unique and can be identified by a combination of the date of extraction and the row number. Therefore, if the same data have been extracted multiple times, each extraction will have its own unique entry in the table, allowing for a comprehensive chronological tracking of changes. If a row does not have an end date, this indicates that it is the most recent version of the data.

Geographic information is also included in the table, having been transformed from the shapefile format. This allows for the representation of geographic features such as points, lines, or polygons, providing a broad spectrum of geographical data.

This table could be invaluable in a number of data analytics applications. For example, it could be used to track land use changes over time, providing crucial data for environmental impact studies. Additionally, the table could be utilized to analyze trends in geographical features, assisting in urban planning and development projects. Furthermore, the historical nature of the data allows for the prediction of future patterns and trends, enabling proactive decision-making in a variety of fields.

Field Descriptions

Name Data type Description
_start_datedateThis column records the date when the data row was extracted from the data source. Along with '_row_number', it helps to uniquely identify each row in this version history table.
_end_datedateThis column records 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 row number as it appears in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table.
OBJECTIDlongThis column assigns a unique object identifier to each row in the table.
IDstringThis column contains the unique identification number for each data entry.
CODE_12stringThis column holds a unique code that corresponds to specific data entries.
Area_HadoubleThis column records the area of the geographical feature in hectares.
RemarkstringThis column contains any additional comments or notes regarding the data entry.
Shape_LengdoubleThis column records the length of the shape of the geographical feature.
Shape_AreadoubleThis column records the area of the shape of the geographical feature.
geom_geojsonstringThis column holds the geographical feature in GeoJSON format, a widely used open standard format designed for representing simple geographical features.
geom_geotextstringThis column holds the geographical feature in a textual format.
geom_typestringThis column states the type of the geographical feature.
geom_centroidstringThis column contains the centroid, or the geometric center, of the geographical feature.
geom_center_xdoubleThis column contains the x-coordinate of the center of the geographical feature.
geom_center_ydoubleThis column contains the y-coordinate of the center of the geographical feature.

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
Id92e5b36b-703b-4bb7-94a7-74907c1ab449
Package idde8a2b72-39b6-45ce-aea7-5d1acc49ae35
Position11
Revision id267f7841-91d5-4ff4-ae5f-24eb6ce8401e
Stateactive
Tableostergotland_zip__clc12_64f_nv__history