Version History of Base Table Rows in Gavleborg Dataset
The 'clc12_67g_sv__history' table is part of the 'gavleborg' dataset collection. This historical table provides a version history of its base table rows, containing two additional columns for recording the start and end dates of each row's extraction from the data source. This provides a unique identifier for each row, based on the combination of extraction date and row number.
The table provides an array of data, including geographical information converted from the shapefile format, which could include points, lines, or polygons. This data, when combined with other columns in the table, offers a comprehensive view of each entry's historical data. Notably, if a row's end date is null, it signifies that the row is the most recent version.
The data for this table comes from the 'Lantmäteriet' website, which is based in Sweden. Given its historical nature and the wealth of geographical data available, this table could be utilized in a variety of data analytics scenarios. For instance, one could track changes in geographical features over time, or analyze the frequency and nature of updates to the base table. Additionally, by comparing the geographical data with other variables in the table, one could identify patterns or trends that may not be readily apparent from a single snapshot in time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in this 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 means 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 is part of a combination with '_start_date' that uniquely identifies each row in this version history table. |
| OBJECTID | long | This column contains an identification number assigned to the object. |
| ID | string | This column contains a unique identification number for each row. |
| CODE_12 | string | This column contains a specific code associated with the data. |
| Area_Ha | double | This column represents the area of the data object in hectares. |
| Remark | string | This column contains any additional comments or remarks related to the data row. |
| Shape_Leng | double | This column contains the length of the shape of the data object. |
| Shape_Area | double | This column contains the area of the shape of the data object. |
| geom_geojson | string | This column contains the geometry of the data object in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the data object in a textual format. |
| geom_type | string | This column indicates the type of geometry of the data object. |
| geom_centroid | string | This column contains the centroid of the geometry of the data object. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the data object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the data 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 | 52d6211d-f917-4399-816b-5b77a35993f3 |
| Package id | 79417cf1-463f-47d0-a7ee-b3e1ee603243 |
| Position | 11 |
| Revision id | 588f8e9f-9768-4438-bb3d-b755a944d70d |
| State | active |
| Table | gavleborg_zip__clc12_67g_sv__history |