Historical Version Records of Base Table Rows in Vastmanland Dataset Collection
The 'clc12_66g_sv__history' table is a historical record from the 'vastmanland' dataset collection. As a history table, it contains the version history of base table rows. Each row in the table represents a specific version of the base table row, with unique identification provided by a combination of the row number and the start date of that particular version.
This table has additional date columns compared to the base table, which denotes when each version of the row started and ended. A null value in the 'end date' column signifies that the current row version is the most recent one.
One of the key features of this table is its extensive geographic data, initially sourced in the shapefile format. The geographic data has been transformed from this original format into a final geographic format, allowing for detailed geographic features to be represented, including points, lines, or polygon areas.
The data for this table is sourced from 'Lantmäteriet' (The Land Survey of Sweden) in Sweden.
In terms of data analytics, this table offers a wealth of possibilities. For instance, analyzing changes in the geographic data over time could reveal patterns in land use or physical changes in the landscape. Similarly, the version history could be used to track changes in specific data points, providing a historical context for current data. This could be particularly useful in fields such as environmental science, urban planning, or even historical studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This contains the date when the row was extracted from the data source. It is a part of a unique identifier for each row in this version history table when combined with '_row_number'. |
| _end_date | date | This contains the date when a new version of the row was extracted from the source. If the value is null, it signifies that the row is the most recent version. |
| _row_number | long | This signifies the number of the row in the raw data sourced from Lantmäteriet (The National Land Survey) in Sweden. It forms a unique identifier when combined with '_start_date'. |
| OBJECTID | long | This is a unique identifier for each object in the table. |
| ID | string | This is another unique identifier for each entry in the table. |
| CODE_12 | string | This column contains a specific code associated with each entry. |
| Area_Ha | double | This describes the area in hectares for each entry. |
| Remark | string | This column contains any additional notes or remarks related to the respective entry. |
| Shape_Leng | double | This describes the length of the shape associated with each entry. |
| Shape_Area | double | This gives the area of the shape associated with each entry. |
| geom_geojson | string | This contains the geometric representation of each entry in GeoJSON format. |
| geom_geotext | string | This contains the geometric representation of each entry as text. |
| geom_type | string | This shows the type of the geometric representation for each entry. |
| geom_centroid | string | This contains the centroid of the geometric representation for each entry. |
| geom_center_x | double | This gives the x-coordinate of the center of the geometric representation for each entry. |
| geom_center_y | double | This gives the y-coordinate of the center of the geometric representation for each entry. |
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 | ea62bc6e-4c91-4106-a05f-89cf8e7153ff |
| Package id | 473516b3-5443-48c1-8759-23e1cc49011c |
| Position | 13 |
| Revision id | 459cc6b6-b532-4983-afae-b9020f31008a |
| State | active |
| Table | vastmanland_zip__clc12_66g_sv__history |