Historical Versioning of Orthophoto Outcomes 2024

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

Click here for a data sample

The table in focus is a historical data table which is part of a larger dataset collection. It keeps track of the version history of base table rows with the help of specific columns that mark the start and end dates of each row. These dates indicate when the data row was extracted from the source and when a new version was subsequently extracted. The fact that a row is the latest version is indicated by a null value in the end date column.

In addition to the version tracking, the table also contains geographical information which has been converted from the shapefile format, a common format for storing geographical features. This geographical data can represent various geographical features like points, lines, or polygons (areas).

The data for this table is sourced from the website of Lantmäteriet, the Swedish mapping, cadastral and land registration authority, in Sweden. The unique combination of version tracking and geographical data makes this table useful for various data analytics applications.

For instance, the data could be used to track changes in geographical features over time, providing invaluable insights for environmental studies or urban planning. Similarly, the table could be used to analyze trends in land use, helping policymakers make informed decisions based on historical data. Moreover, the data could be used in machine learning models to predict future changes, thereby supporting strategic planning in various sectors.

Field Descriptions

Name Data type Description
_start_datedateThe date when the row was extracted from the source data. Together with '_row_number', this forms a unique identifier for each row in the version history table.
_end_datedateThe date when a new version of the row was extracted from the source data. If the value is null, it indicates that the row is the most recent version.
_row_numberlongThe number of the row in the raw data extracted from the source data. It forms a unique identifier for each row in combination with '_start_date'.
OMRPLANstringA column in the table about which no specific information was provided.
pixelstringA column in the table about which no specific information was provided.
geom_geojsonstringA column in the table about which no specific information was provided.
geom_geotextstringA column in the table about which no specific information was provided.
geom_typestringA column in the table about which no specific information was provided.
geom_centroidstringA column in the table about which no specific information was provided.
geom_center_xdoubleA column in the table about which no specific information was provided.
geom_center_ydoubleA column in the table about which no specific information was provided.

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
Id802f843d-950e-4d65-bff7-1077a7b9b8ee
Package id4be06f66-0cb5-4eb5-b3d1-cedb251d1810
Position1
Revision id8cafecf3-35be-42b1-a977-43afe137cebf
Stateactive
Tableutfall_ortofoto_shape_zip__utfall_ortofoto_2024__history