Geological Survey of Finland - Geological interfaces in GTK rock environment (WFS Kuusamo Type Co.au)

The dataset collection consists of one or more dataset tables sourced from the website of 'Geological Survey of Finland' in the country Finland.

Tables

Geological Survey of Finland - Rock Layers in Kuusamo, FinlandTSV
The table rajapinnat_gtk_kalliopera_wfskuusamo_tyypin_co_au__kuusamotyypin_coau contains data from the Geologian tutkimuskeskus website of Finland. It includes various columns such as _extract_date, _row_number, 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. This table can be utilized for various data analytics tasks such as analyzing the probabilities of different deposit types, estimating...
History of Geologic Survey Rock Types in Kuusamo, FinlandTSV
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',...

Column Descriptions

Geological Survey of Finland - Rock Layers in Kuusamo, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of each record in the table.
gml_id	string	The unique identifier for each record in GML format.
objectid	int	The unique identifier for each record in the table.
tracttype	string	The type of tract associated with each record.
tractname	string	The name of the tract associated with each record.
number_dep_10_percent_prob	int	The number of dependents with a 10% probability.
number_dep_50_percent_prob	int	The number of dependents with a 50% probability.
number_dep_90_percent_prob	int	The number of dependents with a 90% probability.
expected_number_of_dep	int	The expected number of dependents.
au_estim_10_percent_prob	int	The estimated area unit with 10% probability.
au_estim_50_percent_prob	int	The estimated area unit with 50% probability.
au_estim_90_percent_prob	int	The estimated area unit with 90% probability.
au_mean_estimate	int	The mean estimate of the area unit.
co_estim_10_percent_prob	int	The estimated county with 10% probability.
co_estim_50_percent_prob	int	The estimated county with 50% probability.
co_estim_90_percent_prob	int	The estimated county with 90% probability.
co_mean_estimate	int	The mean estimate of the county.
shape_area	int	The area of the shape in square units.
shape_len	int	The length of the shape in units.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in GeoText format.
geom_type	string	The type of geometry associated with each record.
geom_centroid	string	The centroid coordinates 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 full geometry data.

History of Geologic Survey Rock Types in Kuusamo, Finland

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period of the row version.
_end_date	date	The end date indicating the end of the validity period of the row version.
_row_number	long	The number assigned to each row in the table.
gml_id	string	The GML ID of the row.
objectid	int	The ID of the object in the table.
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.
au_estim_10_percent_prob	int	The estimated area unit with a 10 percent probability.
au_estim_50_percent_prob	int	The estimated area unit with a 50 percent probability.
au_estim_90_percent_prob	int	The estimated area unit with a 90 percent probability.
au_mean_estimate	int	The mean estimate of the area unit.
co_estim_10_percent_prob	int	The estimated count with a 10 percent probability.
co_estim_50_percent_prob	int	The estimated count with a 50 percent probability.
co_estim_90_percent_prob	int	The estimated count with a 90 percent probability.
co_mean_estimate	int	The mean estimate of the count.
shape_area	int	The area of the shape.
shape_len	int	The length of the shape.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row 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 of the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024