Version History of Base Table Rows in Norrbotten Dataset Collection
This history table is part of a dataset from the Lantmäteriet (The Land Survey) in Sweden. It archives the version history of its base table rows, keeping track of changes over time. Each entry is uniquely identified by a combination of the date of extraction and a row number. The table provides a rich set of geographic data, originally in shapefile format, that has since been transformed into the final geographic format. The geographic data represent various geographical features which could be points, lines, or polygons (areas).
The table contains a variety of information including identifiers, codes, the area in hectares, and geographical data. The table includes dates indicating when the row was extracted from the data source and when a new version of the row was extracted. If the latter is null, it indicates that the row is the most recent version. The table also includes a column for remarks, although this often returns null values.
The data in this table could be utilized in numerous ways in data analytics. For example, it could be used to track changes in geographical features over time, such as the expansion of an urban area or the shrinkage of a forested region. The data could also be used to inform planning decisions, such as where to build new infrastructure or how to manage natural resources. Additionally, the data could be used in environmental studies to monitor changes in the landscape and to predict future trends. This rich dataset provides a wealth of opportunities for data-driven decision making and analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It is part of the unique identifier for each row in this version history table, together with the '_row_number' column. |
_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 represents the row number in the raw data extracted from the data source. Together with the '_start_date' column, it forms a combination that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains unique identification numbers for the objects in the dataset. |
ID | string | This column stores unique identifiers for the elements in the dataset, prefixed with 'SE'. |
CODE_12 | string | This column contains specific codes associated with the dataset objects. |
Area_Ha | double | This column represents the area of the objects in the dataset, measured in hectares. |
Remark | string | This column is reserved for any remarks or additional comments related to the dataset objects. |
Shape_Leng | double | This column is intended to store the length of the shape of the dataset objects. |
Shape_Area | double | This column represents the area of the shape of the dataset objects. |
geom_geojson | string | This column contains the geometric representation of the dataset objects in GeoJSON format. |
geom_geotext | string | This column stores the geometric representation of the dataset objects in text format. |
geom_type | string | This column indicates the type of the geometric representation of the dataset objects. |
geom_centroid | string | This column contains the centroid of the geometric representation of the dataset objects. |
geom_center_x | double | This column represents the x-coordinate of the center of the geometric representation of the dataset objects. |
geom_center_y | double | This column represents the y-coordinate of the center of the geometric representation of the dataset 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 | d5efa873-9e17-4e0a-8b05-61a32d3f3cea |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 5 |
Revision id | ba085134-35a4-4219-a8b5-248dcf893689 |
State | active |
Table | norrbotten_zip__clc12_72h_nv__history |