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 table under discussion is a historical record, sourced from the website of Lantmäteriet (The Land Surveying Department) in Sweden. It keeps track of the version history of its base table rows, which is particularly useful for understanding the temporal changes in the data. Each row in the table can be uniquely identified by a specific combination of the date when the row was extracted from the data source and the number of the row in the raw data. The table also records the date when a new version of the row was extracted. If this date is not available, it indicates that the row is the most current version.

The table also includes geographic information, transformed from the shapefile format. Shapefile is a standard format for storing geometric location and attribute information of geographic features, represented by points, lines, or polygons. The geographic data in this table has been converted into a final geographic format from the original shapefile format.

In terms of data analytics, this table can be used in various ways. For example, the temporal data can be used to track changes over time in the geographic features represented in the table, such as monitoring land use changes, urban development, or environmental changes. The geographic data can also be used in spatial analysis, for instance, to identify patterns or trends in the location and shape of geographic features. Additionally, the version history data can be used to validate and verify previous data analyses. This can ensure the accuracy and reliability of the results.

Field Descriptions

Name Data type Description
_start_datedateThe date when the row was extracted from the data source, forming a unique combination with '_row_number' to identify each row in this version history table.
_end_datedateThe date when a new version of the row was extracted from the data source. A null value indicates that the row is the latest version.
_row_numberlongThe number of the row in the raw data extracted from the data source. It is combined with '_start_date' to uniquely identify each row in this version history table.
OBJECTIDlongThe unique identifier of the object within the table.
IDstringThe unique identification number assigned to each row.
CODE_12stringThe code associated with the data in the row.
Area_HadoubleThe area of the geographical object represented in the row, measured in hectares.
RemarkstringAny additional comments or notes associated with the row.
Shape_LengdoubleThe length of the geographical object represented in the row.
Shape_AreadoubleThe area of the geographical object represented in the row.
geom_geojsonstringThe geometric representation of the object in GeoJSON format.
geom_geotextstringThe geometric representation of the object in text format.
geom_typestringThe type of geometric shape that represents the object.
geom_centroidstringThe center point of the geometric shape that represents the object.
geom_center_xdoubleThe X coordinate of the center point of the geometric shape.
geom_center_ydoubleThe Y coordinate of the center point 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
Idf84365e8-8d06-4e64-b89b-0b24b0409ed7
Package idbdfc37ab-2d87-436a-ba7b-6312fe00922e
Position3
Revision idf6a23e07-1760-43dd-8f76-9fd745037210
Stateactive
Tablevarmland_zip__clc12_65e_so__history