Table Collection from 'Geological Survey of Finland' Website in Finland

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

Tables

Geological Survey of Finland - Rock Formation Structures in Workflows, FinlandTSV
This table contains data from the 'Geological Survey of Finland' on rock structures found in the country with ISO country code 'fi'. The table provides information on various attributes of rock structures such as the ID, type of fold, fold system, basis, shape length, geometry, and centroid. The data in this table can be utilized in data analytics to perform geological analysis, study patterns of fold types and systems, analyze basis factors, calculate shape characteristics, and perform spatial analysis using the provided geometry and centroid coordinates.
Geological Survey of Finland Rock Structure WFS - Point Structures (Version History)TSV
This table contains the version history of the rows from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) pertaining to the 'Fold Structure Points' (Finstructure Poimurakenteet). It is a historical record of changes made to the base table 'Fold Structure Points'. The table maintains the previous versions of each row along with the start and end dates. The '_start_date' column represents the date when a particular version of the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. This table can be useful for data analytics purposes. For example, it can help in analyzing the historical changes and evolution...

Column Descriptions

Geological Survey of Finland - Rock Formation Structures in Workflows, Finland

Column	Type	Comment
_extract_date	date	The date the data was extracted.
_row_number	long	A sequential number assigned to each row.
gml_id	string	The unique identifier for the GML object.
objectid	int	The unique identifier for the object.
fold_type	int	The type of fold.
fold_type_c3	string	The type of fold in code 3.
fold_system	int	The system of fold.
fold_system_c5	string	The system of fold in code 5.
fold	int	The fold information.
fold_c7	string	The fold information in code 7.
basis	int	The basis for the data.
basis_c9	string	The basis for the data in code 9.
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 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.

Geological Survey of Finland Rock Structure WFS - Point Structures (Version History)

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number assigned to the row version.
gml_id	string	The ID assigned to the row in GML format.
objectid	int	The unique identifier of the row.
fold_type	int	The type of fold.
fold_type_c3	string	The type of fold with additional classification C3.
fold_system	int	The system of fold.
fold_system_c5	string	The system of fold with additional classification C5.
fold	int	The fold value.
fold_c7	string	The fold value with additional classification C7.
basis	int	The basis value.
basis_c9	string	The basis value with additional classification C9.
shape_len	int	The length of the shape in the row.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024