Geological Survey of Finland (GTK) Rock Layers WFS Complex Suite Lithodemic Units

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

Tables

Geological Survey of Finland - Complex Suite Lithodeme UnitsTSV
This table contains data from the 'Geological Survey of Finland' located in Finland. It consists of various geological attributes such as extraction date, row number, GML ID, object ID, geological eras, periods, chronostraticraphic units, epochs, lithodemes, rock classes and names, shape area, shape length, nick name, phases, supergroups, groups, formations, members, complexes, and various geometric attributes. The data in this table can be utilized in data analytics to analyze geological formations, study the distribution of lithodemes, classify different rock types, identify the shape and size of geological features, analyze spatial characteristics, and understand the relationships between different geological attributes.
Version History of Geologic Units in FinlandTSV
This table contains the version history of the rows in the 'Geologian tutkimuskeskus' database table 'rajapinnat_gtk_kalliopera_wfskompleksi_sviitti_litodeemiset_yksikot__kompleksi_sviitti_litodeemiset_yksikot'. The table tracks changes in the base table rows over time and includes two additional columns: '_start_date' and '_end_date'. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the corresponding row is the most recent version. The table contains various columns such as 'gml_id', 'objectid', 'eon', 'era', 'period', 'chronostraticraphic_unit', 'epoch', 'supersuite', 'suite', 'lithodeme',...

Column Descriptions

Geological Survey of Finland - Complex Suite Lithodeme Units

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The number assigned to each row in the table
gml_id	string	The ID associated with the GML
objectid	int	The unique identifier for each object
eon	int	The geological epoch or aeon
eon_c3	string	Column C3 associated with the geological epoch or aeon
era	int	The geological era
era_c5	string	Column C5 associated with the geological era
period	int	The geological period
period_c7	string	Column C7 associated with the geological period
chronostraticraphic_unit	int	The chronostratigraphic unit
chronostraticraphic_unit_c9	string	Column C9 associated with the chronostratigraphic unit
epoch	int	The geological epoch
epoch_c11	string	Column C11 associated with the geological epoch
supersuite	int	The supersuite
supersuite_c13	string	Column C13 associated with the supersuite
suite	int	The suite
suite_c15	string	Column C15 associated with the suite
lithodeme	int	The lithodeme
lithodeme_c17	string	Column C17 associated with the lithodeme
unit_criterion	int	The unit criterion
unit_criterion_c19	string	Column C19 associated with the unit criterion
original_name	string	The original name
rock_class	int	The rock class
rock_class_c22	string	Column C22 associated with the rock class
rock_name	int	The rock name
rock_name_c24	string	Column C24 associated with the rock name
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	Column C29 associated with the geological phase
supergroup	int	The supergroup
supergroup_c31	string	Column C31 associated with the supergroup
group_col	int	The group column
group_col_c33	string	Column C33 associated with the group column
formation	int	The geological formation
formation_c35	string	Column C35 associated with the geological formation
member	int	The geological member
member_c37	string	Column C37 associated with the geological member
complex	int	The geological complex
complex_c39	string	Column C39 associated with the geological complex
geom_geojson	string	The geometric representation in GeoJSON format
geom_geotext	string	The geometric representation 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

Version History of Geologic Units in Finland

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 history.
gml_id	string	The GML ID associated with the row.
objectid	int	The ID of the object.
eon	int	The eon value associated with the row.
eon_c3	string	The eon c3 value associated with the row.
era	int	The era value associated with the row.
era_c5	string	The era c5 value associated with the row.
period	int	The period value associated with the row.
period_c7	string	The period c7 value associated with the row.
chronostraticraphic_unit	int	The chronostraticraphic unit associated with the row.
chronostraticraphic_unit_c9	string	The chronostraticraphic unit c9 value associated with the row.
epoch	int	The epoch value associated with the row.
epoch_c11	string	The epoch c11 value associated with the row.
supersuite	int	The supersuite value associated with the row.
supersuite_c13	string	The supersuite c13 value associated with the row.
suite	int	The suite value associated with the row.
suite_c15	string	The suite c15 value associated with the row.
lithodeme	int	The lithodeme value associated with the row.
lithodeme_c17	string	The lithodeme c17 value associated with the row.
unit_criterion	int	The unit criterion associated with the row.
unit_criterion_c19	string	The unit criterion c19 value associated with the row.
original_name	string	The original name associated with the row.
rock_class	int	The rock class associated with the row.
rock_class_c22	string	The rock class c22 value associated with the row.
rock_name	int	The rock name associated with the row.
rock_name_c24	string	The rock name c24 value associated with the row.
shape_area	int	The area of the shape associated with the row.
shape_len	int	The length of the shape associated with the row.
nick_name	string	The nickname associated with the row.
phase	int	The phase associated with the row.
phase_c29	string	The phase c29 value associated with the row.
supergroup	int	The supergroup associated with the row.
supergroup_c31	string	The supergroup c31 value associated with the row.
group_col	int	The group column associated with the row.
group_col_c33	string	The group column c33 value associated with the row.
formation	int	The formation associated with the row.
formation_c35	string	The formation c35 value associated with the row.
member	int	The member associated with the row.
member_c37	string	The member c37 value associated with the row.
complex	int	The complex associated with the row.
complex_c39	string	The complex c39 value associated with the row.
geom_geojson	string	The geometry in GeoJSON format associated with the row.
geom_geotext	string	The geometry in GEOTEXT format associated with the row.
geom_type	string	The type of geometry associated with the row.
geom_centroid	string	The centroid of the geometry associated with the row.
geom_center_x	double	The X-coordinate of the center of the geometry associated with the row.
geom_center_y	double	The Y-coordinate of the center of the geometry associated with the row.
geom	binary	The geometry associated with the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024