Geological Survey of Finland - Rock Data (Integrated) - Version History
Click here for a data sample
This table is a version history of the base table 'rajapinnat_gtk_kalliopera_wfsintegroidut__integroidut'. It contains historical versions of the rows extracted from the data source. Each row in this table has additional columns '_start_date' and '_end_date', representing the extraction dates of the versions. The data in this table provides valuable information for data analytics and insights. By analyzing the changes in the rows over time, trends, patterns, and historical data can be identified. This can be especially useful for understanding the evolution of lineament features and their characteristics. The table includes various columns such as 'gml_id', 'objectid', 'lineament_id', 'data_source', 'certainty', 'scale', 'operator', 'date_col', 'remarks', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns contain diverse information about the lineament features, including identifiers, data source details, certainty levels, scale, operator information, dates, remarks, shape length, geometries in different formats, and centroid coordinates. The data in this table is sourced from the website of Geologian tutkimuskeskus, which is the Geological Survey of Finland. The organization provides geological information and research services for better understanding and managing the geological resources of Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | An identifier for the row. |
|---|
| gml_id | string | The Global Markup Language (GML) identifier of the row. |
|---|
| objectid | int | The identifier of the row in the base table. |
|---|
| lineament_id | string | The identifier of the lineament. |
|---|
| data_source | string | The source of the data for the row. |
|---|
| certainty | string | The certainty level associated with the data. |
|---|
| scale | string | The scale of the data. |
|---|
| operator | string | The operator responsible for the row's creation. |
|---|
| date_col | timestamp | The date associated with the row. |
|---|
| remarks | string | Additional remarks or comments about the row. |
|---|
| shape_len | int | The length of the shape representation of the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in GeoText format. |
|---|
| geom_type | string | The type of geometry of the row. |
|---|
| geom_centroid | string | The centroid of the row's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the row's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the row's geometry. |
|---|
| geom | binary | The geometry of the row. |
|---|
