Historical Versioning of Land Structure Data
The table under discussion is a historical record sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden. It is part of a larger dataset that encompasses related tables, reflecting an organized collection of data. This particular table is unique as it maintains the version history of its base table rows, providing an invaluable chronological perspective of data evolution.
Each row in this table is uniquely identified by a combination of the date when the row data was extracted and its raw data row number. The table also indicates the date when a new version of the row was extracted. This allows for tracking the changes in data over time. If there is no 'end date' specified for a row, it signifies that the version of the row is the most recent one.
Additionally, this table incorporates geographic information. Originally, this information was in the shapefile format, a common method for storing geometric location and attribute information of geographic features. However, the geographic data has been transformed into a more final, refined format.
In terms of data analytics, this table presents numerous possibilities. It could be utilized to track the temporal changes in geographic features, which can provide insights into environmental shifts or urban development patterns. The history of changes could also be used to predict future trends based on past data evolution. Furthermore, the geographic data could be employed to perform spatial analysis, allowing for a geographical perspective on the data. For example, it could be used to analyze the impact of certain geographic factors on the data under consideration. In essence, this table provides a historical, temporal, and spatial overview of data, opening up a wide range of analytical possibilities.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in this version 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 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 forms part of a unique identifier for each row when combined with '_start_date'. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains an identification code for each row in the table. |
CODE_12 | string | This column contains a specific code associated with each row in the table. |
Area_Ha | double | This column contains the area measurement of the object, measured in hectares. |
Remark | string | This column contains any additional comments or remarks related to the row. |
Shape_Leng | double | This column contains the length of the shape associated with each row. |
Shape_Area | double | This column contains the area of the shape associated with each row. |
geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the object in text format. |
geom_type | string | This column indicates the type of geometric object associated with each row. |
geom_centroid | string | This column contains the centroid of the geometric object associated with each row. |
geom_center_x | double | This column contains the X coordinate of the center of the geometric object. |
geom_center_y | double | This column contains the Y coordinate of the center of the geometric object. |
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 | 0cb1a968-4460-4d4f-b8ec-79c7e46e2d9c |
Package id | de8a2b72-39b6-45ce-aea7-5d1acc49ae35 |
Position | 7 |
Revision id | e05faa39-5846-47d5-bb71-559b533d4271 |
State | active |
Table | ostergotland_zip__clc12_64e_so__history |