Version History of Base Table Rows in Varmland Dataset

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_datedateThis 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_numberlongThis 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.
OBJECTIDlongThis column contains the unique object identifier.
IDstringThis column contains the unique identifier.
CODE_12stringThis column contains a specific code related to the data.
Area_HadoubleThis column contains the area measured in hectares.
RemarkstringThis column contains any remarks or comments related to the row.
Shape_LengdoubleThis column contains the length of the shape.
Shape_AreadoubleThis column contains the area of the shape.
geom_geojsonstringThis column contains the geometric data in GeoJSON format.
geom_geotextstringThis column contains the geometric data in text format.
geom_typestringThis column specifies the type of the geometric data.
geom_centroidstringThis column contains the centroid of the geometric shape.
geom_center_xdoubleThis column contains the x-coordinate of the center of the geometric shape.
geom_center_ydoubleThis 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
Adaptershapefile
Countryse
Databasese_lantmateriet
Extract date2024-08-26
Id1393cb0a-4406-4251-bf93-7a9396a6300a
Package idbdfc37ab-2d87-436a-ba7b-6312fe00922e
Position9
Revision id50be5d28-225f-41c4-a646-fc0d250e41b1
Stateactive
Tablevarmland_zip__clc12_65d_nv__history