Version History of Base Table Rows in Varmland Dataset Collection

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

Click here for a data sample

The table under consideration is a history table that is part of a larger dataset collection. It originates from 'Lantmäteriet' (The National Land Survey), a website based in Sweden. This table contains a detailed record of the version history of its base table rows, making it immensely valuable for tracking changes over time. Each entry in the table is uniquely identified by a combination of the row number and the date the row data was extracted from the original source.

The table includes additional columns, namely the start date and end date, which are not present in the base table. The start date refers to when the data was initially extracted, while the end date signifies when a new version of the row was introduced. A null value in the end date column indicates that the data in the row is the most current version.

One of the significant features of this table is its geographical data, originally in a shapefile format - a popular geospatial vector data format. This geographic data has been transformed into a final format from the initial shapefile format. Geographic features can be represented in various forms such as points, lines, or polygons (areas), providing a detailed spatial understanding of the data.

In terms of data analytics, this table could be used in various ways. For instance, the historical data can be analyzed to track changes and trends over time, which would be particularly useful in fields such as environmental studies or urban planning. The geographical data could be utilized in spatial analysis, helping in tasks such as identifying patterns or anomalies in the data. Moreover, the combination of historical and geographical data could provide valuable insights in predictive modeling, forecasting, and decision-making processes.

Field Descriptions

Name Data type Description
_start_datedateThis column contains the date when the row was extracted from the data source. Together with '_row_number', 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. It forms a unique identifier for each row in conjunction with '_start_date'.
OBJECTIDlongThis column contains an object identifier, which is a unique identifier for the object.
IDstringThis column holds the ID of the object.
CODE_12stringThis column contains a 12-digit code associated with the object.
Area_HadoubleThis column contains the area of the object in hectares.
RemarkstringThis column includes any additional remarks or comments about the object.
Shape_LengdoubleThis column contains the length of the shape of the object.
Shape_AreadoubleThis column holds the area of the shape of the object.
geom_geojsonstringThis column contains the geometric representation of the object in GeoJSON format.
geom_geotextstringThis column contains the geometric representation of the object in geotext format.
geom_typestringThis column indicates the type of the geometric representation of the object.
geom_centroidstringThis column contains the centroid of the geometric representation of the object.
geom_center_xdoubleThis column contains the X-coordinate of the center of the geometric representation of the object.
geom_center_ydoubleThis column contains the Y-coordinate of the center of the geometric representation of the object.

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
Id8db673ff-7eb9-4709-af1f-9b5bc247156c
Package idbdfc37ab-2d87-436a-ba7b-6312fe00922e
Position17
Revision id1c53284b-7b0a-4ebe-bea5-c10eda577b5a
Stateactive
Tablevarmland_zip__clc12_66e_no__history