Geological Survey of Finland - Rock Types - Volcanic - Volcanic Magmatic - Version History
Click here for a data sample
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 the date when a new version of the row was extracted. If the '_end_date' column has a null value, it means that the row is the most recent version. This table can be used for various data analytics purposes, such as studying the distribution and characteristics of geological tracts, analyzing the relationship between deposits and tract attributes, and performing spatial analysis using the geometry information.
Field Descriptions
Name |
Data type |
Description |
_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. |