Historical Version Records of Base Table Rows Collection
Click here for a data sample
The 'clc12_62f_sv__history' table is a historical record of associated base table rows, sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. This history table is a part of the 'kalmar' dataset collection and it carries additional temporal information in comparison with its base table, including the dates of extraction and subsequent updates for each row of data. A unique identifier for each row is formed by combining the extraction date and row number. If a row is the most recent version, it is denoted by a null value in the 'end date' column. The geographic information in this table, originally in shapefile format, has been transformed into a final geographic format. This allows for the representation of geographic features as points, lines, or polygons (areas). This table can be invaluable in data analytics. For instance, it could be used to track changes in geographical features over time, which is useful in environmental studies. Additionally, by using the unique identifiers, data analysts could trace the evolution of specific data points, aiding in investigations or audits. Furthermore, the geographic information could be used in spatial analysis, contributing to fields such as urban planning and transportation logistics.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was first extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
|---|
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If the value of this column is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It forms a unique identifier for each row in combination with '_start_date'. |
|---|
| OBJECTID | long | This column holds the object ID of the row. |
|---|
| ID | string | This column contains the ID of the row. |
|---|
| CODE_12 | string | This column contains the 12-digit code associated with the row. |
|---|
| Area_Ha | double | This column represents the area in hectares. |
|---|
| Remark | string | This column holds any remarks or comments related to the row. |
|---|
| Shape_Leng | double | This column contains the length of the shape associated with the row. |
|---|
| Shape_Area | double | This column represents the area of the shape associated with the row. |
|---|
| geom_geojson | string | This column holds the geometric data of the shape associated with the row in GeoJSON format. |
|---|
| geom_geotext | string | This column contains the geometric data of the shape associated with the row in text format. |
|---|
| geom_type | string | This column describes the type of the geometric shape associated with the row. |
|---|
| geom_centroid | string | This column holds the centroid of the geometric shape associated with the row. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric shape associated with the row. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric shape associated with the row. |
|---|
