Geological Survey of Finland - Rock Surface Data
Tables
-
Geological Survey of Finland - Rock Operations Well Formation Survey Version HistoryTSV
This table contains the version history of rows from the 'Geological Survey of Finland' (GTK) rock work flow server (WF) soil vulnerability map for vertical movement susceptibility (VMS). The table captures changes in the data over time, with each row representing a different version of the data. The 'start_date' column stores the extraction date of each row, while the 'end_date' column denotes the date when a newer version of the row was extracted from the data source. If the 'end_date' value is null, it means that the row represents the most recent version. The table includes various columns related to the geological properties and estimates for different substances such as lead (Pb), copper (Cu), zinc (Zn), gold (Au), and others. It also includes columns for the tract type, tract...
-
Geological Survey of Finland - Rock Types with VMS DepositsTSV
This table contains data from the 'Geological Survey of Finland' (Geologian tutkimuskeskus). It provides information on various attributes related to rock formations and mineral deposits. The data includes the extraction date, unique row number, GML ID, object ID, tract type, tract name, and estimates for different minerals such as copper, lead, zinc, gold, and silver. Additionally, it includes the probability of occurrence for different depth levels and the expected number of deposits. The table also contains geometrical information such as shape area, shape length, and various representations of the geometry. The data can be utilized for data analytics to analyze the distribution and characteristics of different mineral deposits, assess probabilities of occurrence, and study the...
Column Descriptions
Geological Survey of Finland - Rock Types with VMS Deposits
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the data entry. |
| gml_id | string | The GML identifier for the record. |
| objectid | int | The unique identifier for the object. |
| 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. |
| ag_estim_10_percent_prob | int | The agriculture estimate with 10% probability. |
| ag_estim_50_percent_prob | int | The agriculture estimate with 50% probability. |
| ag_estim_90_percent_prob | int | The agriculture estimate with 90% probability. |
| ag_mean_estimate | int | The mean agriculture estimate. |
| au_estim_10_percent_prob | int | The gold estimate with 10% probability. |
| au_estim_50_percent_prob | int | The gold estimate with 50% probability. |
| au_estim_90_percent_prob | int | The gold estimate with 90% probability. |
| au_mean_estimate | int | The mean gold estimate. |
| cu_estim_10_percent_prob | int | The copper estimate with 10% probability. |
| cu_estim_50_percent_prob | int | The copper estimate with 50% probability. |
| cu_estim_90_percent_prob | int | The copper estimate with 90% probability. |
| cu_mean_estimate | int | The mean copper estimate. |
| pb_estim_10_percent_prob | int | The lead estimate with 10% probability. |
| pb_estim_50_percent_prob | int | The lead estimate with 50% probability. |
| pb_estim_90_percent_prob | int | The lead estimate with 90% probability. |
| pb_mean_estimate | int | The mean lead estimate. |
| zn_estim_10_percent_prob | int | The zinc estimate with 10% probability. |
| zn_estim_50_percent_prob | int | The zinc estimate with 50% probability. |
| zn_estim_90_percent_prob | int | The zinc estimate with 90% probability. |
| zn_mean_estimate | int | The mean zinc estimate. |
| 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 geometry in Geotext format. |
| geom_type | string | The type of the geometry. |
| geom_centroid | string | The centroid point 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 binary representation of the geometry. |
Geological Survey of Finland - Rock Operations Well Formation Survey Version History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period of the row version. |
| _end_date | date | The end date of the validity period of the row version. |
| _row_number | long | The number assigned to the row. |
| gml_id | string | The GML ID of the row. |
| objectid | int | The ID of the object. |
| 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. |
| ag_estim_10_percent_prob | int | The agricultural estimation with a 10 percent probability. |
| ag_estim_50_percent_prob | int | The agricultural estimation with a 50 percent probability. |
| ag_estim_90_percent_prob | int | The agricultural estimation with a 90 percent probability. |
| ag_mean_estimate | int | The mean estimate of agricultural estimation. |
| au_estim_10_percent_prob | int | The estimation of au with a 10 percent probability. |
| au_estim_50_percent_prob | int | The estimation of au with a 50 percent probability. |
| au_estim_90_percent_prob | int | The estimation of au with a 90 percent probability. |
| au_mean_estimate | int | The mean estimate of au estimation. |
| cu_estim_10_percent_prob | int | The estimation of cu with a 10 percent probability. |
| cu_estim_50_percent_prob | int | The estimation of cu with a 50 percent probability. |
| cu_estim_90_percent_prob | int | The estimation of cu with a 90 percent probability. |
| cu_mean_estimate | int | The mean estimate of cu estimation. |
| pb_estim_10_percent_prob | int | The estimation of pb with a 10 percent probability. |
| pb_estim_50_percent_prob | int | The estimation of pb with a 50 percent probability. |
| pb_estim_90_percent_prob | int | The estimation of pb with a 90 percent probability. |
| pb_mean_estimate | int | The mean estimate of pb estimation. |
| zn_estim_10_percent_prob | int | The estimation of zn with a 10 percent probability. |
| zn_estim_50_percent_prob | int | The estimation of zn with a 50 percent probability. |
| zn_estim_90_percent_prob | int | The estimation of zn with a 90 percent probability. |
| zn_mean_estimate | int | The mean estimate of zn estimation. |
| 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 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 center of the geometry. |
| geom_center_y | double | The y coordinate of the center of the geometry. |
| geom | binary | The geometry. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |