Version History of Base Table Rows in Varmland Dataset
The 'clc12_65d_nv__history' table is a historical data table belonging to the 'varmland' dataset collection. This table contains the version history of its base table rows, distinguishing it by the presence of two unique columns: the start date and the end date of the row extraction from the data source. The combination of the start date and row number uniquely identifies each row in this table.
The table provides geographical data which initially was in the shapefile format. After transformation, this data now includes various geometric details such as location, area, length, and types of geographic features, which can be represented as points, lines, or polygons. The table also contains a unique object identifier, a remark, and a specific code for each entry.
This table is sourced from the Lantmäteriet website, which is based in Sweden.
In terms of data analytics, this table can be particularly useful in various ways. For instance, the version history can be used to track changes in the geographical features over time, providing a powerful tool for environmental studies. Additionally, the geographical data can be used for spatial analysis, such as identifying patterns or anomalies in the geographical distribution of features. Furthermore, the date information can provide temporal trends, which can be valuable in predictive modeling.
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, it forms 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 contains the number of the row in the raw data extracted from the data source. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table. |
OBJECTID | long | This column contains the unique object identifier. |
ID | string | This column contains the unique identifier. |
CODE_12 | string | This column contains a specific code related to the data. |
Area_Ha | double | This column contains the area measured in hectares. |
Remark | string | This column contains any remarks or comments related to the row. |
Shape_Leng | double | This column contains the length of the shape. |
Shape_Area | double | This column contains the area of the shape. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column specifies the type of the geometric data. |
geom_centroid | string | This column contains the centroid of the geometric shape. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape. |
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 | 1393cb0a-4406-4251-bf93-7a9396a6300a |
Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
Position | 9 |
Revision id | 50be5d28-225f-41c4-a646-fc0d250e41b1 |
State | active |
Table | varmland_zip__clc12_65d_nv__history |