Historical Version Control Record of Base Table Rows in Dalarna Dataset Collection

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

Click here for a data sample

The table under description is a historical record, part of a larger dataset collection. It specializes in maintaining the version history of its base table rows, providing a unique identifier for each row via a combination of a start date and a row number. The start date indicates when the row was initially extracted from the data source, while an end date signals when a new version of the row was extracted. If the end date value is null, this indicates that the row is the current, most recent version.

The table also contains geographical information, originally stored in a shapefile format, a format widely used for storing the geometric location and attribute information of geographic features, such as points, lines, or polygons. This geographic information has been transformed into a final format from the original shapefile format for easier data manipulation and analysis.

The table's data is sourced from Lantmäteriet, the Swedish National Land Survey, in Sweden.

Potential applications of this data in analytics could include tracking changes in geographic features over time, aiding in urban planning or environmental studies. For example, if the data is related to land use, analysts could track how certain areas have developed or changed. Alternatively, if the data is related to environmental features, it could be used to monitor changes and trends in these features over time, aiding in environmental conservation efforts.

Field Descriptions

Name Data type Description
_start_datedateThe date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table.
_end_datedateThe date when a new version of the row was extracted from the data source. If its value is null, it means that the row is the most recent version.
_row_numberlongThe number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
OBJECTIDlongA unique identifier for each object in the table.
IDstringA unique identifier for each entry in the table.
CODE_12stringA code associated with each row in the table.
Area_HadoubleThe area (in hectares) associated with each row in the table.
RemarkstringAny additional comments or observations associated with each row.
Shape_LengdoubleThe length of the shape associated with each row.
Shape_AreadoubleThe area of the shape associated with each row.
geom_geojsonstringThe geometric representation of the data in GeoJSON format.
geom_geotextstringThe geometric representation of the data in text format.
geom_typestringThe type of the geometric representation of the data.
geom_centroidstringThe centroid of the geometric representation of the data.
geom_center_xdoubleThe x-coordinate of the center of the geometric representation of the data.
geom_center_ydoubleThe y-coordinate of the center of the geometric representation of the data.

No sample for this dataset

Additional Information

Last updated August 26, 2024
Created August 26, 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
Ideebc9565-00c6-490e-950f-7cbdab01c6db
Package idb5850e4f-b288-47bd-aa8e-1b5ae61e62d6
Position9
Revision id061d419e-5ad5-4060-a724-7f0a1c38dd06
Stateactive
Tabledalarna_zip__clc12_67d_no__history