To download the data set, please sign up or log in
Geological Survey of Finland (GTK) - Geological Interpretation of Rock Structures at 100k Scale
Tables
-
Geological Survey of Finland - Rock Layers Interpretation (100k Phase)TSV
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',...
-
Version History of Geological Survey of Finland Rock Interpretation 100k Rock PhaseTSV
This table contains the version history of the base table 'kallioperan_rakennetulkinta_100k_rakennevaihe', sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It includes information about various structural elements, fault types, fault movement senses, fault movement types, fold types, structure names, and geometries. The table has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The '_end_date' column contains null for the most recent version of the row. The table provides valuable data for data analytics and geological analysis, allowing users to analyze the evolution of geological structures over time, identify structural patterns, investigate fault movements, study fold types, and perform spatial...
Column Descriptions
Geological Survey of Finland - Rock Layers Interpretation (100k Phase)
| Column | Type | Comment |
|---|---|---|
| _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 |
Version History of Geological Survey of Finland Rock Interpretation 100k Rock Phase
| Column | Type | Comment |
|---|---|---|
| _start_date | date | Indicates the start date of the validity period of the row version. |
| _end_date | date | Indicates the end date of the validity period of the row version. |
| _row_number | long | The row number of the version in the history. |
| gml_id | string | The unique identifier of the version entry in GML format. |
| objectid | int | The unique identifier of the version entry. |
| reactivation | int | Indicates if the row version represents a reactivation of an object. |
| reactivation_c3 | string | Indicates the type of reactivation of the object in version C3. |
| structure_type_19201900 | int | The structure type of the object in the year range 1920-1900. |
| structure_type_19201900_c5 | string | The structure type of the object in version C5 in the year range 1920-1900. |
| main_structure_name_19201900 | string | The name of the main structure of the object in the year range 1920-1900. |
| cgi_fault_type_19201900 | string | The type of CGI (Computer-Generated Imagery) fault of the object in the year range 1920-1900. |
| cgi_fault_movement_sense_19201900 | string | Indicates the movement sense of the CGI fault of the object in the year range 1920-1900. |
| cgi_fault_movement_type_19201900 | string | Indicates the movement type of the CGI fault of the object in the year range 1920-1900. |
| shape_len | int | The length of the shape representation of the object. |
| structure_type_18301800 | int | The structure type of the object in the year range 1830-1800. |
| structure_type_18301800_c12 | string | The structure type of the object in version C12 in the year range 1830-1800. |
| main_structure_name_18301800 | string | The name of the main structure of the object in the year range 1830-1800. |
| cgi_fault_type_18301800 | string | The type of CGI fault of the object in the year range 1830-1800. |
| cgi_fault_movement_sense_18301800 | string | Indicates the movement sense of the CGI fault of the object in the year range 1830-1800. |
| cgi_fault_movement_type_18301800 | string | Indicates the movement type of the CGI fault of the object in the year range 1830-1800. |
| reference | string | A reference value associated with the object. |
| structure_type_18901860 | int | The structure type of the object in the year range 1890-1860. |
| structure_type_18901860_c19 | string | The structure type of the object in version C19 in the year range 1890-1860. |
| cgi_fault_type_18901860 | string | The type of CGI fault of the object in the year range 1890-1860. |
| cgi_fault_movement_sense_18901860 | string | Indicates the movement sense of the CGI fault of the object in the year range 1890-1860. |
| cgi_fault_movement_type_18901860 | string | Indicates the movement type of the CGI fault of the object in the year range 1890-1860. |
| main_structure_name_18901860 | string | The name of the main structure of the object in the year range 1890-1860. |
| structure_type_17901770 | int | The structure type of the object in the year range 1790-1770. |
| structure_type_17901770_c25 | string | The structure type of the object in version C25 in the year range 1790-1770. |
| cgi_fault_type_17901770 | string | The type of CGI fault of the object in the year range 1790-1770. |
| cgi_fault_movement_sense_17901770 | string | Indicates the movement sense of the CGI fault of the object in the year range 1790-1770. |
| cgi_fault_movement_type_17901770 | string | Indicates the movement type of the CGI fault of the object in the year range 1790-1770. |
| main_structure_name_17901770 | string | The name of the main structure of the object in the year range 1790-1770. |
| cgi_fold_type_19201900 | string | The fold type of the object in the year range 1920-1900 using CGI. |
| cgi_fold_type_18901860 | string | The fold type of the object in the year range 1890-1860 using CGI. |
| structure_name_18901860 | string | The name of the structure of the object in the year range 1890-1860. |
| structure_name_17901770 | string | The name of the structure of the object in the year range 1790-1770. |
| cgi_fold_type_18301800 | string | The fold type of the object in the year range 1830-1800 using CGI. |
| structure_type_1700542 | int | The structure type of the object in the category 1700542. |
| structure_type_1700542_c36 | string | The structure type of the object in version C36 in the category 1700542. |
| cgi_fault_type_1700542 | string | The type of CGI fault of the object in the category 1700542. |
| cgi_fault_movement_sense_1700542 | string | Indicates the movement sense of the CGI fault of the object in the category 1700542. |
| cgi_fault_movement_type_1700542 | string | Indicates the movement type of the CGI fault of the object in the category 1700542. |
| geom_geojson | string | The geometry representation of the object in GeoJSON format. |
| geom_geotext | string | The geometry representation of the object in GeoText format. |
| geom_type | string | The type of the object's geometry. |
| geom_centroid | string | The centroid of the object's geometry. |
| geom_center_x | double | The X-coordinate of the center of the object's geometry. |
| geom_center_y | double | The Y-coordinate of the center of the object's geometry. |
| geom | binary | The geometry representation of the object. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |