Version History of Base Table Rows in Uppsala Dataset Collection
This table is a historical record of a dataset sourced from Lantmäteriet, the National Land Survey of Sweden. It provides a comprehensive version history of its base table rows, offering a unique combination of start date and row number to identify each row in this history table. The start date indicates when the row was extracted from the data source, while the end date shows when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version.
The table contains various geographic details, originally in shapefile format—a common standard for storing geometric location and attribute information of geographic features—which have been transformed into a final format. The geographic features could be represented by points, lines, or polygons (areas).
This table could be utilized in several ways in data analytics. For example, it could be used to track changes in geographical features over time, given its historical nature. This can offer valuable insights for environmental studies or urban planning. Additionally, the unique identifiers for each row enable easy tracking and comparison of data versions, which can be useful in maintaining data integrity and ensuring accurate analysis. The geographic information could be used in mapping or spatial analysis, offering a basis for geographical distribution studies or location-based market analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in this version history table. |
OBJECTID | long | This column contains the object identifier. |
ID | string | This column contains the identifier of the object. |
CODE_12 | string | This column contains the 12-digit code of the object. |
Area_Ha | double | This column contains the area of the object in hectares. |
Remark | string | This column contains any additional remarks or notes about the object. |
Shape_Leng | double | This column contains the length of the shape of the object. |
Shape_Area | double | This column contains the area of the shape of the object. |
geom_geojson | string | This column contains the geometry of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the object in geotext format. |
geom_type | string | This column contains the type of the geometry of the object. |
geom_centroid | string | This column contains the centroid of the geometry of the object. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometry of the object. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometry of the object. |
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 | 953ac9ae-d750-44f3-b39d-1a24e44654f6 |
Package id | 27592a39-b642-4ce0-8d0a-4b4a2e1d279c |
Position | 4 |
Revision id | fe2a537a-0eff-4036-bffc-ff7d276578fa |
State | active |
Table | uppsala_zip__clc12_66f_no__history |