Version History of Base Table Rows in Swedish Dataset Collection
The table titled 'clc12_62d_so__history' is a historical record from the 'halland' dataset collection. This history table has been designed to keep track of the version history of its base table rows. It has additional columns that record the start and end dates of when each row was extracted from the data source. This unique feature allows each row in this version history table to be distinctly identified, with the combination of the starting date and the row number. If the end date for a row is null, it signifies that the row is the most recent version. The table also includes geographic data, transformed from the shapefile format into the final geographic format.
This table was sourced from the 'Lantmäteriet' website, based in Sweden. The information held within this table can be utilized in various ways in the field of data analytics. For instance, the historical data can be used to track changes and trends over time, contributing to predictive analytics. The geographic data can be used in spatial analysis or to visualize geographic trends and patterns. Furthermore, the version history can aid in maintaining data integrity by providing a clear record of data extraction and changes.
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 combination with the '_row_number' column to identify each row in the 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 as extracted from the data source. It forms a unique combination with the '_start_date' column to identify each row in the version history table. |
| OBJECTID | long | This column contains unique identifiers for each object in the table. |
| ID | string | This column contains unique identifiers for each row in the table. |
| CODE_12 | string | This column contains specific codes associated with each row. |
| Area_Ha | double | This column represents the area of the object, measured in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the row. |
| Shape_Leng | double | This column represents the length of the shape of the object. |
| Shape_Area | double | This column represents 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 text format. |
| geom_type | string | This column indicates the type of geometry 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 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 | b1c306ed-1732-4029-a07c-f6e393e1853a |
| Package id | bbf0f771-09e4-48c5-ad18-8e4657b466e0 |
| Position | 5 |
| Revision id | 9cf5c0fc-0301-4add-9762-e2e660c30dab |
| State | active |
| Table | halland_zip__clc12_62d_so__history |