History Version of Base Table Rows With Geographical Attributes
This historical table, originating from the dataset collection 'ostergotland', has been sourced from 'Lantmäteriet' (The Land Survey) website in Sweden. This database table provides a detailed version history of its base table rows, displaying data from when it was first extracted from the data source to the most recent extraction.
Each row in the table is unique and can be identified by a combination of the date of extraction and the row number. Therefore, if the same data have been extracted multiple times, each extraction will have its own unique entry in the table, allowing for a comprehensive chronological tracking of changes. If a row does not have an end date, this indicates that it is the most recent version of the data.
Geographic information is also included in the table, having been transformed from the shapefile format. This allows for the representation of geographic features such as points, lines, or polygons, providing a broad spectrum of geographical data.
This table could be invaluable in a number of data analytics applications. For example, it could be used to track land use changes over time, providing crucial data for environmental impact studies. Additionally, the table could be utilized to analyze trends in geographical features, assisting in urban planning and development projects. Furthermore, the historical nature of the data allows for the prediction of future patterns and trends, enabling proactive decision-making in a variety of fields.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column records the date when the data row was extracted from the data source. Along with '_row_number', it helps to uniquely identify each row in this version history table. |
_end_date | date | This column records the date when a new version of the row was extracted from the data source. If the value in this column is null, it indicates that the row is the most recent version. |
_row_number | long | This column contains the row number as it appears in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table. |
OBJECTID | long | This column assigns a unique object identifier to each row in the table. |
ID | string | This column contains the unique identification number for each data entry. |
CODE_12 | string | This column holds a unique code that corresponds to specific data entries. |
Area_Ha | double | This column records the area of the geographical feature in hectares. |
Remark | string | This column contains any additional comments or notes regarding the data entry. |
Shape_Leng | double | This column records the length of the shape of the geographical feature. |
Shape_Area | double | This column records the area of the shape of the geographical feature. |
geom_geojson | string | This column holds the geographical feature in GeoJSON format, a widely used open standard format designed for representing simple geographical features. |
geom_geotext | string | This column holds the geographical feature in a textual format. |
geom_type | string | This column states the type of the geographical feature. |
geom_centroid | string | This column contains the centroid, or the geometric center, of the geographical feature. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature. |
No sample for this dataset
Additional Information
Last updated | August 27, 2024 |
---|---|
Created | August 27, 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 | 92e5b36b-703b-4bb7-94a7-74907c1ab449 |
Package id | de8a2b72-39b6-45ce-aea7-5d1acc49ae35 |
Position | 11 |
Revision id | 267f7841-91d5-4ff4-ae5f-24eb6ce8401e |
State | active |
Table | ostergotland_zip__clc12_64f_nv__history |