Geological Survey of Finland - Rock Networks History
Click here for a data sample
This table contains the version history of the 'Geological Survey of Finland' rock network data. It stores the information related to various rock features extracted from the 'rajapinnat_gtk_kalliopera_wfsjuonet__juonet' base table. The table includes columns such as '_start_date', '_end_date', '_row_number', 'gml_id', 'objectid', 'eon', 'eon_c3', 'era', 'era_c5', 'period', 'period_c7', 'supersuite', 'supersuite_c9', 'suite', 'suite_c11', 'lithodeme', 'lithodeme_c13', 'original_rock_name', 'rock_class', 'rock_class_c16', 'rock_name', 'rock_name_c18', 'basis', 'basis_c20', 'dyke_width', 'dyke_width_c22', 'shape_len', 'remarks', 'age', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This table can be utilized to perform data analytics on the geological features and their attributes, such as examining the distribution of rock classes across different time periods, analyzing the rock names and their associated lithodemes, investigating the ages of specific rock types, etc. The data in this table is sourced from the website of the 'Geological Survey of Finland' which originates from the country with the ISO country code 'FI' (Finland).
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 history |
|---|
| gml_id | string | The GML ID of the row |
|---|
| objectid | int | The unique identifier of the row |
|---|
| eon | int | The eon value of the row |
|---|
| eon_c3 | string | The eon_c3 value of the row |
|---|
| era | int | The era value of the row |
|---|
| era_c5 | string | The era_c5 value of the row |
|---|
| period | int | The period value of the row |
|---|
| period_c7 | string | The period_c7 value of the row |
|---|
| supersuite | int | The supersuite value of the row |
|---|
| supersuite_c9 | string | The supersuite_c9 value of the row |
|---|
| suite | int | The suite value of the row |
|---|
| suite_c11 | string | The suite_c11 value of the row |
|---|
| lithodeme | int | The lithodeme value of the row |
|---|
| lithodeme_c13 | string | The lithodeme_c13 value of the row |
|---|
| original_rock_name | string | The original rock name of the row |
|---|
| rock_class | int | The rock class of the row |
|---|
| rock_class_c16 | string | The rock_class_c16 value of the row |
|---|
| rock_name | int | The rock name of the row |
|---|
| rock_name_c18 | string | The rock_name_c18 value of the row |
|---|
| basis | int | The basis of the row |
|---|
| basis_c20 | string | The basis_c20 value of the row |
|---|
| dyke_width | int | The width of the dyke |
|---|
| dyke_width_c22 | string | The dyke_width_c22 value of the row |
|---|
| shape_len | int | The length of the shape |
|---|
| remarks | string | Additional remarks about the row |
|---|
| age | string | The age 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 the geometry |
|---|
| geom_centroid | string | The centroid of the geometry |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry |
|---|
| geom | binary | The geometry of the row |
|---|
