Geological Survey of Finland - Rock Parameters from Web Feature Service

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

Tables

Age Determinations of Rock Samples from Geologian tutkimuskeskus, FinlandTSV
This table contains data from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) sourced from the country 'Finland' (ISO country code: 'fi'). The table provides detailed information about age determination for various rock samples. It contains columns such as '_extract_date' (date of extraction), '_row_number' (row number), 'gml_id' (GML ID), 'objectid' (unique identifier), 'age_determination_id' (age determination identifier), 'sample_field_code' (field code of the sample), 'map_sheet' (map sheet reference), 'northing' (northing coordinate), 'easting' (easting coordinate), 'ykj_north_original' (original YKJ north coordinate), 'ykj_east_original' (original YKJ east coordinate), 'location' (location information), 'rock_type' (type of rock), 'mineral' (mineral), 'mineral_c12'...
Geological Survey of Finland - Rock Formation Age Determinations HistoryTSV
This table contains the version history for the rows of the base table 'rajapinnat_gtk_kalliopera_wfsikamaaritykset__ikamaaritykset'. Each row in this table represents a specific version of a row in the base table, and includes the start and end dates of the version. The data in this table is sourced from 'Geological Survey of Finland' which originates from the country 'Finland' (ISO country code 'fi'). The table includes various columns which provide information about age determinations, sample field codes, map sheets, geographical coordinates, rock types, minerals, analytical method details, age reliability, publication status, references, comments, age legends, error estimates, and geometric properties. By analyzing the data in this table, one can gain insights into the temporal...

Column Descriptions

Age Determinations of Rock Samples from Geologian tutkimuskeskus, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the entry in the table.
gml_id	string	The unique identifier of the entry in GML format.
objectid	int	The unique identifier of the entry.
age_determination_id	string	The unique identifier of the age determination.
sample_field_code	string	The field code of the sample.
map_sheet	int	The map sheet reference.
northing	int	The northing coordinate of the location.
easting	int	The easting coordinate of the location.
ykj_north_original	int	The original YKJ north coordinate.
ykj_east_original	int	The original YKJ east coordinate.
location	string	The location description.
rock_type	string	The type of rock.
mineral	string	The mineral found.
mineral_c12	string	The C12 isotope of the mineral.
system	string	The geological system.
method	string	The method used for age determination.
number_of_analyses	int	The number of analyses conducted.
reliability_of_age	string	The reliability of the age determination.
epsilon_nd_age	float	The epsilon value for the Nd age.
published	string	Indicates whether the age is published or not.
reference	string	The reference source for the age determination.
comments	string	Additional comments or notes.
age_legend	int	The legend for the age determination.
error_two_sigma_legend	int	The legend for the two sigma error.
age2_legend	int	The legend for the second age determination.
error_two_sigma_legend2	int	The legend for the two sigma error of the second age determination.
age_determined	int	The determined age.
error_estimate_two_sigma	int	The two sigma error estimate.
lower_intercept_age_u_pb	int	The lower intercept age determined using U-Pb.
error_lower_intercept_age	int	The error in the lower intercept age.
mineral2	string	The second mineral found.
mineral2_c30	string	The C30 isotope of the second mineral.
age_determined2	int	The determined age of the second mineral.
error_estimate_two_sigma2	int	The two sigma error estimate of the second mineral.
geom_geojson	string	The geometrical data in GeoJSON format.
geom_geotext	string	The geometrical 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 geometry center.
geom_center_y	double	The Y-coordinate of the geometry center.
geom	binary	The full geometry information.

Geological Survey of Finland - Rock Formation Age Determinations History

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The row number of the version history.
gml_id	string	The ID of the GML object.
objectid	int	The object ID.
age_determination_id	string	The ID of the age determination.
sample_field_code	string	The code of the sample field.
map_sheet	int	The map sheet.
northing	int	The northing coordinate.
easting	int	The easting coordinate.
ykj_north_original	int	The original YKJ north coordinate.
ykj_east_original	int	The original YKJ east coordinate.
location	string	The location.
rock_type	string	The type of rock.
mineral	string	The mineral.
mineral_c12	string	The C12 isotope of the mineral.
system	string	The system.
method	string	The method.
number_of_analyses	int	The number of analyses.
reliability_of_age	string	The reliability of age determination.
epsilon_nd_age	float	The Epsilon ND age.
published	string	The publication status.
reference	string	The reference.
comments	string	Comments.
age_legend	int	The legend for age determination.
error_two_sigma_legend	int	The legend for error estimation with two sigma.
age2_legend	int	The legend for the second age determination.
error_two_sigma_legend2	int	The legend for error estimation with two sigma for the second age determination.
age_determined	int	The determined age.
error_estimate_two_sigma	int	The error estimate with two sigma.
lower_intercept_age_u_pb	int	The lower intercept age in U-Pb.
error_lower_intercept_age	int	The error estimate for the lower intercept age.
mineral2	string	The second mineral.
mineral2_c30	string	The C30 isotope of the second mineral.
age_determined2	int	The determined age for the second mineral.
error_estimate_two_sigma2	int	The error estimate with two sigma for the second mineral.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in geotext format.
geom_type	string	The geometry type.
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