Version History of Base Table Rows in Norrbotten Dataset Collection
The table in question is a historical record of geospatial data, containing detailed information about certain geographic features. It's a part of a larger dataset that focuses on the region of Norrbotten. This historical table tracks the version history of its base table rows, enabling users to see how the data has evolved over time.
Each row in the table is uniquely identified by a combination of the date it was extracted from the data source and its row number. Moreover, each row has a starting and ending date, indicating the lifespan of that particular version of the data. If the end date is not specified, it signifies that the current version of the row is the most recent one.
The table includes several columns with information ranging from identifiers and codes to area measurements and remarks. There's also rich geographic data provided, which has been transformed from the shapefile format into the final geographic format. This includes the geometric location of geographic features, represented by points, lines, or polygons, and provided in various formats such as GeoJSON, GeoText, and more.
The data in this table could be highly valuable for a variety of data analytics applications. For example, researchers studying changes in land use over time could use the version history to track alterations to different geographic features. Urban planners could use the geographic data to inform infrastructure development plans, taking into account the evolution of the area over time. Environmental scientists could also benefit from this table, using the data to monitor changes in natural habitats, study patterns of deforestation, or assess the impact of climate change in the region.
The table is sourced from Lantmäteriet (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date when the row was initially extracted from the data source. It is part of a unique identifier for each row in the version history table, alongside the '_row_number' column. |
| _end_date | date | This column records the date when a new version of the row was extracted from the data source. If the value for this column is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appeared in the raw data extracted from the data source. Together with the '_start_date' column, it forms a unique identifier for each row in the version history table. |
| OBJECTID | long | This column stores unique identifiers for each object in the table. |
| ID | string | This column contains a unique ID for each entry, generated according to a specific naming convention. |
| CODE_12 | string | This column contains codes associated with different types of land cover, as per the standard classification scheme. |
| Area_Ha | double | This column indicates the area in hectares of the corresponding land cover type. |
| Remark | string | This column is reserved for any additional comments or remarks regarding the row entry. In some cases, this may be left blank. |
| Shape_Leng | double | This column is intended to store the length of the shape representing the land cover type. However, it seems that for some entries, this information may not be available. |
| Shape_Area | double | This column provides the area of the shape that represents the land cover type. The area is calculated in square meters. |
| geom_geojson | string | This column stores the geometry of the land cover type in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geospatial coordinates of the land cover type in a text format. |
| geom_type | string | This column indicates the type of geometry used for representing the land cover type. |
| geom_centroid | string | This column holds the coordinates of the centroid (geometric center) of the land cover type. |
| geom_center_x | double | This column records the x-coordinate of the centroid of the land cover type. |
| geom_center_y | double | This column records the y-coordinate of the centroid of the land cover type. |
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 | 9c491f93-a3c6-40c7-bee3-4e903c66a05a |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 1 |
| Revision id | 521722cb-1bf2-4eaf-a0b9-5ba444d460b7 |
| State | active |
| Table | norrbotten_zip__clc12_72g_nv__history |