Version History of Base Table Rows in Norrbotten Collection
The 'clc12_75g_no__history' table is a historical record, sourced from 'Lantmäteriet' (the National Land Survey) of Sweden. It is a component of the 'norrbotten' dataset collection. This table is a version history of its base table rows, storing changes over time. Each row in the table is uniquely identified by a combination of a start date and a row number. It also includes the date when a new version of the row was extracted, with a null value indicating the most recent version. The dataset holds geographic information, derived from the geometric location and attribute information of geographical features stored in a shapefile format. This information has been transformed into a final geographic format.
In terms of data analytics, this table could be used in a variety of ways. For example, it could be used to track changes in geographical features over time, providing valuable insights for environmental studies or urban planning. Additionally, the unique identification of each row allows for detailed tracking and comparison of data changes, which could be vital for data integrity checks or for studying patterns or trends in the data. The geographic information could also be utilized in spatial analysis or Geographic Information System (GIS) applications, to study geographical relationships or to visualize the data on a map.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was first 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 as it appears 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 | A unique identifier for each row in the table. |
| ID | string | An identifier for the data element. |
| CODE_12 | string | A code associated with the data element. |
| Area_Ha | double | The area of the geographical feature in hectares. |
| Remark | string | Any additional remarks or notes associated with the data element. |
| Shape_Leng | double | The length of the geographical feature. |
| Shape_Area | double | The area of the geographical feature. |
| geom_geojson | string | The geometry of the geographical feature in GeoJSON format. |
| geom_geotext | string | The geometry of the geographical feature in text format. |
| geom_type | string | The type of the geographical feature (e.g., polygon, point). |
| geom_centroid | string | The centroid of the geographical feature. |
| geom_center_x | double | The x-coordinate of the center of the geographical feature. |
| geom_center_y | double | The y-coordinate of the center of the geographical feature. |
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 | 609754b9-0152-476d-a709-ecd3c06c3061 |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 45 |
| Revision id | 5ed2df14-5f47-424f-9a7b-5ffba15e2819 |
| State | active |
| Table | norrbotten_zip__clc12_75g_no__history |