Historical Version Records of Geospatial Data in Vasterbotten Dataset Collection
The 'clc12_72g_sv__history' table belongs to the 'vasterbotten' dataset collection. This history table records the version history of the base table rows, thereby providing a comprehensive overview of changes over time. It features a set of columns that include unique identifiers for each row, dates indicating when the data was extracted and updated, and geographical data transformed from the shapefile format.
The table's unique attribute is its ability to track changes in data over time, with each row being uniquely identified by a combination of the date of extraction and a row number. This feature allows users to track the evolution of data and identify trends or anomalies over time.
Another notable feature of this table is its inclusion of geographical data. This data, originally in shapefile format, has been transformed into a more compatible format for ease of use. This allows for the geographical visualization of data, which can be especially useful in spatial analytics.
The table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden. This indicates that the data has been collected with a high level of precision, and likely includes valuable insights into the geographical features of the region.
In terms of data analytics, this table could be incredibly useful. For instance, changes in geographical features over time could be tracked and analyzed, providing valuable insights for environmental studies. Additionally, the data could be used in predictive modeling to forecast future changes based on historical trends. Furthermore, the geographical data could be utilized in spatial analytics, allowing for a visual representation of data and aiding in the understanding of spatial patterns and relationships.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify 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 indicates 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 forms a unique combination with '_start_date' to identify each row in this version history table. |
| OBJECTID | long | This column contains unique identifiers for each object in the table. |
| ID | string | This column contains internal identifiers for each object in the table. |
| CODE_12 | string | This column contains specific codes associated with each object in the table. |
| Area_Ha | double | This column contains the area of each object in hectares. |
| Remark | string | This column contains any additional notes or remarks related to each object. |
| Shape_Leng | double | This column contains the length of the shape of each object. |
| Shape_Area | double | This column contains the area of the shape of each object. |
| geom_geojson | string | This column contains the geometric representation of each object in the GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of each object in text format. |
| geom_type | string | This column indicates the type of geometric representation used for each object. |
| geom_centroid | string | This column contains the centroid of the geometric representation of each object. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric representation of each object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric representation of each object. |
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 | bcc92cf3-32e3-4e2d-945e-e97108943032 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 29 |
| Revision id | 22586907-3ce0-411a-8b07-80c4cc42baa2 |
| State | active |
| Table | vasterbotten_zip__clc12_72g_sv__history |