Geological Survey of Finland - Lithological Units

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

Tables

Geological Survey of Finland - Lithological Units HistoryTSV
This table contains the version history of the rows from the base table 'rajapinnat_gtk_kalliopera_wfslitologiset_yksikot__litologiset_yksikot'. It includes two additional columns compared to the base table: '_start_date' and '_end_date', which represent the extraction dates of the rows from the data source. The data in this table originates from the website of the Geological Survey of Finland (Geologian tutkimuskeskus) and is sourced from the country with the ISO country code 'fi'.
Geological Units - Lithological UnitsTSV
This table contains geological data from the Geologian tutkimuskeskus website in Finland. The table consists of various columns such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'eon', 'eon_c3', 'era', 'era_c5', 'period', 'period_c7', 'chronostraticraphic_unit', 'chronostraticraphic_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', 'geom_centroid',...

Column Descriptions

Geological Units - Lithological Units

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The number of the row
gml_id	string	The unique identifier in GML format
objectid	int	The unique identifier of the object
eon	int	The geological eon
eon_c3	string	The geological eon category C3
era	int	The geological era
era_c5	string	The geological era category C5
period	int	The geological period
period_c7	string	The geological period category C7
chronostraticraphic_unit	int	The chronostratigraphic unit
chronostraticraphic_unit_c9	string	The chronostratigraphic unit category C9
epoch	int	The geological epoch
epoch_c11	string	The geological epoch category C11
supersuite	int	The supersuite
supersuite_c13	string	The supersuite category C13
suite	int	The suite
suite_c15	string	The suite category C15
lithodeme	int	The lithodeme
lithodeme_c17	string	The lithodeme category C17
unit_criterion	int	The unit criterion
unit_criterion_c19	string	The unit criterion category C19
original_name	string	The original name
rock_class	int	The rock class
rock_class_c22	string	The rock class category C22
rock_name	int	The rock name
rock_name_c24	string	The rock name category C24
shape_area	int	The area of the shape
shape_len	int	The length of the shape
nick_name	string	The nickname
phase	int	The geological phase
phase_c29	string	The geological phase category C29
supergroup	int	The supergroup
supergroup_c31	string	The supergroup category C31
group_col	int	The group column
group_col_c33	string	The group column category C33
formation	int	The formation
formation_c35	string	The formation category C35
member	int	The member
member_c37	string	The member category C37
complex	int	The complex
complex_c39	string	The complex category C39
geom_geojson	string	The geometry data in GeoJSON format
geom_geotext	string	The geometry data in Geotext format
geom_type	string	The type of the 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 data

Geological Survey of Finland - Lithological Units 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	An identifier for the row version.
gml_id	string	The GML identifier of the row version.
objectid	int	The identifier of the row version.
eon	int	The eon value of the row version.
eon_c3	string	The eon_c3 value of the row version.
era	int	The era value of the row version.
era_c5	string	The era_c5 value of the row version.
period	int	The period value of the row version.
period_c7	string	The period_c7 value of the row version.
chronostraticraphic_unit	int	The chronostraticraphic unit of the row version.
chronostraticraphic_unit_c9	string	The chronostraticraphic_unit_c9 value of the row version.
epoch	int	The epoch value of the row version.
epoch_c11	string	The epoch_c11 value of the row version.
supersuite	int	The supersuite value of the row version.
supersuite_c13	string	The supersuite_c13 value of the row version.
suite	int	The suite value of the row version.
suite_c15	string	The suite_c15 value of the row version.
lithodeme	int	The lithodeme value of the row version.
lithodeme_c17	string	The lithodeme_c17 value of the row version.
unit_criterion	int	The unit criterion of the row version.
unit_criterion_c19	string	The unit_criterion_c19 value of the row version.
original_name	string	The original name of the row version.
rock_class	int	The rock class of the row version.
rock_class_c22	string	The rock_class_c22 value of the row version.
rock_name	int	The rock name of the row version.
rock_name_c24	string	The rock_name_c24 value of the row version.
shape_area	int	The shape area of the row version.
shape_len	int	The shape length of the row version.
nick_name	string	The nick name of the row version.
phase	int	The phase of the row version.
phase_c29	string	The phase_c29 value of the row version.
supergroup	int	The supergroup of the row version.
supergroup_c31	string	The supergroup_c31 value of the row version.
group_col	int	The group column of the row version.
group_col_c33	string	The group_col_c33 value of the row version.
formation	int	The formation of the row version.
formation_c35	string	The formation_c35 value of the row version.
member	int	The member of the row version.
member_c37	string	The member_c37 value of the row version.
complex	int	The complex of the row version.
complex_c39	string	The complex_c39 value of the row version.
geom_geojson	string	The geometry in GeoJSON format of the row version.
geom_geotext	string	The geometry in Geotext format of the row version.
geom_type	string	The type of the geometry of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center of the geometry of the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024