Version History of Base Table Rows in Vasterbotten Dataset
The '06_73eso__history' table is a comprehensive collection of historical data, serving as a version history of its base table rows. It is part of the larger 'vasterbotten' dataset collection. This history table is unique as it includes two additional columns compared to its base table, which store the dates of data extraction and updates from the data source. This feature allows users to track the evolution of data over time.
The table includes a unique identifier for each row, providing a way to track individual data points across different versions. It also contains geographic information that has been transformed from the shapefile format, which is a widely used format for storing the geometric location and attribute information of geographic features.
This data has been sourced from the website of 'Lantmäteriet' (The Land Survey), based in Sweden.
There are numerous ways this data could be utilized in data analytics. For instance, it could be used to track changes in geographic features over time, such as the growth or shrinkage of areas. The historical data could also be used to identify trends or patterns and make predictions about future changes. Additionally, the geographic data could be used in spatial analysis, for instance, to identify geographical patterns or relationships. Finally, the version history could be used to ensure data integrity, by comparing different versions of the same data point.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for 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 in the raw data extracted from the data source. It is used together with '_start_date' to uniquely identify each row in this version history table. |
| ID | string | This column contains the unique identifier for each entry in the table. |
| CODE_06 | string | This column contains the specific code associated with each entry. |
| Area_Ha | double | This column contains the area in hectares related to each entry. |
| Remark | string | This column contains any remarks or additional information related to the entries. |
| Shape_Leng | double | This column contains the length of the shape associated with each entry. |
| Shape_Area | double | This column contains the area of the shape associated with each entry. |
| geom_geojson | string | This column contains the geographical data of each entry, formatted as GeoJSON. |
| geom_geotext | string | This column contains the geographical data of each entry, formatted as Geotext. |
| geom_type | string | This column indicates the type of geographical data associated with each entry. |
| geom_centroid | string | This column contains the centroid, or geometric center, of the shape associated with each entry. |
| geom_center_x | double | This column contains the x-coordinate of the center of the shape associated with each entry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the shape associated with each entry. |
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 | 8d163093-88b9-4498-916c-a34f980abe33 |
| Package id | 8e387fb0-68fc-4896-9114-220b7a625e8e |
| Position | 35 |
| Revision id | 922e8cbd-b9bf-43fb-b1d7-1a190d812a89 |
| State | active |
| Table | vasterbotten_zip__06_73eso__history |