Geological Survey of Finland - Lithological Classes

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

Tables

Geological Survey of Finland - Lithological CategoriesTSV
This table contains data from Geologian tutkimuskeskus website, which is sourced from Finland. The table consists of various columns including '_extract_date', '_row_number', 'gml_id', 'objectid', 'eon', 'eon_c3', 'era', 'era_c5', 'period', 'period_c7', 'chronostratigraphic_unit', 'chronostratigraphic_unit_c9', 'epoch', 'epoch_c11', 'supersuite', 'supersuite_c13', 'suite', 'suite_c15', 'lithodeme', 'lithodeme_c17', 'unit_criterion', 'unit_criterion_c19', 'original_name', 'rock_class', 'rock_class_c22', 'rock_name', 'rock_name_c24', 'shape_area', 'shape_len', 'nick_name', 'phase', 'phase_c29', 'supergroup', 'supergroup_c31', 'group_col', 'group_col_c33', 'formation', 'formation_c35', 'member', 'member_c37', 'complex', 'complex_c39', 'geom_geojson', 'geom_geotext', 'geom_type',...
Geological Survey of Finland - Rock Classification History (Finland)TSV
This table contains the version history of the 'Litologiset Luokat' table sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data in this table represents various geological information related to rock formations. Each row in this table represents a different version of a rock formation record, with additional columns '_start_date' and '_end_date' indicating the extraction dates of each version. The table includes columns such as 'gml_id', 'objectid', 'eon', 'era', 'period', 'chronostraticraphic_unit', 'epoch', 'supersuite', 'suite', 'lithodeme', 'unit_criterion', 'original_name', 'rock_class', 'rock_name', 'shape_area', 'shape_len', 'nick_name', 'phase', 'supergroup', 'group_col', 'formation', 'member', 'complex', 'geom_geojson',...

Column Descriptions

Geological Survey of Finland - Lithological Categories

Column	Type	Comment
_extract_date	date	The date at which the data was extracted.
_row_number	long	The number of the row in the table.
gml_id	string	The GML identifier of the object.
objectid	int	The unique identifier of the object.
eon	int	The eon in which the object exists.
eon_c3	string	The C3 classification of the eon.
era	int	The era in which the object exists.
era_c5	string	The C5 classification of the era.
period	int	The period in which the object exists.
period_c7	string	The C7 classification of the period.
chronostraticraphic_unit	int	The chronostraticraphic unit of the object.
chronostraticraphic_unit_c9	string	The C9 classification of the chronostraticraphic unit.
epoch	int	The epoch in which the object exists.
epoch_c11	string	The C11 classification of the epoch.
supersuite	int	The supersuite of the object.
supersuite_c13	string	The C13 classification of the supersuite.
suite	int	The suite of the object.
suite_c15	string	The C15 classification of the suite.
lithodeme	int	The lithodeme of the object.
lithodeme_c17	string	The C17 classification of the lithodeme.
unit_criterion	int	The unit criterion of the object.
unit_criterion_c19	string	The C19 classification of the unit criterion.
original_name	string	The original name of the object.
rock_class	int	The rock class of the object.
rock_class_c22	string	The C22 classification of the rock class.
rock_name	int	The rock name of the object.
rock_name_c24	string	The C24 classification of the rock name.
shape_area	int	The area (in square units) of the object's shape.
shape_len	int	The length (in units) of the object's shape.
nick_name	string	The nickname of the object.
phase	int	The phase of the object.
phase_c29	string	The C29 classification of the phase.
supergroup	int	The supergroup of the object.
supergroup_c31	string	The C31 classification of the supergroup.
group_col	int	The group column of the object.
group_col_c33	string	The C33 classification of the group column.
formation	int	The formation of the object.
formation_c35	string	The C35 classification of the formation.
member	int	The member of the object.
member_c37	string	The C37 classification of the member.
complex	int	The complex of the object.
complex_c39	string	The C39 classification of the complex.
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 of the object.
geom_centroid	string	The centroid of the object's geometry.
geom_center_x	double	The X-coordinate of the center of the object's geometry.
geom_center_y	double	The Y-coordinate of the center of the object's geometry.
geom	binary	The complete geometry information of the object.

Geological Survey of Finland - Rock Classification History (Finland)

Column	Type	Comment
_start_date	date	The starting date of the validity period for the row version.
_end_date	date	The ending date of the validity period for the row version.
_row_number	long	The number assigned to each row.
gml_id	string	The unique identifier of the row in GML format.
objectid	int	The unique identifier of the row.
eon	int	The geological eon name.
eon_c3	string	The code representing the geological eon.
era	int	The geological era name.
era_c5	string	The code representing the geological era.
period	int	The geological period name.
period_c7	string	The code representing the geological period.
chronostraticraphic_unit	int	The chronostratigraphic unit name.
chronostraticraphic_unit_c9	string	The code representing the chronostratigraphic unit.
epoch	int	The geological epoch name.
epoch_c11	string	The code representing the geological epoch.
supersuite	int	The name of the supersuite.
supersuite_c13	string	The code representing the supersuite.
suite	int	The name of the suite.
suite_c15	string	The code representing the suite.
lithodeme	int	The lithodeme name.
lithodeme_c17	string	The code representing the lithodeme.
unit_criterion	int	The unit criterion.
unit_criterion_c19	string	The code representing the unit criterion.
original_name	string	The original name of the row.
rock_class	int	The rock class.
rock_class_c22	string	The code representing the rock class.
rock_name	int	The rock name.
rock_name_c24	string	The code representing the rock name.
shape_area	int	The area of the shape.
shape_len	int	The length of the shape.
nick_name	string	The nickname of the row.
phase	int	The phase name.
phase_c29	string	The code representing the phase.
supergroup	int	The supergroup name.
supergroup_c31	string	The code representing the supergroup.
group_col	int	The group column.
group_col_c33	string	The code representing the group column.
formation	int	The formation name.
formation_c35	string	The code representing the formation.
member	int	The member name.
member_c37	string	The code representing the member.
complex	int	The complex name.
complex_c39	string	The code representing the complex.
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