History Table of Versioned Base Table Rows with Geometric Data
This historical dataset is part of a larger collection sourced from the website of Lantmäteriet (The Swedish Land Survey) in Sweden. The table records the version history of a base table, including unique identifiers for each row version based on a combination of the extraction date and the row number in the raw data. This allows for tracking of changes over time. In addition to the standard data, two extra columns record the start and end dates of each row version. If the end date is null, that indicates the row is the most recent version. The data also includes geographic information, transformed from the original shapefile format into the final geographic format.
The utility of this table is quite broad in the field of data analytics. For instance, one could use this table to perform a time-series analysis, tracking changes to specific geographic locations over time. It could also be leveraged to study the frequency and nature of updates to the base data or to analyze patterns in the spatial data provided. Moreover, with the use of the geographic information, this dataset could be used for geospatial analytics, such as studying the distribution of a specific attribute across different geographical locations over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row of data was extracted from the data source. |
| _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, the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data as extracted from the data source. Together with '_start_date', it uniquely identifies each row in this history table. |
| OBJECTID | long | This column contains the unique object identifier. |
| ID | string | This column contains the unique ID of the data. |
| CODE_12 | string | This column contains the 12-digit code associated with the data. |
| Area_Ha | double | This column contains the area in hectares. |
| Remark | string | This column contains any remarks or additional comments related to the data. |
| Shape_Leng | double | This column contains the length of the shape. |
| Shape_Area | double | This column contains 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 specifies the type of geometry, such as point, line, polygon, etc. |
| geom_centroid | string | This column contains the centroid of the geometric shape. |
| geom_center_x | double | This column contains the X-coordinate of the geometric shape's center. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric shape's center. |
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 | 7f411f47-587c-4c41-9da5-06890dbd2444 |
| Package id | 1453d6cd-4a88-47c4-a433-b16478346411 |
| Position | 3 |
| Revision id | 51544f71-3fdb-43fe-901b-8c9c863163f2 |
| State | active |
| Table | jonkoping_zip__clc12_63e_sv__history |