Version History of Base Table Rows in the Värmland Dataset Collection
This table is a historical record of geographical features sourced from 'Lantmäteriet' (The Land Survey of Sweden) website. It maintains a version history of its base table rows, with each row uniquely identified by a combination of a start date and a row number. The table contains information about when each row was extracted from the source data, along with the date when a new version of the row was extracted. If there is no end date, it indicates that the version of the row is the most recent. The table also includes geographical data, initially in the shapefile format, which has been transformed into the final geographic format. This format includes details such as the geometric location and attribute information of geographic features, which could be represented by points, lines, or polygons (areas).
The data in this table can be utilized in numerous ways in data analytics. For instance, it could be used to track changes in geographical features over time, allowing for a detailed analysis of geographical shifts and transformations. It could also be used to study the historical context of specific geographical areas, providing insights into how these areas have evolved. Additionally, the data could be used in predictive analytics, using historical trends to forecast future changes in geographical features.
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. |
_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 in the raw data extracted from the source. It is part of the unique identifier for each row in this version history table. |
OBJECTID | long | This column contains the unique identifier of the object in the table. |
ID | string | This column holds an identification number associated with each object. |
CODE_12 | string | This column contains specific codes associated with the objects in the table. |
Area_Ha | double | This column represents the area of the object in hectares. |
Remark | string | This column contains additional remarks or comments related to the object. |
Shape_Leng | double | This column holds the length of the object's shape. |
Shape_Area | double | This column holds the area of the object's shape. |
geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the object in text format. |
geom_type | string | This column indicates the type of geometry used for representing the object. |
geom_centroid | string | This column contains the centroid, or geometric center, of the object. |
geom_center_x | double | This column holds the x-coordinate of the object's center. |
geom_center_y | double | This column holds the y-coordinate of the object'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 | 2e1f5e9b-6da1-4e80-86b4-ae648cdbd425 |
Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
Position | 5 |
Revision id | b78ce5e9-0739-42f7-bc07-0ead7f9bbe56 |
State | active |
Table | varmland_zip__clc12_65e_nv__history |