Version History Table of Land and Geographic Objects from Swedish National Land Survey
The 'clc12_63e_so__history' is a historical data table that is part of the 'jonkoping' dataset collection. As a history table, it contains the version history of its base table rows, which are uniquely identified by a combination of a start date and a row number. This table has two additional columns compared to its base table, namely a start date, which indicates when the row was extracted from the data source, and an end date, which signifies when a new version of the row was extracted. If the end date is null, it indicates that the row is the current version. The table also contains geographic information transformed from the shapefile format, which can represent geographic features as points, lines, or polygons (areas). The data for this table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden.
The data in this table can be used in a variety of data analytics applications. For example, it could be used to track the historical changes in geographic features over time, which could be useful in urban planning or environmental studies. Additionally, by analyzing the version history, one could identify patterns or trends in the data changes, which could be beneficial in predictive analytics or decision-making processes. Furthermore, the geographic information could be utilized in spatial data analysis or geographic information system (GIS) applications, aiding in tasks such as location planning, route optimization, or environmental impact analysis.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column holds the date when the row was extracted from the data source. It is part of a combination with the '_row_number' column that uniquely identifies each row in this version history table. |
_end_date | date | This column holds 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 as it appears in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column. |
OBJECTID | long | This column contains a unique identification number for each object in the table. |
ID | string | This column holds a unique identifier for each row. |
CODE_12 | string | This column holds a specific code related to the row's data. |
Area_Ha | double | This column records the area of the object in hectares. |
Remark | string | This column contains any additional comments or remarks related to the row's data. |
Shape_Leng | double | This column holds the length of the geographical shape associated with the row. |
Shape_Area | double | This column contains the area of the geographical shape associated with the row. |
geom_geojson | string | This column holds the geographical data in GeoJSON format. |
geom_geotext | string | This column contains the geographical data in plain text format. |
geom_type | string | This column specifies the type of geographical shape associated with the row. |
geom_centroid | string | This column contains the centroid or geometric center of the geographical shape associated with the row. |
geom_center_x | double | This column holds the X-coordinate for the center of the geographical shape associated with the row. |
geom_center_y | double | This column holds the Y-coordinate for the center of the geographical shape associated with the row. |
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 | 4619cde4-bb5b-44f8-9b39-1d6c09fa3c0e |
Package id | 1453d6cd-4a88-47c4-a433-b16478346411 |
Position | 11 |
Revision id | 5a3dcce3-3105-4611-9073-23a3be290ee3 |
State | active |
Table | jonkoping_zip__clc12_63e_so__history |