Historical Version Records of Uppsala Dataset Table
This historical dataset table is part of a larger collection sourced from 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. It provides a version history of its base table rows, tracking changes over time. Each row in this table is uniquely distinguished by a combination of the extraction date and the row number from the original raw data.
The table records the date a row was extracted as well as the date when a new version of the same row was extracted. If the ending date is not specified, this indicates that the version of the row is the most recent.
Additionally, the table contains columns that contain geographic information, which has been transformed from the original shapefile format. Shapefile is a format used to store the geometric location and attribute information of geographic features, which can be points, lines, or polygons (areas).
This dataset could be valuable for a variety of data analytics purposes. For example, it could be used for analyzing temporal changes in geographic features, or for monitoring the evolution of a specific attribute over time. Another potential use could be to validate or verify the accuracy of the data by comparing different versions of the same row. This table, with its unique blend of temporal and geographic information, offers a wide range of possibilities for in-depth data analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | Contains the date when the row was extracted from the data source. Together with '_row_number', this forms a unique identifier for each row in this version history table. |
_end_date | date | Contains the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
_row_number | long | Contains the number of the row in the raw data extracted from the data source. Together with '_start_date', this forms a unique identifier for each row in this version history table. |
OBJECTID | long | Unique identifier for each object within this table. |
ID | string | Unique identifier for each row within this table. |
CODE_12 | string | Contains a coded value that represents a certain type of data or information within the row. |
Area_Ha | double | The area of the geographical feature represented by the row, measured in hectares. |
Remark | string | Contains any additional comments or observations associated with the data in the row. |
Shape_Leng | double | The length of the shape represented by the row. This could be the length of a feature's border or perimeter, for example. |
Shape_Area | double | The area of the shape represented by the row. This could be the area of a feature's surface, for example. |
geom_geojson | string | Contains the geometric data of the row in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
geom_geotext | string | Contains the geometric data of the row in text form. |
geom_type | string | Specifies the type of the geometric data represented in the row, such as 'Point', 'LineString', or 'Polygon'. |
geom_centroid | string | The central point of the geometric shape represented by the row. |
geom_center_x | double | The X-coordinate of the center of the geometric shape represented by the row. |
geom_center_y | double | The Y-coordinate of the center of the geometric shape represented by the row. |
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 | 1119dab1-1d1e-4299-a83a-2f326962d149 |
Package id | 27592a39-b642-4ce0-8d0a-4b4a2e1d279c |
Position | 1 |
Revision id | f7f5c339-90dd-4d4d-b6a2-0db81222565e |
State | active |
Table | uppsala_zip__clc12_66f_so__history |