Historical Versions of Land Classification Data in Västra Götaland Region
The history table under consideration is a part of a dataset collection and provides an extensive track of version history of its base table rows. It maintains a unique identification for each row using a combination of the date when the row was extracted and the row number. The table also maintains the date when a new version of the row was extracted, assisting in identifying the most recent version of a row.
The table provides detailed geographic information transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information can include points, lines, or polygons (areas).
The table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The information in this table could be highly useful for data analytics in various ways. For instance, it could be used to track changes in geographical features over time, providing valuable insights for environmental studies, urban planning, or infrastructure development. Additionally, the version history could be used in trend analysis or predictive modeling, by understanding how specific data points have evolved over time. The table's geographic information could also be utilized in spatial analytics, providing critical inputs for decision making in sectors like logistics, real estate, or transportation planning.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was initially extracted from the data source. It forms a unique identifier for each row in combination with '_row_number'. |
_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 means that the row is the most recent version. |
_row_number | long | This column contains the number of the row as it was in the raw data extracted from the data source. It forms a unique identifier for each row in combination with '_start_date'. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains a unique ID for each object in the table. |
CODE_12 | string | This column contains a code associated with each object in the table. |
Area_Ha | double | This column contains the area of each object, measured in hectares. |
Remark | string | This column contains any remarks or additional information about 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 GeoJSON representation of each object's geometry. |
geom_geotext | string | This column contains a textual representation of each object's geometry. |
geom_type | string | This column contains the type of geometry for each object. |
geom_centroid | string | This column contains the centroid of each object's geometry. |
geom_center_x | double | This column contains the x-coordinate of the center of each object's geometry. |
geom_center_y | double | This column contains the y-coordinate of the center of each object's geometry. |
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 | 0d473597-8b54-45e5-9d88-ff0d781d80d7 |
Package id | 60f2a9ad-e1f7-4dc9-a918-721986a483be |
Position | 3 |
Revision id | 47873be9-0d0b-4dae-bd0d-0258218dd103 |
State | active |
Table | vastra_gotaland_zip__clc12_63e_nv__history |