Historical Version Archive of Geospatial Elements in Sweden Dataset
The table under consideration forms part of a larger dataset collection and serves as a history table, maintaining a comprehensive record of the version history of its base table rows. This table has been enriched with two additional columns that capture the date of extraction from the data source and the date at which a new version of the row was extracted. These dates are utilised in conjunction to form a unique identifier for each row in this version history table.
Additionally, the table includes a column that enumerates the rows as they appear in the raw data from the data source. This table houses geographic information, originally in the shapefile format, which has been transformed into its final format. The geographic features are represented in various forms such as points, lines, or polygons.
The data within this table is sourced from 'Lantmäteriet' (The Land Survey) website in Sweden. Given its rich and detailed data, this table can potentially be used in various data analytics applications. For instance, it could be used to track changes in land use over time by examining the version history. Alternatively, it could be used in spatial analytics to understand the geographic distribution of certain features. It could also potentially be used in predictive modelling, leveraging the version history to forecast future trends.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value of this column is null, it means 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, in combination with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identifier for each element in the table. |
| CODE_12 | string | A code associated with each row in the table. |
| Area_Ha | double | The area measurement of the element in hectares. |
| Remark | string | An additional comment or note about the row. |
| Shape_Leng | double | The length of the shape represented by the row. |
| Shape_Area | double | The area of the shape represented by the row. |
| geom_geojson | string | The geometric representation of the element in GeoJSON format. |
| geom_geotext | string | The geometric representation of the element in text format. |
| geom_type | string | The type of the geometric element. |
| geom_centroid | string | The centroid of the geometric element. |
| geom_center_x | double | The x-coordinate of the center of the geometric element. |
| geom_center_y | double | The y-coordinate of the center of the geometric element. |
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 | 4b42e37c-368d-4c13-8b0a-63e87e4b899f |
| Package id | bbf0f771-09e4-48c5-ad18-8e4657b466e0 |
| Position | 3 |
| Revision id | cd71719d-45dd-4c37-b87c-d7c9fbbd5d6e |
| State | active |
| Table | halland_zip__clc12_62e_nv__history |