Historical Version Records of Land Cover Changes in Norrbotten
The 'clc12_72h_sv__history' table is a historical data archive belonging to the 'norrbotten' dataset collection. As a history table, it carries the version history of its base table rows, which allows for tracking changes over time. This includes an additional two columns compared to its base table, indicating the start and end dates of each data entry. The start date and row number together form a unique identifier for each row in this version history table. If a row's end date is null, it indicates that the current row is the most recent version.
The table contains various types of data, including geographic information which has been transformed from the shapefile format. Shapefile, a simple non-topological format, stores the geometric location and attribute information of geographic features such as points, lines, or polygons.
This table is sourced from the Lantmäteriet (Land Survey) website in Sweden. It's a valuable resource for those interested in analyzing trend changes over time, tracking the history of data modifications, and studying geographic features in Sweden.
For instance, the data can be used to analyze geographic changes over time, track the development of certain areas in Sweden, or identify trends in land use. Moreover, it can cater to research in environmental science, urban planning, or geography. The unique identifiers in each row also allow for precise data tracking and verification, which can be significant in ensuring data integrity and accuracy.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column holds the date when the row was extracted from the data source. Together with '_row_number', it forms a 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 indicates 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 is part of the combination with '_start_date' that uniquely identifies each row in this version history table. |
OBJECTID | long | This column holds the object identifier. |
ID | string | This column contains the identifier. |
CODE_12 | string | This column holds the code 12. |
Area_Ha | double | This column contains the area in hectares. |
Remark | string | This column holds any remarks. |
Shape_Leng | double | This column contains the length of the shape. |
Shape_Area | double | This column holds the area of the shape. |
geom_geojson | string | This column contains the geometry of the object in GeoJSON format. |
geom_geotext | string | This column holds the geometry of the object in text format. |
geom_type | string | This column contains the type of geometry. |
geom_centroid | string | This column holds the centroid of the geometry. |
geom_center_x | double | This column contains the x-coordinate of the geometry's center. |
geom_center_y | double | This column holds the y-coordinate of the geometry's center. |
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 | 5c02c1ad-afff-42d3-bba6-1d4f9bcf6e1b |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 13 |
Revision id | 7ddfdda7-e8e9-4a78-889d-a820717511a9 |
State | active |
Table | norrbotten_zip__clc12_72h_sv__history |