Version History of Geographical Data in Vastmanland Dataset
Click here for a data sample
The 'clc12_66f_so__history' table is a history table that forms part of the 'vastmanland' dataset collection. It provides a comprehensive record of the version history of its base table rows, allowing for comprehensive tracking and analysis of changes over time. This table is unique as it possesses two additional columns compared to its base table, which represent the start and end dates of the data extraction process. These dates allow each row to be uniquely identified and tracked. If the end date of a row is null, it indicates that it is the most recent version of the row. A unique aspect of this table is the inclusion of geographic information, which originates in shapefile format. This format, used for storing the geometric location and attribute information of geographic features, has been transformed into the final geographic format in this dataset. This table is sourced from the 'Lantmäteriet' website in Sweden. The data in this table could be utilized in a variety of ways in data analytics. For example, it could be used to track changes in geographic features over time, identify trends or anomalies in the data, and provide a historical context for current data patterns. The unique identification system for each row could also be used to create detailed visualizations and analyses of specific data points within the dataset.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it means that the row is the most recent version of the row. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. Together with the '_start_date' column, this column forms a combination that uniquely identifies each row in this version history table. |
|---|
| OBJECTID | long | This column contains the object ID of the data row. |
|---|
| ID | string | This column contains the unique identifier of the data row. |
|---|
| CODE_12 | string | This column contains a code value associated with the data row. |
|---|
| Area_Ha | double | This column contains the area of the geographical feature represented by the data row, measured in hectares. |
|---|
| Remark | string | This column contains any remarks or additional information relevant to the data row. |
|---|
| Shape_Leng | double | This column contains the length of the shape or boundary of the geographical feature represented by the data row. |
|---|
| Shape_Area | double | This column contains the area of the shape or boundary of the geographical feature represented by the data row. |
|---|
| geom_geojson | string | This column contains the geometry of the geographical feature represented by the data row, in GeoJSON format. |
|---|
| geom_geotext | string | This column contains the geometry of the geographical feature represented by the data row, in a text format. |
|---|
| geom_type | string | This column indicates the type of the geometry of the geographical feature represented by the data row. |
|---|
| geom_centroid | string | This column contains the centroid of the geometry of the geographical feature represented by the data row. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the geographical feature represented by the data row. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the geographical feature represented by the data row. |
|---|
