Version History of Base Table Rows in the Varmland Dataset Collection
The table under discussion is a historical record, sourced from 'Lantmäteriet' (the National Land Survey) in Sweden. As a history table, it contains a version history of its base table rows, enabling users to track changes over time. Two columns in the table, representing the extraction date and the row number, uniquely identify each row, providing a reliable method for tracking updates.
When a row is updated, it registers the date when a new version of the row was extracted, enabling users to see when changes were made. If an end date is not provided, it signifies that the version is the most recent.
The table also contains geographic information, which was originally in the shapefile format - a format used for storing geometric location and attribute information of geographic features. This data has been transformed into a final geographic format for easier reference and analysis.
In terms of data analytics, this table could serve several purposes. For example, it could be used to analyze changes in land usage over time, track alterations in geographic features, or study temporal trends in data modifications. The geographic information could be utilized in a Geographic Information System (GIS) for visual analysis or to create maps showing changes over time. The versioning information could be instrumental in auditing or forensics, helping to identify when and how data has been altered.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value 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 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 id of the object in the base table. |
| CODE_12 | string | This column contains a 12-digit code associated with the object. |
| Area_Ha | double | This column contains the area of the object in hectares. |
| Remark | string | This column contains any remarks associated with the object. |
| Shape_Leng | double | This column contains the length of the shape of the object. |
| Shape_Area | double | This column contains the area of the shape of the object. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the object in a textual format. |
| geom_type | string | This column contains the type of the geometric representation of the object. |
| geom_centroid | string | This column contains the centroid of the geometric representation of the object. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric representation of the object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric representation of the object. |
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 | 54b4f3d8-1144-4258-8ece-40cac8cfe4d3 |
| Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
| Position | 15 |
| Revision id | 2be7f130-9b4f-4182-9e14-c02aebff8c7d |
| State | active |
| Table | varmland_zip__clc12_66e_sv__history |