Version History of Missing Surfaces Polygons in Surface Model
The table in question forms part of a dataset collection and serves as a history table, maintaining the version history of its base table rows. It keeps track of changes in the data over time. Each row in this table is uniquely identified by a combination of the starting date of the row's extraction from the data source and its row number. The table also includes an end date that indicates when a new version of the row was extracted. If the end date is not present, it signifies that the row is the most recent version.
The table contains geographic information, transformed from a shapefile format, which is a common format for storing geometric location and attribute information of geographic features. The geographic data can be points, lines, or polygons. The table is sourced from the 'Lantmäteriet' website, located in Sweden.
In terms of data analytics, this table could be very valuable. For instance, it can be used to analyze changes in geographic features over time, given its versioning capabilities. It could be used in environmental studies, for tracking changes in land use, or in urban planning, to study the evolution of city layouts. Furthermore, the table's data can be employed in predictive modeling, where the historical data is used to forecast future trends in geographic changes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
| _end_date | date | This column contains 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_number | long | This column contains the number of the row in the raw data extracted from the data source. It is used in conjunction with '_start_date' for unique identification of each row in this version history table. |
| id | long | This column contains the unique identifier of the row. |
| block | string | This column contains the block information. |
| flygfoto_o | string | This column contains data related to aerial photography 'o'. |
| flygfoto_a | long | This column contains data related to aerial photography 'a'. |
| upplosning | double | This column contains the resolution information. |
| area | long | This column contains area information. |
| geom_geojson | string | This column contains the geographic data in GeoJSON format. |
| geom_geotext | string | This column contains the geographic data in Geotext format. |
| geom_type | string | This column identifies the type of geographic data. |
| geom_centroid | string | This column contains the centroid of the geographic data. |
| geom_center_x | double | This column contains the x-coordinate of the geographic data center. |
| geom_center_y | double | This column contains the y-coordinate of the geographic data center. |
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 | 9fcb355f-aefe-48e1-af98-5d033b937ed4 |
| Package id | fb01266f-e918-49a0-8265-e32f4f0d1113 |
| Position | 1 |
| Revision id | c7fddf48-a1c2-4bfa-9c42-cb8061a91f2e |
| State | active |
| Table | utfall_ytmodell_saknade_ytor_shape_zip__ytmodell_saknade_ytor_polygoner__history |