Version History of Rock Composition Starting Data - Finland Geological Survey
Click here for a data sample
This table contains the version history of the rows from the base table 'kallioperan_lahtoaineisto'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the row versions. The data in this table is sourced from the website of Geologian tutkimuskeskus, which is the Geological Survey of Finland. The table provides valuable information for data analytics, such as tracking modifications and updates made to the base table rows over time. By analyzing the '_start_date' and '_end_date' columns, it is possible to identify the timeline of changes and observe patterns in the modifications made to the data. This can be particularly useful in studying the evolution of geological data and understanding the historical context of the base table rows. Additionally, the table includes various other columns containing information such as data origin, map sheets, authorship, publishing year, and additional geographical attributes. These columns can further assist in performing data analytics tasks, ranging from geospatial analysis to studying the characteristics and properties of the geological data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The row number of the version. |
|---|
| gml_id | string | The GML ID of the row version. |
|---|
| objectid | int | The unique identifier for the row version. |
|---|
| data_origin | int | The data origin for the row version. |
|---|
| data_origin_c3 | string | The C3 data origin for the row version. |
|---|
| map_sheet | int | The map sheet for the row version. |
|---|
| map_scale | int | The map scale for the row version. |
|---|
| map_scale_c6 | string | The C6 map scale for the row version. |
|---|
| author | string | The author of the row version. |
|---|
| publishing_year | int | The publishing year of the row version. |
|---|
| organisation | string | The organization of the row version. |
|---|
| modified | int | The modification date of the row version. |
|---|
| modified_c11 | boolean | The C11 modification date of the row version. |
|---|
| shape_area | int | The area of the row version shape. |
|---|
| shape_len | int | The length of the row version shape. |
|---|
| modifier | string | The modifier of the row version. |
|---|
| remarks | string | The remarks for the row version. |
|---|
| low_alt_flight_year | int | The low altitude flight year of the row version. |
|---|
| hyperlink | string | The hyperlink of the row version. |
|---|
| geom_geojson | string | The geometry in GeoJSON format of the row version. |
|---|
| geom_geotext | string | The geotext of the row version geometry. |
|---|
| geom_type | string | The geometry type of the row version. |
|---|
| geom_centroid | string | The centroid of the row version geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the row version geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the row version geometry. |
|---|
| geom | binary | The geometry of the row version. |
|---|
