Geological Survey of Finland - Rock Surface WFS Networks
Tables
-
Geological Survey of Finland - Rock Networks HistoryTSV
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...
-
Geological Surveys Rock Formation DataTSV
This table contains data from the 'Geological Survey of Finland' website. It includes information about rock formations and geological periods in Finland. The data is sourced from the WFS network of the GTK (Geological Survey of Finland). The table provides details such as the extract date, row number, unique identifiers, rock types, rock names, geological ages, and various measurements and characteristics of the rocks. The table's data can be utilized in data analytics to analyze the distribution and characteristics of different rock formations in Finland, study the geological history and evolution of the region, identify patterns and relationships between rock types and geological periods, and perform spatial analysis using the provided geometry information.
Column Descriptions
Geological Surveys Rock Formation Data
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | |
| _row_number | long | |
| gml_id | string | |
| objectid | int | |
| eon | int | |
| eon_c3 | string | |
| era | int | |
| era_c5 | string | |
| period | int | |
| period_c7 | string | |
| supersuite | int | |
| supersuite_c9 | string | |
| suite | int | |
| suite_c11 | string | |
| lithodeme | int | |
| lithodeme_c13 | string | |
| original_rock_name | string | |
| rock_class | int | |
| rock_class_c16 | string | |
| rock_name | int | |
| rock_name_c18 | string | |
| basis | int | |
| basis_c20 | string | |
| dyke_width | int | |
| dyke_width_c22 | string | |
| shape_len | int | |
| remarks | string | |
| age | string | |
| geom_geojson | string | |
| geom_geotext | string | |
| geom_type | string | |
| geom_centroid | string | |
| geom_center_x | double | |
| geom_center_y | double | |
| geom | binary |
Geological Survey of Finland - Rock Networks History
| Column | Type | Comment |
|---|---|---|
| _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 |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |