Version History of Geographic Features and Attributes in Värmland Dataset Collection
Click here for a data sample
The 'clc12_65e_no__history' table is a historical dataset part of the 'varmland' collection. As a history table, it provides a record of the evolution of its associated base table over time. This is evidenced by the inclusion of two additional columns that track the start date and end date of each row's data extraction from the data source. The start date marks when a row was initially extracted, and the end date indicates when a new version of the row was extracted. When the end date is null, this signals that the row is the most recent version. Another unique aspect of this table is the '_row_number' column that provides the number of the row from the raw data, forming a unique identifier for each row in conjunction with the start date. This table also includes geographic data, transformed from shapefile format, which represents the geometric location and attribute information of geographic features. This type of data can be represented by points, lines, or polygons. The source of this dataset is the 'Lantmäteriet' website, based in Sweden. In the realm of data analytics, this table could be utilized for tracking and analyzing changes in geographic features over time, studying the frequency and nature of updates to the data source, or integrating with other data to provide a historical context to patterns and trends.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was first extracted from the source data. Together with '_row_number', it uniquely identifies each row in this version history table. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the source data. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | The number of the row as it appears in the raw data extracted from the source. It is part of the combination that uniquely identifies each row in this version history table. |
|---|
| OBJECTID | long | A unique identifier for each object in the table. |
|---|
| ID | string | An identification number for each record in the table. |
|---|
| CODE_12 | string | A code related to the 12th version of the data. The specific meaning of this code depends on the context of the data. |
|---|
| Area_Ha | double | The area of the geographical object described by the row, measured in hectares. |
|---|
| Remark | string | Any additional comments or observations about the data in the row. |
|---|
| Shape_Leng | double | The length of the shape of the geographical object described by the row. The specific unit of this measurement depends on the context of the data. |
|---|
| Shape_Area | double | The area of the shape of the geographical object described by the row. The specific unit of this measurement depends on the context of the data. |
|---|
| geom_geojson | string | The geographical data of the object described by the row, formatted in GeoJSON. |
|---|
| geom_geotext | string | The geographical data of the object described by the row, formatted as text. |
|---|
| geom_type | string | The type of the geographical object described by the row. |
|---|
| geom_centroid | string | The centroid, or geometric center, of the geographical object described by the row. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geographical object described by the row. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geographical object described by the row. |
|---|
