Historical Version Archive of Base Table Rows in Jamtland Dataset Collection

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

Click here for a data sample

The table in question is a history table that forms part of the 'Jamtland' dataset. It originates from 'Lantmäteriet' (the Swedish mapping, cadastral and land registration authority) in Sweden. This table provides a valuable resource for tracking changes over time, as it contains the version history of its base table rows. Unique identifiers for each row are established through a combination of start dates and row numbers, allowing for precise tracking and referencing.

The table has additional columns that indicate the start and end dates for when a row was extracted from the data source. If the end date for a row is null, this indicates that it is the most recent version of that row.

Geographic information within this table has been transformed from the shapefile format, a widely-used and straightforward format for storing geometric location and attribute information for geographic features. These features can be represented as points, lines, or polygons.

In terms of data analytics, this table could be used in a variety of ways. For instance, it could provide insights into changes in land use or ownership over time, given the geographic information and version history it contains. It could also support land management and planning decisions by providing an historical context. Furthermore, it could be used to study trends in geographic feature changes, supporting environmental monitoring and conservation efforts.

Field Descriptions

Name Data type Description
_start_datedateThe date when the row was extracted from the data source.
_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 most recent version.
_row_numberlongThe number of the row in the raw data extracted from the data source. Together with '_start_date', this uniquely identifies each row in this version history table.
OBJECTIDlongAn identifier for the object.
IDstringThe identification of the row.
CODE_12stringThe 12th code associated with the row.
Area_HadoubleThe area in hectares.
RemarkstringAny additional notes or comments regarding the row.
Shape_LengdoubleThe length of the shape.
Shape_AreadoubleThe area of the shape.
geom_geojsonstringThe geometric representation of the row in GeoJSON format.
geom_geotextstringThe geometric representation of the row in GeoText format.
geom_typestringThe type of the geometric representation.
geom_centroidstringThe centroid of the geometric representation.
geom_center_xdoubleThe x-coordinate of the center of the geometric representation.
geom_center_ydoubleThe y-coordinate of the center of the geometric representation.

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
Idb2a32206-1b0d-46e5-8efc-e4105f1ae470
Package ideeda00c0-27ef-4aa9-827c-5a277b27bc79
Position22
Revision idb2b82228-757d-4efb-a40b-ebc5b41598b0
Stateactive
Tablejamtland_zip__clc12_71e_so__history