Geological Survey of Finland (GTK) - Rock Chemistry History

To download the data set, please sign up or log in

This table stores the version history of the rows in the 'Geological Survey of Finland - Rock Geochemistry' dataset. The dataset provides information about various rock samples collected in Finland. Each row represents a specific version of a rock sample, and includes data such as the start date and end date of the version, row number, unique identifiers, geographical coordinates, rock type, composition, mineral content, and various chemical measurements. The table also includes information about the sampling process, including the sampling date, area, device, and notes. The data in this table can be utilized in data analytics for various purposes, such as studying the temporal changes in rock composition, analyzing the distribution of different rock types, exploring correlations between mineral content and chemical measurements, and investigating the relationship between rock properties and geographical locations. The table is sourced from the website of the Geological Survey of Finland, which originates from Finland (ISO country code: FI).

Field Descriptions

Name	Data type	Description
_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 row number of the version.
gml_id	string	The GML ID of the row.
objectid	int	The ID of the object.
labnum	int	The laboratory number.
northing	int	The northing value of the location.
easting	int	The easting value of the location.
northing_kkj3	int	The northing KKJ3 value of the location.
easting_kkj3	int	The easting KKJ3 value of the location.
mapsheet	int	The map sheet name.
rocktype	string	The type of rock.
rocknamefield	string	The name of the rock.
rocktypegroup	int	The group of rock types.
rocktypegroup_c11	string	The group of rock type based on C11 classification.
composition	int	The composition of the rock.
composition_c13	string	The rock composition based on C13 classification.
subgroup	int	The subgroup of the rock.
subgroup_c15	string	The subgroup of the rock based on C15 classification.
mineral1	string	The first mineral.
mineral2	string	The second mineral.
mineral3	string	The third mineral.
mineral4	string	The fourth mineral.
oremineral1	string	The first ore mineral.
oremineral2	string	The second ore mineral.
oremineral3	string	The third ore mineral.
oremineral4	string	The fourth ore mineral.
average_grainsize_millimeter	string	The average grain size in millimeters.
maximum_grainsize_millimeter	string	The maximum grain size in millimeters.
metamorphicgrade	string	The grade of metamorphism.
migmatisation	string	The migmatisation value.
deformation	string	The deformation value.
alteration	string	The alteration value.
unit	int	The unit value.
agegroup	string	The age group value.
duplicate	string	The duplicate value.
sampler	string	The name of the sampler.
samdate	int	The date of sampling.
samtype	string	The type of sample.
samarea	int	The area of the sample.
samdevice	string	The device used for sampling.
thinsection	int	The thin section value.
notes	string	Any additional notes.
sio2_xrf_lrc	string	The silicon dioxide value determined by XRF LRC method.
sio2_xrf_percent	int	The silicon dioxide percentage determined by XRF method.
tio2_xrf_lrc	string	The titanium dioxide value determined by XRF LRC method.
tio2_xrf_percent	int	The titanium dioxide percentage determined by XRF method.
al2o3_xrf_lrc	string	The aluminum oxide value determined by XRF LRC method.
al2o3_xrf_percent	int	The aluminum oxide percentage determined by XRF method.
feo_xrf_lrc	string	The iron oxide value determined by XRF LRC method.
feo_xrf_percent	int	The iron oxide percentage determined by XRF method.
mno_xrf_lrc	string	The manganese oxide value determined by XRF LRC method.
mno_xrf_percent	int	The manganese oxide percentage determined by XRF method.
mgo_xrf_lrc	string	The magnesium oxide value determined by XRF LRC method.
mgo_xrf_percent	int	The magnesium oxide percentage determined by XRF method.
cao_xrf_lrc	string	The calcium oxide value determined by XRF LRC method.
cao_xrf_percent	int	The calcium oxide percentage determined by XRF method.
na2o_xrf_lrc	string	The sodium oxide value determined by XRF LRC method.
na2o_xrf_percent	int	The sodium oxide percentage determined by XRF method.
k2o_xrf_lrc	string	The potassium oxide value determined by XRF LRC method.
k2o_xrf_percent	int	The potassium oxide percentage determined by XRF method.
p2o5_xrf_lrc	string	The phosphorous pentoxide value determined by XRF LRC method.
p2o5_xrf_percent	int	The phosphorous pentoxide percentage determined by XRF method.
ba_xrf_lrc	string	The barium value determined by XRF LRC method.
ba_xrf_ppm	int	The barium parts per million value determined by XRF method.
cl_xrf_lrc	string	The chlorine value determined by XRF LRC method.
cl_xrf_ppm	int	The chlorine parts per million value determined by XRF method.
cr_xrf_lrc	string	The chromium value determined by XRF LRC method.
cr_xrf_ppm	int	The chromium parts per million value determined by XRF method.
cu_xrf_lrc	string	The copper value determined by XRF LRC method.
cu_xrf_ppm	int	The copper parts per million value determined by XRF method.
ga_xrf_lrc	string	The gallium value determined by XRF LRC method.
ga_xrf_ppm	int	The gallium parts per million value determined by XRF method.
mo_xrf_lrc	string	The molybdenum value determined by XRF LRC method.
mo_xrf_ppm	int	The molybdenum parts per million value determined by XRF method.
nb_xrf_lrc	string	The niobium value determined by XRF LRC method.
nb_xrf_ppm	int	The niobium parts per million value determined by XRF method.
ni_xrf_lrc	string	The nickel value determined by XRF LRC method.
ni_xrf_ppm	int	The nickel parts per million value determined by XRF method.
pb_xrf_lrc	string	The lead value determined by XRF LRC method.
pb_xrf_ppm	int	The lead parts per million value determined by XRF method.
rb_xrf_lrc	string	The rubidium value determined by XRF LRC method.
rb_xrf_ppm	int	The rubidium parts per million value determined by XRF method.
s_xrf_lrc	string	The sulfur value determined by XRF LRC method.
s_xrf_ppm	int	The sulfur parts per million value determined by XRF method.
sr_xrf_lrc	string	The strontium value determined by XRF LRC method.
sr_xrf_ppm	int	The strontium parts per million value determined by XRF method.
v_xrf_lrc	string	The vanadium value determined by XRF LRC method.
v_xrf_ppm	int	The vanadium parts per million value determined by XRF method.
y_xrf_lrc	string	The yttrium value determined by XRF LRC method.
y_xrf_ppm	int	The yttrium parts per million value determined by XRF method.
zn_xrf_lrc	string	The zinc value determined by XRF LRC method.
zn_xrf_ppm	int	The zinc parts per million value determined by XRF method.
zr_xrf_lrc	string	The zirconium value determined by XRF LRC method.
zr_xrf_ppm	int	The zirconium parts per million value determined by XRF method.
c_tot_lrc	string	The total carbon value determined by LRC method.
c_tot_percent	int	The total carbon percentage.
c_noncarbo_lrc	string	The non-carbonate carbon value determined by LRC method.
c_noncarbo_percent	int	The non-carbonate carbon percentage.
f_lrc	string	The fluorine value determined by LRC method.
f_percent	int	The fluorine percentage.
al_icpaes_lrc	string	The aluminum value determined by ICP-AES LRC method.
al_icpaes_ppm	int	The aluminum parts per million value determined by ICP-AES method.
b_icpaes_lrc	string	The boron value determined by ICP-AES LRC method.
b_icpaes_ppm	int	The boron parts per million value determined by ICP-AES method.
ba_icpaes_lrc	string	The barium value determined by ICP-AES LRC method.
ba_icpaes_ppm	int	The barium parts per million value determined by ICP-AES method.
ca_icpaes_lrc	string	The calcium value determined by ICP-AES LRC method.
ca_icpaes_ppm	int	The calcium parts per million value determined by ICP-AES method.
co_icpaes_lrc	string	The cobalt value determined by ICP-AES LRC method.
co_icpaes_ppm	int	The cobalt parts per million value determined by ICP-AES method.
cr_icpaes_lrc	string	The chromium value determined by ICP-AES LRC method.
cr_icpaes_ppm	int	The chromium parts per million value determined by ICP-AES method.
cu_icpaes_lrc	string	The copper value determined by ICP-AES LRC method.
cu_icpaes_ppm	int	The copper parts per million value determined by ICP-AES method.
fe_icpaes_lrc	string	The iron value determined by ICP-AES LRC method.
fe_icpaes_ppm	int	The iron parts per million value determined by ICP-AES method.
k_icpaes_lrc	string	The potassium value determined by ICP-AES LRC method.
k_icpaes_ppm	int	The potassium parts per million value determined by ICP-AES method.
la_icpaes_lrc	string	The lanthanum value determined by ICP-AES LRC method.
la_icpaes_ppm	int	The lanthanum parts per million value determined by ICP-AES method.
li_icpaes_lrc	string	The lithium value determined by ICP-AES LRC method.
li_icpaes_ppm	int	The lithium parts per million value determined by ICP-AES method.
mg_icpaes_lrc	string	The magnesium value determined by ICP-AES LRC method.
mg_icpaes_ppm	int	The magnesium parts per million value determined by ICP-AES method.
mn_icpaes_lrc	string	The manganese value determined by ICP-AES LRC method.
mn_icpaes_ppm	int	The manganese parts per million value determined by ICP-AES method.
mo_icpaes_lrc	string	The molybdenum value determined by ICP-AES LRC method.
mo_icpaes_ppm	int	The molybdenum parts per million value determined by ICP-AES method.
na_icpaes_lrc	string	The sodium value determined by ICP-AES LRC method.
na_icpaes_ppm	int	The sodium parts per million value determined by ICP-AES method.
ni_icpaes_lrc	string	The nickel value determined by ICP-AES LRC method.
ni_icpaes_ppm	int	The nickel parts per million value determined by ICP-AES method.
p_icpaes_lrc	string	The phosphorous value determined by ICP-AES LRC method.
p_icpaes_ppm	int	The phosphorous parts per million value determined by ICP-AES method.
pb_icpaes_lrc	string	The lead value determined by ICP-AES LRC method.
pb_icpaes_ppm	int	The lead parts per million value determined by ICP-AES method.
s_icpaes_lrc	string	The sulfur value determined by ICP-AES LRC method.
s_icpaes_ppm	int	The sulfur parts per million value determined by ICP-AES method.
sc_icpaes_lrc	string	The scandium value determined by ICP-AES LRC method.
sc_icpaes_ppm	int	The scandium parts per million value determined by ICP-AES method.
sr_icpaes_lrc	string	The strontium value determined by ICP-AES LRC method.
sr_icpaes_ppm	int	The strontium parts per million value determined by ICP-AES method.
th_icpaes_lrc	string	The thorium value determined by ICP-AES LRC method.
th_icpaes_ppm	int	The thorium parts per million value determined by ICP-AES method.
ti_icpaes_lrc	string	The titanium value determined by ICP-AES LRC method.
ti_icpaes_ppm	int	The titanium parts per million value determined by ICP-AES method.
v_icpaes_lrc	string	The vanadium value determined by ICP-AES LRC method.
v_icpaes_ppm	int	The vanadium parts per million value determined by ICP-AES method.
y_icpaes_lrc	string	The yttrium value determined by ICP-AES LRC method.
y_icpaes_ppm	int	The yttrium parts per million value determined by ICP-AES method.
zn_icpaes_lrc	string	The zinc value determined by ICP-AES LRC method.
zn_icpaes_ppm	int	The zinc parts per million value determined by ICP-AES method.
as_gfaas_lrc	string	The arsenic value determined by GFAAS LRC method.
as_gfaas_ppm	int	The arsenic parts per million value determined by GFAAS method.
bi_gfaas_lrc	string	The bismuth value determined by GFAAS LRC method.
bi_gfaas_ppm	int	The bismuth parts per million value determined by GFAAS method.
se_gfaas_lrc	string	The selenium value determined by GFAAS LRC method.
se_gfaas_ppm	int	The selenium parts per million value determined by GFAAS method.
au_gfaas_lrc	string	The gold value determined by GFAAS LRC method.
au_gfaas_ppb	int	The gold parts per billion value determined by GFAAS method.
pd_gfaas_lrc	string	The palladium value determined by GFAAS LRC method.
pd_gfaas_ppb	int	The palladium parts per billion value determined by GFAAS method.
te_gfaas_lrc	string	The tellurium value determined by GFAAS LRC method.
te_gfaas_ppb	int	The tellurium parts per billion value determined by GFAAS method.
ce_icpms_lrc	string	The cerium value determined by ICP-MS LRC method.
ce_icpms_ppm	int	The cerium parts per million value determined by ICP-MS method.
co_icpms_lrc	string	The cobalt value determined by ICP-MS LRC method.
co_icpms_ppm	int	The cobalt parts per million value determined by ICP-MS method.
dy_icpms_lrc	string	The dysprosium value determined by ICP-MS LRC method.
dy_icpms_ppm	int	The dysprosium parts per million value determined by ICP-MS method.
er_icpms_lrc	string	The erbium value determined by ICP-MS LRC method.
er_icpms_ppm	int	The erbium parts per million value determined by ICP-MS method.
eu_icpms_lrc	string	The europium value determined by ICP-MS LRC method.
eu_icpms_ppm	int	The europium parts per million value determined by ICP-MS method.
gd_icpms_lrc	string	The gadolinium value determined by ICP-MS LRC method.
gd_icpms_ppm	int	The gadolinium parts per million value determined by ICP-MS method.
hf_icpms_lrc	string	The hafnium value determined by ICP-MS LRC method.
hf_icpms_ppm	int	The hafnium parts per million value determined by ICP-MS method.
ho_icpms_lrc	string	The holmium value determined by ICP-MS LRC method.
ho_icpms_ppm	int	The holmium parts per million value determined by ICP-MS method.
la_icpms_lrc	string	The lanthanum value determined by ICP-MS LRC method.
la_icpms_ppm	int	The lanthanum parts per million value determined by ICP-MS method.
lu_icpms_lrc	string	The lutetium value determined by ICP-MS LRC method.
lu_icpms_ppm	int	The lutetium parts per million value determined by ICP-MS method.
nb_icpms_lrc	string	The niobium value determined by ICP-MS LRC method.
nb_icpms_ppm	int	The niobium parts per million value determined by ICP-MS method.
nd_icpms_lrc	string	The neodymium value determined by ICP-MS LRC method.
nd_icpms_ppm	int	The neodymium parts per million value determined by ICP-MS method.
pr_icpms_lrc	string	The praseodymium value determined by ICP-MS LRC method.
pr_icpms_ppm	int	The praseodymium parts per million value determined by ICP-MS method.
rb_icpms_lrc	string	The rubidium value determined by ICP-MS LRC method.
rb_icpms_ppm	int	The rubidium parts per million value determined by ICP-MS method.
sc_icpms_lrc	string	The scandium value determined by ICP-MS LRC method.
sc_icpms_ppm	int	The scandium parts per million value determined by ICP-MS method.
sm_icpms_lrc	string	The samarium value determined by ICP-MS LRC method.
sm_icpms_ppm	int	The samarium parts per million value determined by ICP-MS method.
ta_icpms_lrc	string	The tantalum value determined by ICP-MS LRC method.
ta_icpms_ppm	int	The tantalum parts per million value determined by ICP-MS method.
tb_icpms_lrc	string	The terbium value determined by ICP-MS LRC method.
tb_icpms_ppm	int	The terbium parts per million value determined by ICP-MS method.
th_icpms_lrc	string	The thorium value determined by ICP-MS LRC method.
th_icpms_ppm	int	The thorium parts per million value determined by ICP-MS method.
ti_icpms_lrc	string	The titanium value determined by ICP-MS LRC method.
ti_icpms_ppm	int	The titanium parts per million value determined by ICP-MS method.
tm_icpms_lrc	string	The thulium value determined by ICP-MS LRC method.
tm_icpms_ppm	int	The thulium parts per million value determined by ICP-MS method.
u_icpms_lrc	string	The uranium value determined by ICP-MS LRC method.
u_icpms_ppm	int	The uranium parts per million value determined by ICP-MS method.
v_icpms_lrc	string	The vanadium value determined by ICP-MS LRC method.
v_icpms_ppm	int	The vanadium parts per million value determined by ICP-MS method.
y_icpms_lrc	string	The yttrium value determined by ICP-MS LRC method.
y_icpms_ppm	int	The yttrium parts per million value determined by ICP-MS method.
yb_icpms_lrc	string	The ytterbium value determined by ICP-MS LRC method.
yb_icpms_ppm	int	The ytterbium parts per million value determined by ICP-MS method.
zr_icpms_lrc	string	The zirconium value determined by ICP-MS LRC method.
zr_icpms_ppm	int	The zirconium parts per million value determined by ICP-MS method.
hyperlink	string	The hyperlink value.
co2_lrc	string	The carbon dioxide value determined by LRC method.
co2_percent	int	The carbon dioxide percentage.
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 value.

Data Explorer

No sample for this dataset

Additional Information


Last updated	April 22, 2024
Created	April 22, 2024
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	delta
Country	fi
Database	fi_geologian_tutkimuskeskus
Id	ab4568b4-3850-4fe3-86f0-507016e1d2be
Package id	11b5586a-275d-4a4f-bbd5-0fea166ca2cb
Position	1
Revision id	4baa8abe-64a4-4476-a2c9-9a4809f5ba7a
State	active
Table	rajapinnat_gtk_kalliopera_wfskalliogeokemia__kalliogeokemia__history