Version History of Geospatial Records in Gavleborg Collection
The table in question is a historical record type, sourced from the 'Lantmäteriet' (The Land Survey) website, based in Sweden. It is a component of a larger dataset collection. This table is essentially a record of past versions of its corresponding base table. It includes specific columns for recording the dates of data extraction from the source, as well as the dates of any new versions of the data.
The table uniquely identifies each row using a combination of the date of extraction and the row number from the original raw data. If a row is the most current version, the date of the new version will be left blank.
This table also contains geographical information, originally in the shapefile format, which is a common format for storing geographical feature data. These features can be represented as points, lines, or polygons (areas). In this table, the geographical data has been transformed from the shapefile format into its final format.
Given the nature of the data in this table, it could be used in data analytics in a variety of ways. For example, it could be used to track changes in geographical features over time, providing valuable insights for environmental studies or urban planning. Additionally, the version history information could be used to verify the accuracy of data extraction and transformation processes, or to identify any patterns or anomalies in the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column forms a unique identifier in combination with the '_row_number'. |
| _end_date | date | The date when a new version of the row was extracted from the data source. 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 data source. This column forms a unique identifier in combination with the '_start_date'. |
| OBJECTID | long | A unique identifier of the object in the dataset. |
| ID | string | A unique identifier of the entity in the dataset. |
| CODE_12 | string | A code representing a specific attribute or characteristic of the entity. |
| Area_Ha | double | The area of the entity in hectares. |
| Remark | string | Any additional comments or remarks related to the entity. |
| Shape_Leng | double | The length of the shape of the entity. |
| Shape_Area | double | The area of the shape of the entity. |
| geom_geojson | string | The geometry of the entity represented in GeoJSON format. |
| geom_geotext | string | The geometry of the entity represented in text format. |
| geom_type | string | The type of the geometry of the entity. |
| geom_centroid | string | The centroid of the geometry of the entity. |
| geom_center_x | double | The x-coordinate of the center of the geometry of the entity. |
| geom_center_y | double | The y-coordinate of the center of the geometry of the entity. |
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 | 0a1fcf0e-1323-439d-ab54-00482c58b58f |
| Package id | 79417cf1-463f-47d0-a7ee-b3e1ee603243 |
| Position | 5 |
| Revision id | 097cdc9e-93b1-4b0d-9c5c-8cbb3c131152 |
| State | active |
| Table | gavleborg_zip__clc12_67g_nv__history |