Historical Versioning of Orthophoto Outcomes 2024
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_date | date | The 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_date | date | The 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_number | long | The 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'. |
OMRPLAN | string | A column in the table about which no specific information was provided. |
pixel | string | A column in the table about which no specific information was provided. |
geom_geojson | string | A column in the table about which no specific information was provided. |
geom_geotext | string | A column in the table about which no specific information was provided. |
geom_type | string | A column in the table about which no specific information was provided. |
geom_centroid | string | A column in the table about which no specific information was provided. |
geom_center_x | double | A column in the table about which no specific information was provided. |
geom_center_y | double | A 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 | |
Adapter | shapefile |
Country | se |
Database | se_lantmateriet |
Extract date | 2024-08-26 |
Id | 802f843d-950e-4d65-bff7-1077a7b9b8ee |
Package id | 4be06f66-0cb5-4eb5-b3d1-cedb251d1810 |
Position | 1 |
Revision id | 8cafecf3-35be-42b1-a977-43afe137cebf |
State | active |
Table | utfall_ortofoto_shape_zip__utfall_ortofoto_2024__history |