Version History of Base Table Rows in the Uppsala Dataset Collection
The table in question is a part of a dataset collection and serves as a history table, maintaining the version history of its base table rows. Originating from the 'Lantmäteriet' website based in Sweden, it includes various data points structured in a tabular format, consisting of columns and rows.
Key features of the table involve entries, such as a unique row number and start date, which together uniquely identify each row in the version history. It also tracks the timeline of data extraction with a start and end date for each row. If the end date is null, it signifies that the row is the most current version.
The table also contains geographic data transformed from the shapefile format, a standard for storing geometric location and attribute details of geographic features. These could be points, lines, or polygons (areas), offering a versatile range of geographic information.
In terms of data analytics, the table could serve numerous purposes. For instance, the version history can be used to track changes over time, allowing analysts to monitor trends or anomalies. Additionally, the geographic data can be utilized in spatial analytics, like identifying patterns or relationships within the geographic features. Furthermore, the timeline of data extraction can be useful in understanding data collection processes, aiding in improvements and optimization of these processes.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the specific row was extracted from the data source. It is used in combination with the '_row_number' column to uniquely identify each row in this history table. |
_end_date | date | This column contains the date when a new version of the specific row was extracted from the data source. If the value of this column is null, it indicates that 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. It is used in combination with the '_start_date' column to uniquely identify each row in this history table. |
OBJECTID | long | This column contains an identification number for each object in the dataset. It is typically a unique identifier. |
ID | string | This column contains an identification number or code, usually unique, associated with each record in the table. |
CODE_12 | string | This column contains specific codes related to the data in the table. The meaning of these codes is usually defined by the data provider. |
Area_Ha | double | This column contains information about the area of each data item, measured in hectares. |
Remark | string | This column is reserved for any notes or additional information about the data in the row. |
Shape_Leng | double | This column contains the length of the shape associated with each data item. |
Shape_Area | double | This column contains the area of the shape associated with each data item. |
geom_geojson | string | This column contains the geometric data in GeoJSON format, a popular format for encoding geographic data structures. |
geom_geotext | string | This column contains the geometric data in plain text format. |
geom_type | string | This column indicates the type of the geometric data (e.g., point, line, polygon). |
geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of a plane figure or shape. |
geom_center_x | double | This column contains the x-coordinate of the geometric center of a shape. |
geom_center_y | double | This column contains the y-coordinate of the geometric center of a 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 | bf3391bd-e33d-4256-bc4b-6f485827b591 |
Package id | 27592a39-b642-4ce0-8d0a-4b4a2e1d279c |
Position | 8 |
Revision id | 8638a694-2284-4f06-97c3-09ee9fb744ea |
State | active |
Table | uppsala_zip__clc12_66h_nv__history |