Version History of Base Table Rows in Jonkoping Dataset Collection

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

Click here for a data sample

The table in focus forms part of a larger dataset collection and serves as a historical log, storing the version history of each data row in its base table. Unique identifiers for each row are established through a combination of the row's number and the date of extraction from the data source. Two additional columns, compared to its base table, hold information on these extraction dates, indicating when a row was initially pulled and when a new version was sourced. A null value in the latter column signifies the most recent version of that row.

The data held in this table is of a geographic nature, originally presented in shapefile format - a common means of storing location and attribute information for geographic features. These features can be represented by points, lines, or polygons, all of which have been transformed into the final geographic format for this dataset.

This table has been sourced from the 'Lantmäteriet' website, based in Sweden. In terms of data analytics, the data held in this table could be utilized in a variety of ways. For example, a temporal analysis could be conducted to identify changes in geographic features over time, or the data could be used to inform spatial models and predictions. Moreover, having a historical log of data allows for more accurate trend analysis and aids in identifying and understanding anomalies or irregularities in the data set.

Field Descriptions

Name Data type Description
_start_datedateThis column indicates the date when the particular row was extracted from the data source. It is a part of a unique identifier for each row in this version history table, together with '_row_number'.
_end_datedateThis column represents the date when a new version of the particular row was extracted from the data source. If the value in this column is null, it implies that the row is the most recent version.
_row_numberlongThis column contains the number of the row as it appears in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
OBJECTIDlongThe column represents a unique identifier for each object in the table.
IDstringThis column is an additional unique identifier for each row in the table.
CODE_12stringThis column contains a specific code associated with the row.
Area_HadoubleThis column represents the area of the geographic feature, measured in hectares.
RemarkstringThis column is for any additional comments or remarks about the row.
Shape_LengdoubleThis column contains the length of the geographic shape associated with the row.
Shape_AreadoubleThis column represents the area of the geographic shape associated with the row.
geom_geojsonstringThis column contains the geographic data in GeoJSON format.
geom_geotextstringThis column contains the geographic data in a custom text format.
geom_typestringThis column indicates the type of the geographic data.
geom_centroidstringThis column contains the centroid of the geographic shape.
geom_center_xdoubleThis column represents the X coordinate of the center of the geographic shape.
geom_center_ydoubleThis column represents the Y coordinate of the center of the geographic shape.

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
Iddc7f578f-c5b6-4286-9976-53b1b915404f
Package id1453d6cd-4a88-47c4-a433-b16478346411
Position5
Revision id2a1af779-2bdc-4529-a4dc-d6f542603f13
Stateactive
Tablejonkoping_zip__clc12_63d_so__history