Version History of Base Table Rows in Swedish Dataset Collection
The table under discussion is a historical record sourced from the website of 'Lantmäteriet' in Sweden. This history table provides an in-depth understanding of its base table rows by maintaining a version history. Each row in the table is distinctively identified by a unique combination of the date the row was extracted and the row number from the raw data. This allows for precise tracking of data modifications over time.
The table has two exclusive columns denoting the start and end dates of each row's validity. If an end date is not specified, it signifies that the current version of the row is the most recent.
The data in this table is rich in geographic detail. Originating from a shapefile, a format that simplifies the storage of geographic features and attributes, this information has been transformed into a final geographic format. Geographic features can be represented in a variety of ways, such as points, lines, or polygons (areas).
The potential applications of this data in data analytics are numerous. For instance, a temporal analysis could be conducted to understand changes in geographic features over time. This could help in tracking environmental changes or urban development. Another example could be analyzing the relationship between geographic attributes and external variables, offering insights into patterns and correlations that might not be readily apparent. Ultimately, the comprehensive nature of this table presents vast opportunities for in-depth data analytics and hypothesis testing.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. |
| _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 extracted from the data source. This column, combined with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | An identifier for the object that the row represents. |
| ID | string | An identifier for the row. |
| CODE_12 | string | A code associated with the row. |
| Area_Ha | double | The area of the geographical object that the row represents, measured in hectares. |
| Remark | string | Any additional remarks or comments related to the row. |
| Shape_Leng | double | The length of the shape of the geographical object that the row represents. |
| Shape_Area | double | The area of the shape of the geographical object that the row represents. |
| geom_geojson | string | The geographical object that the row represents, represented as GeoJSON. |
| geom_geotext | string | The geographical object that the row represents, represented as a text string. |
| geom_type | string | The type of the geographical object that the row represents. |
| geom_centroid | string | The centroid of the geographical object that the row represents. |
| geom_center_x | double | The x-coordinate of the center of the geographical object that the row represents. |
| geom_center_y | double | The y-coordinate of the center of the geographical object that the row represents. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 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 | ad2531de-6bf0-4050-a2ad-79ed8b963d34 |
| Package id | c81a4f51-7faf-4d3d-8134-cd94ab4567c2 |
| Position | 7 |
| Revision id | adda77a4-305d-4b6c-a05c-3557a0f7ebfc |
| State | active |
| Table | blekinge_zip__clc12_62f_so__history |