Version History of Base Table Rows in Jonkoping Dataset Collection
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_date | date | This 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_date | date | This 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_number | long | This 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. |
OBJECTID | long | The column represents a unique identifier for each object in the table. |
ID | string | This column is an additional unique identifier for each row in the table. |
CODE_12 | string | This column contains a specific code associated with the row. |
Area_Ha | double | This column represents the area of the geographic feature, measured in hectares. |
Remark | string | This column is for any additional comments or remarks about the row. |
Shape_Leng | double | This column contains the length of the geographic shape associated with the row. |
Shape_Area | double | This column represents the area of the geographic shape associated with the row. |
geom_geojson | string | This column contains the geographic data in GeoJSON format. |
geom_geotext | string | This column contains the geographic data in a custom text format. |
geom_type | string | This column indicates the type of the geographic data. |
geom_centroid | string | This column contains the centroid of the geographic shape. |
geom_center_x | double | This column represents the X coordinate of the center of the geographic shape. |
geom_center_y | double | This 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 | |
Adapter | shapefile |
Country | se |
Database | se_lantmateriet |
Extract date | 2024-08-26 |
Id | dc7f578f-c5b6-4286-9976-53b1b915404f |
Package id | 1453d6cd-4a88-47c4-a433-b16478346411 |
Position | 5 |
Revision id | 2a1af779-2bdc-4529-a4dc-d6f542603f13 |
State | active |
Table | jonkoping_zip__clc12_63d_so__history |