Historical Version Archive of Base Table Rows in Jamtland Dataset Collection
The table in question is a history table that forms part of the 'Jamtland' dataset. It originates from 'Lantmäteriet' (the Swedish mapping, cadastral and land registration authority) in Sweden. This table provides a valuable resource for tracking changes over time, as it contains the version history of its base table rows. Unique identifiers for each row are established through a combination of start dates and row numbers, allowing for precise tracking and referencing.
The table has additional columns that indicate the start and end dates for when a row was extracted from the data source. If the end date for a row is null, this indicates that it is the most recent version of that row.
Geographic information within this table has been transformed from the shapefile format, a widely-used and straightforward format for storing geometric location and attribute information for geographic features. These features can be represented as points, lines, or polygons.
In terms of data analytics, this table could be used in a variety of ways. For instance, it could provide insights into changes in land use or ownership over time, given the geographic information and version history it contains. It could also support land management and planning decisions by providing an historical context. Furthermore, it could be used to study trends in geographic feature changes, supporting environmental monitoring and conservation efforts.
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. A null value 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 '_start_date', this uniquely identifies each row in this version history table. |
OBJECTID | long | An identifier for the object. |
ID | string | The identification of the row. |
CODE_12 | string | The 12th code associated with the row. |
Area_Ha | double | The area in hectares. |
Remark | string | Any additional notes or comments regarding the row. |
Shape_Leng | double | The length of the shape. |
Shape_Area | double | The area of the shape. |
geom_geojson | string | The geometric representation of the row in GeoJSON format. |
geom_geotext | string | The geometric representation of the row in GeoText format. |
geom_type | string | The type of the geometric representation. |
geom_centroid | string | The centroid of the geometric representation. |
geom_center_x | double | The x-coordinate of the center of the geometric representation. |
geom_center_y | double | The y-coordinate of the center of the geometric representation. |
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 | b2a32206-1b0d-46e5-8efc-e4105f1ae470 |
Package id | eeda00c0-27ef-4aa9-827c-5a277b27bc79 |
Position | 22 |
Revision id | b2b82228-757d-4efb-a40b-ebc5b41598b0 |
State | active |
Table | jamtland_zip__clc12_71e_so__history |