Geological Survey of Finland - Rock Permafrost Contact Types
Tables
-
Geological Survey of Finland - Rock Contact Type Probability Estimate HistoryTSV
This table contains the version history of the base table rows sourced from the Geologian tutkimuskeskus website in Finland. It has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The table provides data related to various geological parameters such as tract type, tract name, probabilities and estimates of various elements like number of deposits, gold, copper, nickel, palladium, platinum, shape area, shape length, geometries, and centroids. The data in this table can be utilized in data analytics for conducting statistical analysis, trend analysis, and spatial analysis to gain insights into geological characteristics, probabilistic estimations, and spatial distribution patterns of different elements in the specified tracts. With this...
-
Geological Survey of Finland - Rock Surface Contact Type Probabilities - ConcentrationsTSV
This table contains data from the 'Geological Survey of Finland' website related to the 'tracttype' in the country with the ISO country code 'FI'. It includes information such as the extract date, row number, GML ID, object ID, tract name, probabilities of different elements (such as Au, Cu, Ni, etc.), mean estimates, shape area, shape length, and various geometric properties. The table provides valuable input for data analytics, allowing the analysis of mineral deposits and their characteristics, estimation of probabilities for different elements, and calculation of mean estimates. It enables researchers and analysts to gain insights into the geological features and mineral resources in Finland.
Column Descriptions
Geological Survey of Finland - Rock Surface Contact Type Probabilities - Concentrations
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted |
| _row_number | long | The unique identifier for each row in the table |
| gml_id | string | The GML identifier for each record |
| objectid | int | The object identifier for each record |
| tracttype | string | The type of tract |
| tractname | string | The name of the tract |
| number_dep_10_percent_prob | int | The number of depositions with 10% probability |
| number_dep_50_percent_prob | int | The number of depositions with 50% probability |
| number_dep_90_percent_prob | int | The number of depositions with 90% probability |
| expected_number_of_dep | int | The expected number of depositions |
| au_estim_10_percent_prob | int | The estimated AU with 10% probability |
| au_estim_50_percent_prob | int | The estimated AU with 50% probability |
| au_estim_90_percent_prob | int | The estimated AU with 90% probability |
| au_mean_estimate | int | The mean estimate of AU |
| cu_estim_10_percent_prob | int | The estimated CU with 10% probability |
| cu_estim_50_percent_prob | int | The estimated CU with 50% probability |
| cu_estim_90_percent_prob | int | The estimated CU with 90% probability |
| cu_mean_estimate | int | The mean estimate of CU |
| ni_estim_10_percent_prob | int | The estimated NI with 10% probability |
| ni_estim_50_percent_prob | int | The estimated NI with 50% probability |
| ni_estim_90_percent_prob | int | The estimated NI with 90% probability |
| ni_mean_estimate | int | The mean estimate of NI |
| pd_estim_10_percent_prob | int | The estimated PD with 10% probability |
| pd_estim_50_percent_prob | int | The estimated PD with 50% probability |
| pd_estim_90_percent_prob | int | The estimated PD with 90% probability |
| pd_mean_estimate | int | The mean estimate of PD |
| pt_estim_10_percent_prob | int | The estimated PT with 10% probability |
| pt_estim_50_percent_prob | int | The estimated PT with 50% probability |
| pt_estim_90_percent_prob | int | The estimated PT with 90% probability |
| pt_mean_estimate | int | The mean estimate of PT |
| shape_area | int | The area of the shape |
| shape_len | int | The length of the shape |
| geom_geojson | string | The geometry as GeoJSON |
| geom_geotext | string | The geometry as Geotext |
| 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 geometric center |
| geom_center_y | double | The y-coordinate of the geometric center |
| geom | binary | The full geometry of the record |
Geological Survey of Finland - Rock Contact Type Probability Estimate History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date indicating the beginning of the validity period of the row version. |
| _end_date | date | The end date indicating the end of the validity period of the row version. |
| _row_number | long | The unique identifier assigned to each row in the table. |
| gml_id | string | The Global Markup Language (GML) identifier of the row. |
| objectid | int | The unique identifier of the object in the table. |
| tracttype | string | The type of tract. |
| tractname | string | The name of the tract. |
| number_dep_10_percent_prob | int | The number of dependents with a 10 percent probability. |
| number_dep_50_percent_prob | int | The number of dependents with a 50 percent probability. |
| number_dep_90_percent_prob | int | The number of dependents with a 90 percent probability. |
| expected_number_of_dep | int | The expected number of dependents. |
| au_estim_10_percent_prob | int | The estimated value for the attribute 'au' with a 10 percent probability. |
| au_estim_50_percent_prob | int | The estimated value for the attribute 'au' with a 50 percent probability. |
| au_estim_90_percent_prob | int | The estimated value for the attribute 'au' with a 90 percent probability. |
| au_mean_estimate | int | The mean estimated value for the attribute 'au'. |
| cu_estim_10_percent_prob | int | The estimated value for the attribute 'cu' with a 10 percent probability. |
| cu_estim_50_percent_prob | int | The estimated value for the attribute 'cu' with a 50 percent probability. |
| cu_estim_90_percent_prob | int | The estimated value for the attribute 'cu' with a 90 percent probability. |
| cu_mean_estimate | int | The mean estimated value for the attribute 'cu'. |
| ni_estim_10_percent_prob | int | The estimated value for the attribute 'ni' with a 10 percent probability. |
| ni_estim_50_percent_prob | int | The estimated value for the attribute 'ni' with a 50 percent probability. |
| ni_estim_90_percent_prob | int | The estimated value for the attribute 'ni' with a 90 percent probability. |
| ni_mean_estimate | int | The mean estimated value for the attribute 'ni'. |
| pd_estim_10_percent_prob | int | The estimated value for the attribute 'pd' with a 10 percent probability. |
| pd_estim_50_percent_prob | int | The estimated value for the attribute 'pd' with a 50 percent probability. |
| pd_estim_90_percent_prob | int | The estimated value for the attribute 'pd' with a 90 percent probability. |
| pd_mean_estimate | int | The mean estimated value for the attribute 'pd'. |
| pt_estim_10_percent_prob | int | The estimated value for the attribute 'pt' with a 10 percent probability. |
| pt_estim_50_percent_prob | int | The estimated value for the attribute 'pt' with a 50 percent probability. |
| pt_estim_90_percent_prob | int | The estimated value for the attribute 'pt' with a 90 percent probability. |
| pt_mean_estimate | int | The mean estimated value for the attribute 'pt'. |
| shape_area | int | The area of the geometric shape. |
| shape_len | int | The length of the geometric shape. |
| geom_geojson | string | The geometric shape in GeoJSON format. |
| geom_geotext | string | The geometric shape in Geotext format. |
| geom_type | string | The type of geometric shape. |
| geom_centroid | string | The centroid of the geometric shape. |
| geom_center_x | double | The x-coordinate of the center of the geometric shape. |
| geom_center_y | double | The y-coordinate of the center of the geometric shape. |
| geom | binary | The geometric shape. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |