Historical Record of Versioned Base Table Rows in Varmland Collection
The 'clc12_67d_so__history' table is a historical record of its base table, capturing the version history of each row. It is part of the 'varmland' dataset collection. This historical table is unique in that it contains two additional columns in comparison to its base table - these columns indicate the start and end dates for when a row was extracted from the data source. A unique identifier for each row is created through a combination of the row number and the start date. If the end date for a row is null, it signifies that the current row is the most recent version.
The table also houses geographic information derived from a shapefile format, a common format for storing geometric location and attribute information of geographic features. These geographic features can be expressed as points, lines, or polygons (areas).
Sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden, this table offers a rich resource of historical data ready for analysis. For example, data analysts could track changes in geographic features over time, identify patterns or anomalies in the data, and make predictions about future changes. Additionally, by comparing the start and end dates, analysts can determine the lifespan of each version of a row, which could be useful in understanding the rate of change of the data. This knowledge can then be utilized to optimize data extraction schedules and processes.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. It is a critical field that, together with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If this field is null, it signifies that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It is part of the unique identifier for each row in conjunction with '_start_date'. |
| OBJECTID | long | This column holds the unique identifier of the object in the data. |
| ID | string | This column contains the ID of the data entry. |
| CODE_12 | string | This column holds the 12-digit code associated with the data. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the data row. |
| Shape_Leng | double | This column stores the length of the shape. |
| Shape_Area | double | This column represents the area of the shape. |
| geom_geojson | string | This column contains the geographic data in GeoJSON format. |
| geom_geotext | string | This column contains geometric data in a text format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column holds the centroid of the geometric data. |
| geom_center_x | double | This column stores the x-coordinate of the center of the geometric data. |
| geom_center_y | double | This column stores the y-coordinate of the center of the geometric data. |
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 | 0810d908-2b73-4763-aaf6-49c51d985eae |
| Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
| Position | 13 |
| Revision id | 5da6894f-1a27-4c36-a839-4279ceaa1bd3 |
| State | active |
| Table | varmland_zip__clc12_67d_so__history |