Geological Survey of Finland - Rock Layers Interpretation (100k Phase)
This table contains data from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) website. It provides information related to rock interpretations in Finland. The data is sourced from the 'rajapinnat_gtk_kalliopera_wfskallioperan_rakennetulkinta_100k_rakennevaihe__kallioperan_rakennetulkinta_100k_rakennevaihe' table, which includes various columns such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'reactivation', 'reactivation_c3', 'structure_type_19201900', 'structure_type_19201900_c5', 'main_structure_name_19201900', 'cgi_fault_type_19201900', 'cgi_fault_movement_sense_19201900', 'cgi_fault_movement_type_19201900', 'shape_len', 'structure_type_18301800', 'structure_type_18301800_c12', 'main_structure_name_18301800', 'cgi_fault_type_18301800', 'cgi_fault_movement_sense_18301800', 'cgi_fault_movement_type_18301800', 'reference', 'structure_type_18901860', 'structure_type_18901860_c19', 'cgi_fault_type_18901860', 'cgi_fault_movement_sense_18901860', 'cgi_fault_movement_type_18901860', 'main_structure_name_18901860', 'structure_type_17901770', 'structure_type_17901770_c25', 'cgi_fault_type_17901770', 'cgi_fault_movement_sense_17901770', 'cgi_fault_movement_type_17901770', 'main_structure_name_17901770', 'cgi_fold_type_19201900', 'cgi_fold_type_18901860', 'structure_name_18901860', 'structure_name_17901770', 'cgi_fold_type_18301800', 'structure_type_1700542', 'structure_type_1700542_c36', 'cgi_fault_type_1700542', 'cgi_fault_movement_sense_1700542', 'cgi_fault_movement_type_1700542', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data could be utilized for various data analytics purposes such as studying the geological formations, fault types, structural movements, and rock interpretations in Finland. It can also be used for spatial analysis and mapping of geological features.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | The date when the data was extracted |
| _row_number | long | The row number of the data |
| gml_id | string | The GML identifier |
| objectid | int | The object identifier |
| reactivation | int | The reactivation value |
| reactivation_c3 | string | The reactivation C3 value |
| structure_type_19201900 | int | The structure type from 1920 to 1900 |
| structure_type_19201900_c5 | string | The structure type from 1920 to 1900 C5 value |
| main_structure_name_19201900 | string | The main structure name from 1920 to 1900 |
| cgi_fault_type_19201900 | string | The CGI fault type from 1920 to 1900 |
| cgi_fault_movement_sense_19201900 | string | The CGI fault movement sense from 1920 to 1900 |
| cgi_fault_movement_type_19201900 | string | The CGI fault movement type from 1920 to 1900 |
| shape_len | int | The length of the shape |
| structure_type_18301800 | int | The structure type from 1830 to 1800 |
| structure_type_18301800_c12 | string | The structure type from 1830 to 1800 C12 value |
| main_structure_name_18301800 | string | The main structure name from 1830 to 1800 |
| cgi_fault_type_18301800 | string | The CGI fault type from 1830 to 1800 |
| cgi_fault_movement_sense_18301800 | string | The CGI fault movement sense from 1830 to 1800 |
| cgi_fault_movement_type_18301800 | string | The CGI fault movement type from 1830 to 1800 |
| reference | string | The reference value |
| structure_type_18901860 | int | The structure type from 1890 to 1860 |
| structure_type_18901860_c19 | string | The structure type from 1890 to 1860 C19 value |
| cgi_fault_type_18901860 | string | The CGI fault type from 1890 to 1860 |
| cgi_fault_movement_sense_18901860 | string | The CGI fault movement sense from 1890 to 1860 |
| cgi_fault_movement_type_18901860 | string | The CGI fault movement type from 1890 to 1860 |
| main_structure_name_18901860 | string | The main structure name from 1890 to 1860 |
| structure_type_17901770 | int | The structure type from 1790 to 1770 |
| structure_type_17901770_c25 | string | The structure type from 1790 to 1770 C25 value |
| cgi_fault_type_17901770 | string | The CGI fault type from 1790 to 1770 |
| cgi_fault_movement_sense_17901770 | string | The CGI fault movement sense from 1790 to 1770 |
| cgi_fault_movement_type_17901770 | string | The CGI fault movement type from 1790 to 1770 |
| main_structure_name_17901770 | string | The main structure name from 1790 to 1770 |
| cgi_fold_type_19201900 | string | The CGI fold type from 1920 to 1900 |
| cgi_fold_type_18901860 | string | The CGI fold type from 1890 to 1860 |
| structure_name_18901860 | string | The structure name from 1890 to 1860 |
| structure_name_17901770 | string | The structure name from 1790 to 1770 |
| cgi_fold_type_18301800 | string | The CGI fold type from 1830 to 1800 |
| structure_type_1700542 | int | The structure type 1700 to 542 |
| structure_type_1700542_c36 | string | The structure type 1700 to 542 C36 value |
| cgi_fault_type_1700542 | string | The CGI fault type 1700 to 542 |
| cgi_fault_movement_sense_1700542 | string | The CGI fault movement sense 1700 to 542 |
| cgi_fault_movement_type_1700542 | string | The CGI fault movement type 1700 to 542 |
| geom_geojson | string | The geometry in GeoJSON format |
| geom_geotext | string | The geometry in GeoText format |
| geom_type | string | The type of geometry |
| geom_centroid | string | The centroid of the geometry |
| geom_center_x | double | The x-coordinate of the geometry center point |
| geom_center_y | double | The y-coordinate of the geometry center point |
| geom | binary | The geometry object |
No sample for this dataset
Additional Information
| Last updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Adapter | delta |
| Country | fi |
| Database | fi_geologian_tutkimuskeskus |
| Id | 197bf27e-6127-4ea8-a5c2-fc9f41a9acb4 |
| Package id | 30c00afb-3562-462f-8c0d-af76466af7bc |
| Revision id | fbae0599-ad75-44df-8d25-d90583356d4c |
| State | active |
| Table | rajapinnat_gtk_kalliopera_wfskallioperan_rakennetulkinta_100k_rakennevaihe__kallioperan_rakennetulkinta_100k_rakennevaihe |