Version History of Land Cover Changes in Norrbotten Dataset
The table in question forms part of the 'norrbotten' dataset and primarily serves as a historical log of various geographical features. This history table records the version history of its base table rows, marking the beginning and end dates for each version of a row. The beginning date signifies when the row was extracted from the data source, while the end date indicates when a new version of the row was extracted. A null value in the end date column signifies that the current version of the row is the most recent one. This system of tracking changes enables users to keep track of historical data changes and trends over time.
The table contains geographical information, which is initially stored in the shapefile format before being transformed into the final geographic format. This geographical data can be represented by points, lines, or polygons (areas). The table also maintains a unique identifier for each row, combining the start date and the row number.
This table, sourced from 'Lantmäteriet' (The Land Survey) in Sweden, could prove to be a valuable asset for data analytics in various fields. For instance, urban planners and environmental scientists could use this data to study land use patterns over time, tracking changes in land cover and use. The data could also be used in predictive modeling, forecasting future land use based on historical trends. Furthermore, government agencies could use this data to monitor compliance with land use regulations, identifying any notable changes or anomalies over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column represents the date when the data row was initially extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table. |
_end_date | date | This column contains the date when a new version of the data row was extracted from the data source. If this value is null, it signifies that the row is the current version. |
_row_number | long | This column holds the raw data row number from the data source. It forms a unique identifier in combination with the '_start_date' column for each row in this version history table. |
OBJECTID | long | This column contains the unique identifier for each object in the dataset. |
ID | string | This column holds the unique identification code for each object, following a specific pattern unique to the dataset. |
CODE_12 | string | This column contains specific codes associated with the objects in the dataset. |
Area_Ha | double | This column represents the area of each object in the dataset measured in hectares. |
Remark | string | This column is designated for any additional notes or remarks about the objects in the dataset. |
Shape_Leng | double | This column holds the geometric length of the objects in the dataset. |
Shape_Area | double | This column contains the geometric area of the objects in the dataset. |
geom_geojson | string | This column contains the geometric representation of the objects in GeoJSON format, a widely used format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geometric representation of the objects in textual format. |
geom_type | string | This column specifies the type of the geometric representation of the objects. |
geom_centroid | string | This column contains the geometric center point (centroid) of the objects. |
geom_center_x | double | This column represents the X-coordinate of the geometric center point of the objects. |
geom_center_y | double | This column represents the Y-coordinate of the geometric center point of the objects. |
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 | df9af9f6-87d0-4f63-bccc-5a77ee49fffb |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 11 |
Revision id | 8c23522f-bd3e-49c0-bbe5-e09fe55643fc |
State | active |
Table | norrbotten_zip__clc12_72h_no__history |