Version History of Norrbotten Dataset Collection: Geospatial Attributes and Related Data
The table in question is a historical dataset that contains a version history of its base table rows. Originating from the 'Lantmäteriet' website in Sweden, it tracks changes over time, capturing the date when each row was extracted from the data source and the date when a new version of the row was extracted. If there's no end date, it indicates that the row is the most recent version. Unique identification of every row in this version history table is achieved through a combination of the row number and the start date of extraction.
The table also includes geographic information transformed from shapefile format, a common methodology for storing geographic features. These features can be represented as points, lines, or polygons, providing rich spatial data.
In terms of data analytics, this table could be used in several ways. For instance, one could track changes in geographic features over time, providing invaluable information for environmental studies. It could also be used to study trends or anomalies in the data, identify patterns, or make predictions based on past changes. Furthermore, the geographic data could be used in spatial analysis, such as determining proximity between features, identifying clusters, or analyzing patterns and relationships within the data.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was first extracted from the data source. This is part of a combination with '_row_number' that 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 indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as extracted from the raw data source. It forms a combination with '_start_date' to uniquely identify each row in this version history table. |
| OBJECTID | long | This is a column containing object IDs. |
| ID | string | This column contains IDs. |
| CODE_12 | string | This column contains 12-digit codes. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column contains remarks or comments related to the row data. |
| Shape_Leng | double | This column represents the length of the shape. |
| Shape_Area | double | This column represents the area of the shape. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometry. |
| geom_geotext | string | This column contains the textual representation of the geometry. |
| geom_type | string | This column defines the type of the geometry. |
| geom_centroid | string | This column contains the centroid of the geometry. |
| geom_center_x | double | This column contains the X coordinate of the geometry's center. |
| geom_center_y | double | This column contains the Y coordinate of the geometry's center. |
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 | 963a51fd-5925-4af5-86d5-4639c794f30a |
| Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
| Position | 17 |
| Revision id | a44c2690-a9bf-4984-a550-a02a18b3e4d9 |
| State | active |
| Table | norrbotten_zip__clc12_74f_nv__history |