Version History of Base Table Rows in Vasternorrland Dataset Collection
The 'clc12_69e_so__history' table is a historical record table that is part of the 'vasternorrland' dataset collection. This table is a rich source of geographical data, with information transformed from the shapefile format. The shapefile is a format used for storing geographical location and attribute information of geographical features, which can be represented by points, lines, or polygons (areas). This table features data from the original table, along with the addition of two columns that provide a timeline for each row's entry and update in the data source.
The unique identifiers for each row of data in this table are a combination of the start date of extraction and the row number in its raw form. The start date refers to when the data was first sourced, while the end date marks when a new version of the row was extracted, signifying an update or change in the data. If the end date column appears null, it indicates that the particular row is the latest version.
This table originates from 'Lantmäteriet' (The Land Survey of Sweden) in Sweden, providing a reliable and accurate source for geographical data.
In terms of data analytics, this table can offer valuable insights. For instance, it could be used to track geographical changes over time, given the version history and date stamps. It could also be utilized for conducting geographical trend analysis, identifying patterns in land use, or assessing the evolution of geographical features over time. Additionally, the data can be used in creating interactive geographical visualizations, contributing to fields like urban planning, environmental studies, or policy development.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | 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 | 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 | The number of the row in the raw data that was extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for the object. |
| ID | string | A unique identifier for the entry. |
| CODE_12 | string | A code associated with the entry. |
| Area_Ha | double | The area of the entry, measured in hectares. |
| Remark | string | Any remarks or additional information about the entry. |
| Shape_Leng | double | The length of the shape associated with the entry. |
| Shape_Area | double | The area of the shape associated with the entry. |
| geom_geojson | string | The geometry of the shape in GeoJSON format. |
| geom_geotext | string | The geometry of the shape in plain text format. |
| geom_type | string | The type of the geometry of the shape. |
| geom_centroid | string | The centroid of the geometry of the shape. |
| geom_center_x | double | The X coordinate of the center of the geometry of the shape. |
| geom_center_y | double | The Y coordinate of the center of the geometry of the shape. |
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 | 5430c53c-e8b4-4620-8992-052f59c66f45 |
| Package id | 363c72ba-f2e9-4503-ae45-694b4a3163d3 |
| Position | 5 |
| Revision id | 44e80114-9b16-486b-a280-7560a6aaecb8 |
| State | active |
| Table | vasternorrland_zip__clc12_69e_so__history |