Geological Survey of Finland - Rock Operations Well Formation Survey Version History
Click here for a data sample
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 name, object ID, and geometric information. The data in this table can be utilized in data analytics to study the temporal changes in soil vulnerability to vertical movement susceptibility, estimate the probable values and mean estimates for different substances, analyze the variations in soil properties across different tracts, and investigate the geometric characteristics of the soil regions. The data is sourced from the Geological Survey of Finland's website, which originates from Finland (ISO country code: 'FI').
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
