Historical Version Records of Base Table Rows from a Swedish Dataset Collection
This historical data table originates from the 'Lantmäteriet' (The Land Survey) website in Sweden. It is a comprehensive collection of information with a specific focus on maintaining the history of each row from its base table. This is achieved by the inclusion of starting and ending dates for each data extraction, creating a version history of the data over time. A unique identifier for each row is formed by combining the start date and row number. If the end date for a row is null, it signifies that the current version of the row is the most recent. Geographic information is a key feature of the dataset, originally sourced in shapefile format - a common format for storing geographic location and attribute information. This geographic data has been transformed from the shapefile format to a final geographic format for the purposes of this dataset.
The data in this table could be utilized in a variety of ways for data analytics. For instance, it could be used to analyze changes in geographic features over time, allowing for the tracking of spatial patterns and trends. The version history could also be used to validate and verify historical data, ensuring its accuracy and reliability. Additionally, the geographic information could be used in spatial data analysis, such as studying the distribution of features across different geographic areas. The table could also be used to support decision-making in areas such as urban planning, environmental management, and resource allocation.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
_end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version. |
_row_number | long | The number of the row 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 | A unique identifier for the object represented by the row. |
ID | string | An identifier for the data entry. |
CODE_12 | string | A code representing specific information about the data entry. |
Area_Ha | double | The area of the object represented by the row, in hectares. |
Remark | string | Additional comments or remarks about the data entry. |
Shape_Leng | double | The length of the shape representing the object, in the same units as the coordinate system of the dataset. |
Shape_Area | double | The area of the shape representing the object, in the same units as the coordinate system of the dataset. |
geom_geojson | string | The geographical representation of the object in GeoJSON format. |
geom_geotext | string | The geographical representation of the object as text. |
geom_type | string | The type of the geographical object represented (e.g., point, line, polygon). |
geom_centroid | string | The centroid of the geographical object, a point representing its center. |
geom_center_x | double | The x-coordinate of the center of the geographical object. |
geom_center_y | double | The y-coordinate of the center of the geographical 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 | 8f2b15ae-d9d2-43e7-b578-ee65623847f1 |
Package id | 1453d6cd-4a88-47c4-a433-b16478346411 |
Position | 7 |
Revision id | 91ec9eeb-9498-43d3-8db9-e355cd475727 |
State | active |
Table | jonkoping_zip__clc12_63e_no__history |