History of Geologic Survey Rock Types in Kuusamo, Finland

To download the data set, please sign up or log in

Click here for a data sample

This table contains the version history of the rows extracted from the dataset sourced from the website of the 'Geological Survey of Finland', originating from the country with the ISO country code 'FI'. The table '_rajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_aukuusamotyypin_coauhistory' is derived from the base table '_rajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_au__kuusamotyypin_coau', and it includes additional columns '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' column has a null value, it indicates that the row is the most recent version. The table contains various columns such as 'gml_id', 'objectid', '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', 'co_estim_10_percent_prob', 'co_estim_50_percent_prob', 'co_estim_90_percent_prob', 'co_mean_estimate', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns include various data related to geology and surveys, such as the probability and estimated number of deposits, mean estimates, shape area and length, as well as various geometrical data. The historical data in this table can be utilized in data analytics to analyze changes over time, track trends, perform geospatial analysis, and gain insights into geological observations and patterns.

Field Descriptions

Name Data type Description
_start_datedateThe start date indicating the beginning of the validity period of the row version.
_end_datedateThe end date indicating the end of the validity period of the row version.
_row_numberlongThe number assigned to each row in the table.
gml_idstringThe GML ID of the row.
objectidintThe ID of the object in the table.
tracttypestringThe type of tract.
tractnamestringThe name of the tract.
number_dep_10_percent_probintThe number of dependencies with a 10 percent probability.
number_dep_50_percent_probintThe number of dependencies with a 50 percent probability.
number_dep_90_percent_probintThe number of dependencies with a 90 percent probability.
expected_number_of_depintThe expected number of dependencies.
au_estim_10_percent_probintThe estimated area unit with a 10 percent probability.
au_estim_50_percent_probintThe estimated area unit with a 50 percent probability.
au_estim_90_percent_probintThe estimated area unit with a 90 percent probability.
au_mean_estimateintThe mean estimate of the area unit.
co_estim_10_percent_probintThe estimated count with a 10 percent probability.
co_estim_50_percent_probintThe estimated count with a 50 percent probability.
co_estim_90_percent_probintThe estimated count with a 90 percent probability.
co_mean_estimateintThe mean estimate of the count.
shape_areaintThe area of the shape.
shape_lenintThe length of the shape.
geom_geojsonstringThe geometry of the row in GeoJSON format.
geom_geotextstringThe geometry of the row in geotext format.
geom_typestringThe type of geometry.
geom_centroidstringThe centroid of the geometry.
geom_center_xdoubleThe x-coordinate of the center of the geometry.
geom_center_ydoubleThe y-coordinate of the center of the geometry.
geombinaryThe geometry of the row.

No sample for this dataset

Additional Information

Last updated April 22, 2024
Created April 22, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_geologian_tutkimuskeskus
Id26376fb4-42e2-4ada-9026-95fe4ca29061
Package id15074930-4212-41f9-81bb-c0ffdaaca037
Position1
Revision id211e4019-67c0-41e5-85e0-706aa6313632
Stateactive
Tablerajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_au__kuusamotyypin_coau__history