Historical Version Records of Base Table Rows in the Jämtland Dataset Collection
The 'clc12_70d_so__history' is a historical data table that is part of the 'jamtland' dataset collection. This table serves as a version history of its base table rows, storing each version of the data extracted from the source. The table provides a unique identifier for each row, made up of a combination of the start date of extraction and a specific row number. This combination ensures that each version of the data is distinct and easily identifiable. The start and end dates of extraction are also stored, indicating the lifespan of each version of data. If the end date is null, it indicates that the version is the most recent.
The table also contains geographic information, originally stored in a shapefile format, and now transformed into a final geographic format. This geographic information includes points, lines, and polygons, representing different geographic features.
The data for this table is sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden.
This table can be utilized in various ways in data analytics. For instance, it can be used to track changes in geographic features over time, providing valuable insights for environmental studies or urban planning. The historical data can also be used to study trends and patterns, helping to predict future changes. Additionally, the geographic data can be used in spatial analytics, for tasks such as identifying specific geographic features or analyzing their distribution.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column indicates the date when a particular row was extracted from the data source. Together with '_row_number', it helps in uniquely identifying each row in this version history table. |
_end_date | date | This column records the date when a newer version of a specific 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 as it is extracted from the data source. It forms a unique identifier for each row in conjunction with '_start_date'. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column holds the unique identification number for each row in the table. |
CODE_12 | string | This column includes a specific code associated with each row. |
Area_Ha | double | This column represents the area in hectares for each row. |
Remark | string | This column contains any additional remarks or notes related to each row. |
Shape_Leng | double | This column indicates the length of the shape associated with each row. |
Shape_Area | double | This column indicates the area of the shape associated with each row. |
geom_geojson | string | This column contains the geographical data for each row in GeoJSON format. |
geom_geotext | string | This column contains the geographical data for each row in text format. |
geom_type | string | This column indicates the type of geometry associated with each row. |
geom_centroid | string | This column contains the centroid of the geometry associated with each row. |
geom_center_x | double | This column represents the X-coordinate of the geometry center for each row. |
geom_center_y | double | This column represents the Y-coordinate of the geometry center for each row. |
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 | ebd0fb30-1819-45d8-b670-f8ca69d684ba |
Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
Position | 10 |
Revision id | d49a2a4c-6eba-40f8-987c-4f4eee5cebb8 |
State | active |
Table | jamtland_zip__clc12_70d_so__history |