Version History of Geospatial Data Elements in Södermanland Dataset Collection

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

Click here for a data sample

The 'clc12_65f_no__history' table is a comprehensive history table that forms part of the 'sodermanland' dataset collection. As a history table, it holds the version history for each of its base table rows, allowing for the tracking of changes over time. This table boasts unique identifiers for each row, which are formed by a combination of the row's start date and its number in the raw data.

This table contains key date columns that provide valuable insights into the data's timeline. For instance, it has a start date column indicating when each row was extracted from the data source, and an end date column marking when a new version of the row was extracted. If the end date column shows a null value, it signifies that the row is the most current version.

Geographical information is another crucial feature of this table, which was initially in the shapefile format and was later transformed into the final geographic format. The shapefile format is a simple, non-topological format for storing the geometric location and attribute information of geographic features, which can be represented as points, lines, or polygons.

This table has been sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The data from this table can be instrumental in various data analytics applications. For instance, it could be used to track changes in geographic features over time, identify trends or anomalies in the data, or even to predict future changes based on historical trends. Furthermore, the table could also serve as a valuable resource for research in fields such as environmental studies, urban planning, and geography.

Field Descriptions

Name Data type Description
_start_datedateThis column indicates the date when the row was extracted from the data source. It is part of a combination that uniquely identifies each row in this version history table.
_end_datedateThis column indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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. Together with '_start_date', it forms a combination that uniquely identifies each row in this version history table.
OBJECTIDlongThis column contains the unique identifier of the object in the table.
IDstringThis column contains an identification value for the object.
CODE_12stringThis column contains a specific code associated with the object.
Area_HadoubleThis column represents the area of the object in hectares.
RemarkstringThis column may contain additional comments or remarks about the object.
Shape_LengdoubleThis column indicates the length of the shape of the object.
Shape_AreadoubleThis column represents the area of the shape of the object.
geom_geojsonstringThis column contains the geographical data of the object in GeoJSON format.
geom_geotextstringThis column contains the geographical data of the object in plain text format.
geom_typestringThis column indicates the type of the geographical data of the object.
geom_centroidstringThis column contains the centroid of the geographical data of the object.
geom_center_xdoubleThis column contains the x-coordinate of the center of the geographical data of the object.
geom_center_ydoubleThis column contains the y-coordinate of the center of the geographical data of the 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
Id8a07d62c-045c-4818-a7e9-75ed6896e882
Package ide88c5cab-003c-4619-92cb-135e8e103dc2
Position3
Revision idd3ee063a-ba20-4d83-b4ca-916834aadeb7
Stateactive
Tablesodermanland_zip__clc12_65f_no__history