Geological Survey of Finland (GTK) - Geological Bedrock Classification

The dataset collection consists of one or more dataset tables sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus) in Finland.

Tables

Geological Survey of Finland - Quality Classification of Rock Terrain WFS DataTSV
This table originates from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). It contains data related to the quality classification of rock operation data. The table includes information such as the extraction date of the data, row numbers, GML ID, object ID, quality class, classification for quality class C3, geophysics information, classification for geophysics C5, remarks, shape area, shape length, geometric data in GeoJSON format, geometric data in Geotext format, geometric type, centroid of the geometric shape, center X coordinate of the geometric shape, center Y coordinate of the geometric shape, and the actual geometric data. This table can be utilized in various data analytic tasks such as studying trends in quality class and geophysics, analyzing the...
Version History of Quality Classification of Geological Survey Data from Geologian tutkimuskeskus (Finland)TSV
This table contains the version history of the rows of a base table named 'aineiston_laatuluokitus'. The table 'rajapinnat_gtk_kalliopera_wfsaineiston_laatuluokitusaineiston_laatuluokitushistory' is sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus), which originates from the country with the ISO country code 'fi' (Finland). It includes columns such as '_start_date' which indicates the date when the row was extracted, and '_end_date' which signifies the date when a new version of the row was extracted. By analyzing this version history, data analysts can track changes made over time to the quality class, geophysics, remarks, and geometry attributes of the data. This can help in identifying trends and patterns in quality class assignments, geophysical...

Column Descriptions

Geological Survey of Finland - Quality Classification of Rock Terrain WFS Data

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the entry.
gml_id	string	The unique identifier of the GML object.
objectid	int	The object identifier.
quality_class	int	The quality class of the object.
quality_class_c3	string	The quality class C3 of the object.
geophysics	int	The geophysics information of the object.
geophysics_c5	string	The geophysics C5 information of the object.
remarks	string	Any additional remarks or comments.
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 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.

Version History of Quality Classification of Geological Survey Data from Geologian tutkimuskeskus (Finland)

Column	Type	Comment
_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	A unique identifier for each row version.
gml_id	string	The GML identifier for the row version.
objectid	int	The identifier for the row version in the base table.
quality_class	int	The quality class of the row version.
quality_class_c3	string	The quality class of the row version with C3 classification.
geophysics	int	The geophysics of the row version.
geophysics_c5	string	The geophysics of the row version with C5 classification.
remarks	string	Any additional remarks or comments for the row version.
shape_area	int	The area of the shape for the row version.
shape_len	int	The length of the shape for the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in geotext format.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid of the geometry for the row version.
geom_center_x	double	The x-coordinate of the center of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center of the geometry for the row version.
geom	binary	The geometry for the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024