Geological Survey of Finland - Rock Types

The dataset collection consists of one or more tables sourced from the website of Geologian tutkimuskeskus (Geological Survey of Finland). The dataset collection 'rajapinnat_gtk_kalliopera_wfsmustaliuskeet_200k' contains geological data related to rock formations in Finland. The tables within this collection provide information about various rock types, their composition, characteristics, and location. These tables are an invaluable resource for researchers, geologists, and individuals interested in studying the geological aspects of Finland.

Tables

Geological Survey of Finland - Rock Formations (200k)TSV
This table contains data on rock formations from the website of the Geological Survey of Finland (GTK). The data represents various rock types extracted from the mustaliuskeet_200k dataset. It includes information such as extraction date, row number, GML ID, object ID, basis, basis_c3, shape length, geometries in GEOJSON and GEOTEXT formats, geometry type, centroid coordinates, center X coordinate, center Y coordinate, and the full geometry. The data in this table can be utilized for various data analytics purposes, such as studying the distribution of different rock types, analyzing the spatial characteristics of rock formations, identifying the most common basis for rock formations, and examining the relationship between the shape length and the basis of the formations. The Geological...
Geological Survey of Finland - Rock Outcrops (200k) - Version HistoryTSV
This table contains the version history of the rows in the 'Geologian tutkimuskeskus' web site's dataset 'rajapinnat_gtk_kalliopera_wfsmustaliuskeet_200kmustaliuskeet_200k' from the country 'Finland' (ISO country code: 'FI'). The table includes columns such as '_start_date' and '_end_date' which indicate the extraction dates of the row versions. The table can be utilized for various data analytics purposes, such as tracking changes and updates, analyzing temporal patterns, and identifying trends in the 'kalliopera_wfsmustaliuskeet_200kmustaliuskeet_200k' dataset.

Column Descriptions

Geological Survey of Finland - Rock Formations (200k)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The number assigned to each row in the table.
gml_id	string	The GML ID assigned to the object.
objectid	int	The unique identifier for each object.
basis	int	The basis for the object.
basis_c3	string	The basis c3 for the object.
shape_len	int	The length of the shape.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in Geotext format.
geom_type	string	The type of geometry of the object.
geom_centroid	string	The centroid of the object's geometry.
geom_center_x	double	The X-coordinate of the center of the object's geometry.
geom_center_y	double	The Y-coordinate of the center of the object's geometry.
geom	binary	The geometry of the object.

Geological Survey of Finland - Rock Outcrops (200k) - Version History

Column	Type	Comment
_start_date	date	The date when the row version becomes valid.
_end_date	date	The date when the row version expires.
_row_number	long	The unique identifier of each row version.
gml_id	string	The Global Markup Language (GML) identifier of the row.
objectid	int	The unique identifier of the row.
basis	int	The basis of the row version.
basis_c3	string	The basis c3 of the row version.
shape_len	int	The length of the shape in the row.
geom_geojson	string	The geometry data of the row in GeoJSON format.
geom_geotext	string	The geometry data of the row in Geotext format.
geom_type	string	The type of geometry in the row.
geom_centroid	string	The centroid of the geometry in the row.
geom_center_x	double	The x-coordinate of the center point of the geometry in the row.
geom_center_y	double	The y-coordinate of the center point of the geometry in the row.
geom	binary	The full geometry data of the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024