Historical Version Records of Geospatial Data in Västerbotten Region
The 'clc12_70h_no__history' table is a history table, part of the 'vasterbotten' dataset collection, which contains version history of its base table rows. This table is characterized by unique combinations of a start date and row number, which allow for the identification of each row's version history.
The table includes information on when each row was extracted from the data source, indicated in a start date column, and when a new version of the row was extracted, indicated in an end date column. If the end date is null, this suggests that the row is the most recent version.
In addition to these time-related details, the table contains geographic information transformed from the shapefile format, a common format for storing geometric location and attribute information of geographic features. This geographic data can represent points, lines, or polygons (areas).
This table is sourced from the 'Lantmäteriet' website, based in Sweden.
As for its applications in data analytics, the table's time-series data can be used to track changes in geographic features over time, which could be useful in studies of land use or environmental change. The geographic data could also be used in spatial analysis, such as examining the distribution of particular features across an area or identifying patterns or anomalies in the data. Furthermore, the version history could be used to ensure data accuracy and integrity in analyses, by allowing for the checking and validation of data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | Contains the date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
| _end_date | date | 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 | Contains the number of the row in the raw data extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | Technical identifier of the object in the table. |
| ID | string | Unique identifier of the row in the table. |
| CODE_12 | string | Code associated with the row, specific to the data collection. |
| Area_Ha | double | Area of the geographical object represented by the row, measured in hectares. |
| Remark | string | Notes or comments related to the row. |
| Shape_Leng | double | Length of the shape of the geographical object represented by the row. |
| Shape_Area | double | Area of the shape of the geographical object represented by the row. |
| geom_geojson | string | Geographical representation of the object in GeoJSON format. |
| geom_geotext | string | Geographical representation of the object in text format. |
| geom_type | string | Type of the geographical object represented (e.g., point, polygon, line). |
| geom_centroid | string | Centroid of the geographical object represented. |
| geom_center_x | double | X coordinate of the center of the geographical object represented. |
| geom_center_y | double | Y coordinate of the center of the geographical object represented. |
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 | 3882bea6-08e1-437b-ba18-77de92a16407 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 5 |
| Revision id | fce146ae-b58a-464a-a047-23f0e2b98ed6 |
| State | active |
| Table | vasterbotten_zip__clc12_70h_no__history |