Historical Version Records of Base Table Rows in the Jämtland Dataset Collection

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

Click here for a data sample

The 'clc12_70d_so__history' is a historical data table that is part of the 'jamtland' dataset collection. This table serves as a version history of its base table rows, storing each version of the data extracted from the source. The table provides a unique identifier for each row, made up of a combination of the start date of extraction and a specific row number. This combination ensures that each version of the data is distinct and easily identifiable. The start and end dates of extraction are also stored, indicating the lifespan of each version of data. If the end date is null, it indicates that the version is the most recent.

The table also contains geographic information, originally stored in a shapefile format, and now transformed into a final geographic format. This geographic information includes points, lines, and polygons, representing different geographic features.

The data for this table is sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden.

This table can be utilized in various ways in data analytics. For instance, it can be used to track changes in geographic features over time, providing valuable insights for environmental studies or urban planning. The historical data can also be used to study trends and patterns, helping to predict future changes. Additionally, the geographic data can be used in spatial analytics, for tasks such as identifying specific geographic features or analyzing their distribution.

Field Descriptions

Name Data type Description
_start_datedateThis column indicates the date when a particular row was extracted from the data source. Together with '_row_number', it helps in uniquely identifying each row in this version history table.
_end_datedateThis column records the date when a newer version of a specific row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_numberlongThis column contains the number of the row in the raw data as it is extracted from the data source. It forms a unique identifier for each row in conjunction with '_start_date'.
OBJECTIDlongThis column contains the unique identifier for each object in the table.
IDstringThis column holds the unique identification number for each row in the table.
CODE_12stringThis column includes a specific code associated with each row.
Area_HadoubleThis column represents the area in hectares for each row.
RemarkstringThis column contains any additional remarks or notes related to each row.
Shape_LengdoubleThis column indicates the length of the shape associated with each row.
Shape_AreadoubleThis column indicates the area of the shape associated with each row.
geom_geojsonstringThis column contains the geographical data for each row in GeoJSON format.
geom_geotextstringThis column contains the geographical data for each row in text format.
geom_typestringThis column indicates the type of geometry associated with each row.
geom_centroidstringThis column contains the centroid of the geometry associated with each row.
geom_center_xdoubleThis column represents the X-coordinate of the geometry center for each row.
geom_center_ydoubleThis column represents the Y-coordinate of the geometry center for each row.

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
Idebd0fb30-1819-45d8-b670-f8ca69d684ba
Package ideeda00c0-27ef-4aa9-827c-5a277b27bc79
Position10
Revision idd49a2a4c-6eba-40f8-987c-4f4eee5cebb8
Stateactive
Tablejamtland_zip__clc12_70d_so__history