Geological Survey of Finland - Rock Profiles Dataset Collection

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

Geological Survey of Finland - Lithological Form LinesTSV
This table contains lithological form data extracted from the website of Geologian tutkimuskeskus in Finland. The data includes various attributes related to lithological forms such as their IDs, object IDs, basis, shape length, and geometric information. The table can be utilized for data analytics purposes such as studying the distribution of lithological forms, analyzing their characteristics, calculating geometric properties, and performing spatial analysis on the data.
Version History - Lithological Features - Geology Survey of Finland - FinlandTSV
This table contains the version history of the rows extracted from the data source 'Geological Survey of Finland (GTK)' located in the country 'Finland'. It provides a historical record of the 'lithological_form' data from the base table 'litologiset_muotoviivat'. Each row in this table represents a specific version of the lithological form, identified by the 'gml_id' and 'objectid' columns. The '_start_date' column indicates the date when the version was extracted, while the '_end_date' column signifies the date when a new version was obtained. If the '_end_date' value is null, it indicates that the row represents the most recent version. The other columns in this table, such as 'basis', 'basis_c5', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid',...

Column	Type	Comment
_extract_date	date	The date the data was extracted.
_row_number	long	The row number of the data.
gml_id	string	The identifier for the GML object.
objectid	int	The identifier for the object.
lithological_form	int	The description of the lithological form.
lithological_form_c3	string	The description of the lithological form with a code of length 3.
basis	int	The basis of the data.
basis_c5	string	The basis of the data with a code of length 5.
shape_len	int	The length of the shape.
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.
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 full geometry data.

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 in the version history.
gml_id	string	The GML identifier of the row version.
objectid	int	The object identifier of the row version.
lithological_form	int	The lithological form of the row version.
lithological_form_c3	string	The lithological form C3 of the row version.
basis	int	The basis of the row version.
basis_c5	string	The basis C5 of the row version.
shape_len	int	The length measurement of the shape of the row version.
geom_geojson	string	The geojson representation of the geometry of the row version.
geom_geotext	string	The geotext representation of the geometry of the row version.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid point of the geometry of the row version.
geom_center_x	double	The X coordinate of the center point of the geometry of the row version.
geom_center_y	double	The Y coordinate of the center point of the geometry of the row version.
geom	binary	The geometry of the row version.

Last Updated	April 22, 2024
Created	April 22, 2024