Version History of Base Table Rows from a Swedish Geospatial Dataset Collection
The table in focus is a historical record of a base table, providing a version history of all its rows. It originates from the 'Lantmäteriet' (Land Survey) website in Sweden. This table carries additional features compared to its base table - the introduction of a start date and an end date. The start date denotes when a row was initially extracted from the data source, while the end date signifies when a newer version of that row was extracted. If the end date is not specified, it indicates that the row is the most recent version.
The table includes unique identifiers for each row, formed by combining the start date and the row number from the raw data. It also hosts geographic information, originally in shapefile format, but has since been transformed into a final geographic format. This geographic data could represent points, lines, or polygon areas.
This historical table can provide valuable insights for data analytics. For instance, it could be used to track changes in geographical features over time, providing crucial data for environmental studies. It could also be used in urban planning, where the evolution of land use can be analyzed. The data could also benefit historical researches, enabling the study of geographical and environmental changes over different periods.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row data was extracted from the data source. |
| _end_date | date | The date when a new version of the row data was extracted from the data source. A null value indicates that the row is the most recent version. |
| _row_number | long | The number of the row as it appears in the raw data extracted from the data source. This, in combination with the '_start_date' column, uniquely identifies each row in the history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identification number assigned to each data entry. |
| CODE_12 | string | A specific code associated with the data entry. |
| Area_Ha | double | The area measurement of the data entry, represented in hectares. |
| Remark | string | Any additional comments or notes regarding the data entry. |
| Shape_Leng | double | The length of the shape associated with the data entry. |
| Shape_Area | double | The area of the shape associated with the data entry. |
| geom_geojson | string | The geometric data of the shape associated with the data entry, represented in GeoJSON format. |
| geom_geotext | string | The geometric data of the shape associated with the data entry, represented in geotext format. |
| geom_type | string | The type of geometric shape associated with the data entry. |
| geom_centroid | string | The central point of the geometric shape associated with the data entry. |
| geom_center_x | double | The X-coordinate of the center of the geometric shape associated with the data entry. |
| geom_center_y | double | The Y-coordinate of the center of the geometric shape associated with the data entry. |
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 | |
| Adapter | shapefile |
| Country | se |
| Database | se_lantmateriet |
| Extract date | 2024-08-26 |
| Id | 162cab51-fd7c-4394-b79c-4b69ac25f9a3 |
| Package id | 75c6aab8-75b3-4d4f-8b22-3c7b3fb4eb0b |
| Position | 13 |
| Revision id | a426e4f8-d50f-4b7d-8a89-0970146b7529 |
| State | active |
| Table | orebro_zip__clc12_66f_nv__history |