Historical Version Records of Base Table Data in Norrbotten Dataset Collection
The '06_74iso__history' table is a historical dataset that is part of the 'norrbotten' dataset collection. This historical table contains the version history of its base table rows, allowing for the tracking of changes over time. Key identifiers for each row include a unique combination of the extraction date and row number. Furthermore, the table offers the ability to discern if a row is the most recent version, based on whether the end date is null or not.
The table provides geographic information that has been transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. These features can be represented by points, lines, or polygons.
This data is sourced from the website of Lantmäteriet (The Land Survey) in Sweden.
In terms of data analytics, this table could be incredibly useful in a number of ways. For instance, it could be used to track changes in geographic features over time, providing valuable insights for environmental studies or urban planning. The version history could also be used to validate data accuracy and consistency over time. The geographic data can further be utilized for spatial analyses and mapping, potentially contributing to fields such as transport planning, disaster management, and resource allocation.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
| _end_date | date | This column contains 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. It is used in combination with '_start_date' to uniquely identify each row in this version history table. |
| ID | string | This column contains the identifier of the row. |
| CODE_06 | string | This column contains specific codes related to the data. |
| Area_Ha | double | This column contains data related to the area in hectares. |
| Remark | string | This column is used for any additional comments or notes related to the row. |
| Shape_Leng | double | This column contains data related to the length of a particular shape. |
| Shape_Area | double | This column contains data related to the area of a particular shape. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. |
| geom_geotext | string | This column contains geometric data in text format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric data. |
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric data. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric data. |
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 | 30268711-49dc-42af-9abf-07a926019ace |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 37 |
| Revision id | ef61e751-f7e8-49b6-b85e-f686c33b9904 |
| State | active |
| Table | norrbotten_zip__06_74iso__history |