Historical Version Records of Norrbotten Dataset's Base Table
This is a history table, which contains the version history of its base table rows. It's a part of a larger dataset collection and has been sourced from the Lantmäteriet (National Land Survey) website of Sweden. The table is unique in its structure, having two additional columns compared to its base table. These additional columns represent the start and end dates, indicating when each row was extracted from the data source and when a newer version of the same row was extracted, respectively. If the end date value is null, it signifies that the row is the most recent version. Another distinctive feature of this table is the unique identifier for each row, a combination of the start date and the row number.
This table is rich in geographic information, which originates from a shapefile format - a standard for storing geometric location and attribute information of geographic features. It has undergone a transformation to achieve its final geographic format.
The data within this table could serve various purposes in data analytics. For instance, it could be used in time-series analysis to track changes in geographic features over time. It could also be useful in spatial analysis for studying patterns and relationships within geographic data. Furthermore, by leveraging the version history data, analysts could conduct intricate studies into the evolution of individual geographic features over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Together with the '_row_number' column, they form a unique identifier for 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 is null, it indicates that the row is the most recent version. |
_row_number | long | This column holds the number of the row as it appears in the raw data extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date' column. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains another form of identification for the objects in the table. |
CODE_12 | string | This column contains specific codes associated with the objects in the table. |
Area_Ha | double | This column contains the area of the objects in the table, measured in hectares. |
Remark | string | This column contains any additional remarks or comments related to the objects in the table. |
Shape_Leng | double | This column contains the length of the shape of the objects in the table. |
Shape_Area | double | This column contains the area of the shape of the objects in the table. |
geom_geojson | string | This column contains the GeoJSON representation of the geometry of the objects. |
geom_geotext | string | This column contains the text representation of the geometry of the objects. |
geom_type | string | This column contains the type of the geometry of the objects. |
geom_centroid | string | This column contains the centroid of the geometry of the objects. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometry of the objects. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometry 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 | 7d333058-615b-4e9b-906e-1a423673925d |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 23 |
Revision id | 2ec757df-ca5a-43be-8ea7-4f3d13e9cd1f |
State | active |
Table | norrbotten_zip__clc12_74g_no__history |