1. Home
  2. Datasets
  3. Geological Survey of Finland ...
To download the data set, please sign up or log in

Geological Survey of Finland - Rock Information and Volcanic Data

The dataset collection 'rajapinnat_gtk_kalliopera_wfsortomagmaattinen_fe_ti_v' consists of one or more dataset tables sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). This dataset collection offers geological data related to igneous rocks, including information about their chemical composition, physical properties, and volcanic origins. These tables provide valuable insights into the geology of Finland and can be used for various purposes such as geological research, resource exploration, and geotechnical analysis.

Tables

  • Geological Research Center - Rock Layers with Oro-magmatic Features in FinlandTSV

    This table contains data from the 'Geological Survey of Finland' website. It provides information about different types of rock formations and their characteristics. The table consists of various columns including the extraction date, row number, object ID, tract type, tract name, and various estimates and probabilities related to depth, iron (Fe), titanium (Ti), and velocity (v) of the rock formations. Additionally, there are columns for shape area, shape length, geographical data in GeoJSON and GeoText formats, geometry type, centroid coordinates, and the complete geometry of the rock formations. The data can be utilized for various data analytics tasks such as geological mapping, analyzing rock composition and properties, predicting depth and mineral content, and studying the spatial...

  • Geological Survey of Finland - Rock Types - Volcanic - Volcanic Magmatic - Version HistoryTSV

    This table contains the version history of the rows in the 'Geologian tutkimuskeskus' database table 'rajapinnat_gtk_kalliopera_wfsortomagmaattinen_fe_ti_v__ortomagmaattinen_fetiv'. The table is sourced from the website of 'Geological Survey of Finland' which originates from the country with ISO country code 'FI'. It includes various columns that store information related to geological tracts, such as tract type, tract name, number of deposits at different probability levels, expected number of deposits, estimates of fe, ti, and v at different probability levels, mean estimates of fe, ti, and v, shape area and length, as well as geometry information. The '_start_date' column indicates the date when a specific row was extracted from the data source, while the '_end_date' column indicates...

Column Descriptions

Geological Research Center - Rock Layers with Oro-magmatic Features in Finland

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the record in the table.
gml_id string The GML identifier of the record.
objectid int The unique identifier of the record.
tracttype string The type of tract.
tractname string The name of the tract.
number_dep_10_percent_prob int The number of dependencies with a 10 percent probability.
number_dep_50_percent_prob int The number of dependencies with a 50 percent probability.
number_dep_90_percent_prob int The number of dependencies with a 90 percent probability.
expected_number_of_dep int The expected number of dependencies.
fe_estim_10_percent_prob int The estimated number of dependencies with a 10 percent probability.
fe_estim_50_percent_prob int The estimated number of dependencies with a 50 percent probability.
fe_estim_90_percent_prob int The estimated number of dependencies with a 90 percent probability.
fe_mean_estimate int The mean estimated number of dependencies.
ti_estim_10_percent_prob int The estimated time with a 10 percent probability.
ti_estim_50_percent_prob int The estimated time with a 50 percent probability.
ti_estim_90_percent_prob int The estimated time with a 90 percent probability.
ti_mean_estimate int The mean estimated time.
v_estim_10_percent_prob int The estimated velocity with a 10 percent probability.
v_estim_50_percent_prob int The estimated velocity with a 50 percent probability.
v_estim_90_percent_prob int The estimated velocity with a 90 percent probability.
v_mean_estimate int The mean estimated velocity.
shape_area int The area of the shape.
shape_len int The length of the shape.
geom_geojson string The geometry of the record in GeoJSON format.
geom_geotext string The geometry of the record 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 center of the geometry.
geom_center_y double The y-coordinate of the center of the geometry.
geom binary The geometry of the record.

Geological Survey of Finland - Rock Types - Volcanic - Volcanic Magmatic - Version 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 identifier for the row version.
objectid int The identifier of the row version.
tracttype string The type of tract.
tractname string The name of the tract.
number_dep_10_percent_prob int The number of dependents with 10% probability.
number_dep_50_percent_prob int The number of dependents with 50% probability.
number_dep_90_percent_prob int The number of dependents with 90% probability.
expected_number_of_dep int The expected number of dependents.
fe_estim_10_percent_prob int The estimated FE with 10% probability.
fe_estim_50_percent_prob int The estimated FE with 50% probability.
fe_estim_90_percent_prob int The estimated FE with 90% probability.
fe_mean_estimate int The mean estimate of the FE.
ti_estim_10_percent_prob int The estimated TI with 10% probability.
ti_estim_50_percent_prob int The estimated TI with 50% probability.
ti_estim_90_percent_prob int The estimated TI with 90% probability.
ti_mean_estimate int The mean estimate of the TI.
v_estim_10_percent_prob int The estimated V with 10% probability.
v_estim_50_percent_prob int The estimated V with 50% probability.
v_estim_90_percent_prob int The estimated V with 90% probability.
v_mean_estimate int The mean estimate of the V.
shape_area int The area of the shape.
shape_len int The length of the shape.
geom_geojson string The geometry in GeoJSON format.
geom_geotext string The text representation of the geometry.
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 object.

Additional Info

Last Updated June 6, 2024
Created April 22, 2024