Version History of Geospatial Data Elements in Södermanland Dataset Collection
The 'clc12_65f_no__history' table is a comprehensive history table that forms part of the 'sodermanland' dataset collection. As a history table, it holds the version history for each of its base table rows, allowing for the tracking of changes over time. This table boasts unique identifiers for each row, which are formed by a combination of the row's start date and its number in the raw data.
This table contains key date columns that provide valuable insights into the data's timeline. For instance, it has a start date column indicating when each row was extracted from the data source, and an end date column marking when a new version of the row was extracted. If the end date column shows a null value, it signifies that the row is the most current version.
Geographical information is another crucial feature of this table, which was initially in the shapefile format and was later transformed into the final geographic format. The shapefile format is a simple, non-topological format for storing the geometric location and attribute information of geographic features, which can be represented as points, lines, or polygons.
This table has been sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The data from this table can be instrumental in various data analytics applications. For instance, it could be used to track changes in geographic features over time, identify trends or anomalies in the data, or even to predict future changes based on historical trends. Furthermore, the table could also serve as a valuable resource for research in fields such as environmental studies, urban planning, and geography.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column indicates the date when the row was extracted from the data source. It is part of a combination that uniquely identifies each row in this version history table. |
_end_date | date | This column indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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. Together with '_start_date', it forms a combination that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains the unique identifier of the object in the table. |
ID | string | This column contains an identification value for the object. |
CODE_12 | string | This column contains a specific code associated with the object. |
Area_Ha | double | This column represents the area of the object in hectares. |
Remark | string | This column may contain additional comments or remarks about the object. |
Shape_Leng | double | This column indicates the length of the shape of the object. |
Shape_Area | double | This column represents the area of the shape of the object. |
geom_geojson | string | This column contains the geographical data of the object in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the object in plain text format. |
geom_type | string | This column indicates the type of the geographical data of the object. |
geom_centroid | string | This column contains the centroid of the geographical data of the object. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical data of the object. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical data of the 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 | 8a07d62c-045c-4818-a7e9-75ed6896e882 |
Package id | e88c5cab-003c-4619-92cb-135e8e103dc2 |
Position | 3 |
Revision id | d3ee063a-ba20-4d83-b4ca-916834aadeb7 |
State | active |
Table | sodermanland_zip__clc12_65f_no__history |