Historical Versions of Land Classification Data in Västra Götaland Region

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

Click here for a data sample

The history table under consideration is a part of a dataset collection and provides an extensive track of version history of its base table rows. It maintains a unique identification for each row using a combination of the date when the row was extracted and the row number. The table also maintains the date when a new version of the row was extracted, assisting in identifying the most recent version of a row.

The table provides detailed geographic information transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information can include points, lines, or polygons (areas).

The table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The information in this table could be highly useful for data analytics in various ways. For instance, it could be used to track changes in geographical features over time, providing valuable insights for environmental studies, urban planning, or infrastructure development. Additionally, the version history could be used in trend analysis or predictive modeling, by understanding how specific data points have evolved over time. The table's geographic information could also be utilized in spatial analytics, providing critical inputs for decision making in sectors like logistics, real estate, or transportation planning.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was initially extracted from the data source. It forms a unique identifier for each row in combination with '_row_number'.
_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 means that the row is the most recent version.
_row_numberlongThis column contains the number of the row as it was in the raw data extracted from the data source. It forms a unique identifier for each row in combination with '_start_date'.
OBJECTIDlongThis column contains a unique identifier for each object in the table.
IDstringThis column contains a unique ID for each object in the table.
CODE_12stringThis column contains a code associated with each object in the table.
Area_HadoubleThis column contains the area of each object, measured in hectares.
RemarkstringThis column contains any remarks or additional information about each object.
Shape_LengdoubleThis column contains the length of the shape of each object.
Shape_AreadoubleThis column contains the area of the shape of each object.
geom_geojsonstringThis column contains the GeoJSON representation of each object's geometry.
geom_geotextstringThis column contains a textual representation of each object's geometry.
geom_typestringThis column contains the type of geometry for each object.
geom_centroidstringThis column contains the centroid of each object's geometry.
geom_center_xdoubleThis column contains the x-coordinate of the center of each object's geometry.
geom_center_ydoubleThis column contains the y-coordinate of the center of each object's geometry.

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
Id0d473597-8b54-45e5-9d88-ff0d781d80d7
Package id60f2a9ad-e1f7-4dc9-a918-721986a483be
Position3
Revision id47873be9-0d0b-4dae-bd0d-0258218dd103
Stateactive
Tablevastra_gotaland_zip__clc12_63e_nv__history