Geological Survey of Finland - Rock Structures with Fissures 200K

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

Tables

Rock Structures from Geological Survey of Finland in FinlandTSV
The table contains data from 'Geological Survey of Finland' (Geologian tutkimuskeskus) website. It provides information about rock fold structures (poimurakenteet) with various attributes. The table includes columns such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'fold_type', 'fold_type_c3', 'fold_system', 'fold_system_c5', 'fold', 'fold_c7', 'basis', 'basis_c9', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized for data analytics by performing various analysis and exploration tasks such as studying the distribution and characteristics of different rock fold types and systems, calculating metrics like shape length, and examining the spatial relationships and patterns using the...
Version History of Poimurakenteet 200k Data from Geological Survey of Finland (GTK) in FinlandTSV
This table contains the version history of the rows in the base table 'poimurakenteet_200k'. It is sourced from the website of the 'Geological Survey of Finland' from the country 'Finland' (ISO country code 'fi'). The table has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The data in this table can be utilized in data analytics to analyze the changes in the fold types, fold systems, basis, and geometry of the rock structures over time. It can provide insights into the evolution of rock formations and their characteristics in different regions of Finland.

Column Descriptions

Rock Structures from Geological Survey of Finland in Finland

Column	Type	Comment
_extract_date	date	The date at which the data was extracted.
_row_number	long	The row number of the data in the table.
gml_id	string	The GML identifier for the object.
objectid	int	The unique identifier for the object.
fold_type	int	The type of fold observed in the object.
fold_type_c3	string	The category of fold type observed.
fold_system	int	The fold system associated with the object.
fold_system_c5	string	The category of fold system observed.
fold	int	The specific fold observed.
fold_c7	string	The category of fold observed.
basis	int	The basis for the object.
basis_c9	string	The category of basis observed.
shape_len	int	The length of the shape in the object.
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 observed.
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 object.

Version History of Poimurakenteet 200k Data from Geological Survey of Finland (GTK) in 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	The row number of the version history entry.
gml_id	string	The identifier of the row version in GML format.
objectid	int	The unique identifier of the row version object.
fold_type	int	The type of folding observed.
fold_type_c3	string	The categorization of folding type using C3 classification.
fold_system	int	The system or pattern of folding observed.
fold_system_c5	string	The categorization of folding system using C5 classification.
fold	int	The fold characteristics for the row version.
fold_c7	string	The categorization of fold characteristics using C7 classification.
basis	int	The basis or reference for the row version.
basis_c9	string	The categorization of basis using C9 classification.
shape_len	int	The length of the shape or geometry of 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 point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The complete geometry of the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024