Geological Survey of Finland Rock Base WFS-Reef Type PGE
Tables
-
Geological Survey of Finland - Rock Operations WFS Reef Type PGE - Reef Type PGE HistoryTSV
This table contains the version history of the rows extracted from the 'Geological Survey of Finland' website for the base table 'rajapinnat_gtk_kalliopera_wfsreef_tyypin_pge__reeftyypin_pge'. The table includes additional columns '_start_date' and '_end_date', representing the extraction dates of the respective row versions. The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze the changes and evolution of the 'tracttype', 'tractname', 'number_dep_10_percent_prob', 'number_dep_50_percent_prob', 'number_dep_90_percent_prob', 'expected_number_of_dep', 'au_estim_10_percent_prob', 'au_estim_50_percent_prob', 'au_estim_90_percent_prob', 'au_mean_estimate', 'cu_estim_10_percent_prob', 'cu_estim_50_percent_prob',...
-
Reef Type and Expected Numbers of Deposits in Geological Survey of Finland's Rock Outcrop AreasTSV
This table contains geological data sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It provides information on different types of rock formations and their associated mineral deposits. The table includes various attributes such as the date of extraction, row number, GML ID, and object ID for each record. The tracttype column specifies the type of rock formation, while the tractname column contains the name of the specific tract. The number_dep_X_percent_prob columns provide the number of deposits with a certain probability of occurrence. The expected_number_of_dep column denotes the overall expected number of deposits. For each mineral type (e.g., gold: au, copper: cu, nickel: ni, platinum: pt), there are columns representing different estimation...
Column Descriptions
Reef Type and Expected Numbers of Deposits in Geological Survey of Finland's Rock Outcrop Areas
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | Date of the data extraction |
| _row_number | long | Order number of the row |
| gml_id | string | GML identifier |
| objectid | int | Unique identifier of the object |
| tracttype | string | Type of the tract |
| tractname | string | Name of the tract |
| number_dep_10_percent_prob | int | Number of dependents with 10% probability |
| number_dep_50_percent_prob | int | Number of dependents with 50% probability |
| number_dep_90_percent_prob | int | Number of dependents with 90% probability |
| expected_number_of_dep | int | Expected number of dependents |
| au_estim_10_percent_prob | int | AU estimate with 10% probability |
| au_estim_50_percent_prob | int | AU estimate with 50% probability |
| au_estim_90_percent_prob | int | AU estimate with 90% probability |
| au_mean_estimate | int | AU mean estimate |
| cu_estim_10_percent_prob | int | CU estimate with 10% probability |
| cu_estim_50_percent_prob | int | CU estimate with 50% probability |
| cu_estim_90_percent_prob | int | CU estimate with 90% probability |
| cu_mean_estimate | int | CU mean estimate |
| ni_estim_10_percent_prob | int | NI estimate with 10% probability |
| ni_estim_50_percent_prob | int | NI estimate with 50% probability |
| ni_estim_90_percent_prob | int | NI estimate with 90% probability |
| ni_mean_estimate | int | NI mean estimate |
| pd_estim_10_percent_prob | int | PD estimate with 10% probability |
| pd_estim_50_percent_prob | int | PD estimate with 50% probability |
| pd_estim_90_percent_prob | int | PD estimate with 90% probability |
| pd_mean_estimate | int | PD mean estimate |
| pt_estim_10_percent_prob | int | PT estimate with 10% probability |
| pt_estim_50_percent_prob | int | PT estimate with 50% probability |
| pt_estim_90_percent_prob | int | PT estimate with 90% probability |
| pt_mean_estimate | int | PT mean estimate |
| shape_area | int | Area of the shape |
| shape_len | int | Length of the shape |
| geom_geojson | string | Geometry in GeoJSON format |
| geom_geotext | string | Geometry in GeoText format |
| geom_type | string | Type of the geometry |
| geom_centroid | string | Centroid of the geometry |
| geom_center_x | double | X coordinate of the center of the geometry |
| geom_center_y | double | Y coordinate of the center of the geometry |
| geom | binary | Geometry |
Geological Survey of Finland - Rock Operations WFS Reef Type PGE - Reef Type PGE 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 number assigned to the row. |
| gml_id | string | The Global Markup Language (GML) identifier for the row. |
| objectid | int | The unique identifier for the row. |
| tracttype | string | The type of tract. |
| tractname | string | The name of the tract. |
| number_dep_10_percent_prob | int | The number of deposits with a 10 percent probability. |
| number_dep_50_percent_prob | int | The number of deposits with a 50 percent probability. |
| number_dep_90_percent_prob | int | The number of deposits with a 90 percent probability. |
| expected_number_of_dep | int | The expected number of deposits. |
| au_estim_10_percent_prob | int | The estimated gold (Au) amount with a 10 percent probability. |
| au_estim_50_percent_prob | int | The estimated gold (Au) amount with a 50 percent probability. |
| au_estim_90_percent_prob | int | The estimated gold (Au) amount with a 90 percent probability. |
| au_mean_estimate | int | The mean estimated gold (Au) amount. |
| cu_estim_10_percent_prob | int | The estimated copper (Cu) amount with a 10 percent probability. |
| cu_estim_50_percent_prob | int | The estimated copper (Cu) amount with a 50 percent probability. |
| cu_estim_90_percent_prob | int | The estimated copper (Cu) amount with a 90 percent probability. |
| cu_mean_estimate | int | The mean estimated copper (Cu) amount. |
| ni_estim_10_percent_prob | int | The estimated nickel (Ni) amount with a 10 percent probability. |
| ni_estim_50_percent_prob | int | The estimated nickel (Ni) amount with a 50 percent probability. |
| ni_estim_90_percent_prob | int | The estimated nickel (Ni) amount with a 90 percent probability. |
| ni_mean_estimate | int | The mean estimated nickel (Ni) amount. |
| pd_estim_10_percent_prob | int | The estimated palladium (Pd) amount with a 10 percent probability. |
| pd_estim_50_percent_prob | int | The estimated palladium (Pd) amount with a 50 percent probability. |
| pd_estim_90_percent_prob | int | The estimated palladium (Pd) amount with a 90 percent probability. |
| pd_mean_estimate | int | The mean estimated palladium (Pd) amount. |
| pt_estim_10_percent_prob | int | The estimated platinum (Pt) amount with a 10 percent probability. |
| pt_estim_50_percent_prob | int | The estimated platinum (Pt) amount with a 50 percent probability. |
| pt_estim_90_percent_prob | int | The estimated platinum (Pt) amount with a 90 percent probability. |
| pt_mean_estimate | int | The mean estimated platinum (Pt) amount. |
| shape_area | int | The area of the shape. |
| shape_len | int | The length of the shape. |
| geom_geojson | string | The geometry of the shape in GeoJSON format. |
| geom_geotext | string | The geometry of the shape in GeoText format. |
| geom_type | string | The type of geometry of the shape. |
| geom_centroid | string | The centroid of the shape geometry. |
| geom_center_x | double | The X-coordinate of the center of the shape. |
| geom_center_y | double | The Y-coordinate of the center of the shape. |
| geom | binary | The geometry of the shape. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |