Version History Records of Geographical and Environmental Attributes
The 'clc12_73e_so__history' table is a historical dataset that is a part of the 'vasterbotten' collection. This table contains the version history of its base table rows, providing a comprehensive overview of how the data has evolved over time. Each row in this table is uniquely identified by a combination of its extraction date and a row number that corresponds to its position in the original raw data.
The table has two additional columns compared to its base table, indicating the start and end dates of each row's validity. If the end date is not specified, it implies that the given version of the row is the most recent one.
This table also includes geographic information derived from shapefiles, a popular format for storing geographic features such as points, lines, and polygons. However, in this dataset, the geographic data has been transformed from the shapefile format into a final format that is more suitable for data analytics.
The data in this table is sourced from Lantmäteriet (The Land Survey of Sweden), a website based in Sweden.
Potential applications of this data in analytics could include tracking changes in geographical features over time, analysing trends in the data's evolution, and even using the historical data to forecast future trends. Additionally, the geographic information contained in this dataset can be used in spatial analysis or geographic information system (GIS) modelling.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of the combination that 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 of this column is null, it means that the row is the most recent version of the row. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It is part of the combination that uniquely identifies each row in this version history table. |
| OBJECTID | long | This column is likely to contain a unique identifier for each object in the table. |
| ID | string | This column is likely to contain an identification number for each row in the table. |
| CODE_12 | string | The purpose of this column is not entirely clear without further context, but it may contain some type of code associated with each row. |
| Area_Ha | double | This column likely contains data about the area of an object, represented in hectares. |
| Remark | string | This column is likely to contain additional notes or comments related to each row. |
| Shape_Leng | double | This column likely contains data about the length of the shape associated with each row. |
| Shape_Area | double | This column is likely to contain data about the area of the shape associated with each row. |
| geom_geojson | string | This column likely contains geometrical data in GeoJSON format. |
| geom_geotext | string | This column likely contains geometrical data represented as text. |
| geom_type | string | This column likely describes the type of geometry associated with each row. |
| geom_centroid | string | This column likely contains data about the centroid of the geometry associated with each row. |
| geom_center_x | double | This column likely contains data about the x-coordinate of the center of the geometry associated with each row. |
| geom_center_y | double | This column likely contains data about the y-coordinate of the center of the geometry associated with each row. |
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 | 83931b9d-c3b0-4c61-9fdb-e4bd494016f8 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 33 |
| Revision id | d110d9b1-b667-4df6-9095-69fcbd188afb |
| State | active |
| Table | vasterbotten_zip__clc12_73e_so__history |