Version History of Base Table Rows in Jamtland Dataset Collection
The table in consideration is a historical record, part of the 'Jamtland' dataset collection. It stores the version history of its base table rows. The primary identifiers of each row in this version history table are a unique combination of the row's extraction date and its raw row number. The table also highlights the lifespan of each version of a row, detailing the dates of its extraction and subsequent replacement. If a row is currently the most recent version, it is denoted by a null value in the 'end date' column. The table also contains geographical information, initially sourced in the shapefile format, showcasing the geometric location and attribute information of geographic features. These features can represent points, lines, or polygons (areas).
The table is sourced from the 'Lantmäteriet' website, located in Sweden.
Utilizing this table, analysts could track changes in geographical features over time by leveraging the version history and geographical data. For example, they could investigate patterns in land use changes, or analyze trends in geographic feature transformations. This data could also provide valuable input for predictive models forecasting future alterations in the geographic landscape.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If this value is null, it indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data, extracted from the data source. Together with the '_start_date', this column uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | A unique identifier for each row in the table. |
| CODE_12 | string | A code associated with each row in the table. |
| Area_Ha | double | The area of the geographical object represented by the row, measured in hectares. |
| Remark | string | Additional comments or notes associated with each row in the table. |
| Shape_Leng | double | The length of the geographical object represented by the row. |
| Shape_Area | double | The area of the geographical object represented by the row. |
| geom_geojson | string | The geographical data associated with the row, expressed in GeoJSON format. |
| geom_geotext | string | The geographical data associated with the row, expressed in text format. |
| geom_type | string | The type of the geographical object represented by the row. |
| geom_centroid | string | The centroid of the geographical object represented by the row. |
| geom_center_x | double | The x-coordinate of the center of the geographical object represented by the row. |
| geom_center_y | double | The y-coordinate of the center of the geographical object represented by 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 | 3d68413e-73da-4bb9-ab84-5e060615d208 |
| Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
| Position | 3 |
| Revision id | 7b2abb76-b594-430a-a4ed-ba3c9f0659a6 |
| State | active |
| Table | jamtland_zip__clc12_68e_nv__history |