Historical Versioning of Geographical Data for Västerbotten Region
The table is a part of a dataset collection that holds historical data, specifically version history of its base table rows. It is derived from the 'Lantmäteriet' website in Sweden. This history table uniquely identifies each row through a combination of the date of extraction and the row number from the original data source. It has two specific columns that mark the start and end dates for each row's version history, aiding in tracking changes over time. If the end date for a row is null, it indicates that the version of the row is the most current one. The table also contains geographic data transformed from a shapefile format which can represent geographic features as points, lines, or polygons.
The data in this table could be utilized in various ways in data analytics. For example, the version history can be used to understand how certain geographic features have evolved over time. The start and end dates can help identify temporal patterns or anomalies. Furthermore, the geographic information can be used for spatial analysis or map-based visualizations to uncover geographic patterns or trends.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column represents the date when the row was extracted from the data source. |
| _end_date | date | This column includes 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 forms a unique identifier in combination with the '_start_date' column. |
| OBJECTID | long | This column contains the object identifier. |
| ID | string | This column contains the unique identification number. |
| CODE_12 | string | This column includes the 12-digit code. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column contains any remarks or comments. |
| 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 geometric data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data in text format. |
| geom_type | string | This column represents the type of the geometric data. |
| geom_centroid | string | This column contains the center point of the geometric data. |
| geom_center_x | double | This column represents the X-coordinate of the center of the geometric data. |
| geom_center_y | double | This column represents 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 | 8fa6d4da-2f8f-4570-87c5-e165ea97d089 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 9 |
| Revision id | 9be2f919-585c-44a3-9bca-505fa11af995 |
| State | active |
| Table | vasterbotten_zip__clc12_70g_nv__history |