Version History of Base Table Rows From the Vastra Gotaland Dataset Collection
The 'clc12_63d_nv__history' table belongs to the 'vastra_gotaland' dataset collection. As a history table, it keeps a record of the version history of its base table rows. It has two additional columns to its base table, which mark the start and end dates of each version of a row. If the end date is null, it represents the most recent version of the row. Each row also has a unique identifier formed by a combination of the start date and the row number. The data also includes geographic information, originally in the shapefile format, which stores the geometric location and attribute information of geographic features, and has been transformed into the final geographic format. The table is sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden.
The data in this table could be utilized in several ways in data analytics. For instance, the history of changes could be analyzed to identify trends and patterns over time. The start and end dates could be used to study the lifespan of each version of a row. The geographic information could be used to visualize the data on a map or to perform spatial analysis. The row number could be used to track the original order of the data from the source. This detailed view of the data's history and geography could be invaluable in fields such as urban planning, environmental studies, and real estate development.
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 part of the unique identifier for each row in this version history table, when combined with '_row_number'. |
| _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 in the raw data extracted from the data source. It forms part of the unique identifier for each row in this version history table, when combined with '_start_date'. |
| OBJECTID | long | This column contains the object ID associated with each row. |
| ID | string | This column contains the ID value associated with each row. |
| CODE_12 | string | This column contains the 12-digit code associated with each row. |
| Area_Ha | double | This column contains the area size in hectares associated with each row. |
| Remark | string | This column contains any remarks or comments associated with each row. |
| Shape_Leng | double | This column contains the length of the shape associated with each row. |
| Shape_Area | double | This column contains the area of the shape associated with each row. |
| geom_geojson | string | This column contains the geometry of the row in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the row in text format. |
| geom_type | string | This column contains the type of geometry associated with each row. |
| geom_centroid | string | This column contains the centroid of the geometry associated with each row. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometry associated with each row. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometry associated with each row. |
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 | 899d49ff-e1cb-46ff-9026-6a8c98c1b9bc |
| Package id | 60f2a9ad-e1f7-4dc9-a918-721986a483be |
| Position | 5 |
| Revision id | dc311be4-4bb4-4ffc-9845-750cf6db4a77 |
| State | active |
| Table | vastra_gotaland_zip__clc12_63d_nv__history |