Version History of Lithostratigraphic Units in GTK Bedrock Dataset

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

Click here for a data sample

This table, sourced from the Geoscience Research Center website of Finland, contains the version history of the 'Kalliopera WFSRyhma Muodostuma Litostratigrafiset Yksikot - Ryhma Muodostuma Litostratigrafiset Yksikot' base table. It tracks the changes made to the base table rows over time, providing information on when each row was extracted from the data source ('_start_date') and when a new version of the row was extracted ('_end_date'). The table includes various columns capturing details such as row number, GML ID, object ID, geological time periods (eon, era, period, chronostratigraphic unit, epoch), rock classifications (supersuite, suite, lithodeme, rock class, rock name), shape metrics (area, length), nicknames, geological phases, supergroups, group columns, formations, members, complexes, and various geometry-related attributes. The table can be utilized in data analytics to study the evolution of geological features and their characteristics over time, analyze rock classifications and their distribution, examine spatial patterns using geometry-related attributes, and perform temporal analysis of geological phases and their relationships within the dataset.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe row number of the version in the table's version history.
gml_idstringThe GML ID of the row version.
objectidintThe object ID of the row version.
eonintThe eon value of the row version.
eon_c3stringThe value indicating the eon in C3.
eraintThe era value of the row version.
era_c5stringThe value indicating the era in C5.
periodintThe period value of the row version.
period_c7stringThe value indicating the period in C7.
chronostraticraphic_unitintThe chronostratigraphic unit of the row version.
chronostraticraphic_unit_c9stringThe value indicating the chronostratigraphic unit in C9.
epochintThe epoch value of the row version.
epoch_c11stringThe value indicating the epoch in C11.
supersuiteintThe supersuite value of the row version.
supersuite_c13stringThe value indicating the supersuite in C13.
suiteintThe suite value of the row version.
suite_c15stringThe value indicating the suite in C15.
lithodemeintThe lithodeme value of the row version.
lithodeme_c17stringThe value indicating the lithodeme in C17.
unit_criterionintThe unit criterion value of the row version.
unit_criterion_c19stringThe value indicating the unit criterion in C19.
original_namestringThe original name value of the row version.
rock_classintThe rock class value of the row version.
rock_class_c22stringThe value indicating the rock class in C22.
rock_nameintThe rock name value of the row version.
rock_name_c24stringThe value indicating the rock name in C24.
shape_areaintThe area of the shape of the row version.
shape_lenintThe length of the shape of the row version.
nick_namestringThe nick name value of the row version.
phaseintThe phase value of the row version.
phase_c29stringThe value indicating the phase in C29.
supergroupintThe supergroup value of the row version.
supergroup_c31stringThe value indicating the supergroup in C31.
group_colintThe group column value of the row version.
group_col_c33stringThe value indicating the group column in C33.
formationintThe formation value of the row version.
formation_c35stringThe value indicating the formation in C35.
memberintThe member value of the row version.
member_c37stringThe value indicating the member in C37.
complexintThe complex value of the row version.
complex_c39stringThe value indicating the complex in C39.
geom_geojsonstringThe geojson geometry of the row version.
geom_geotextstringThe geotext geometry of the row version.
geom_typestringThe type of the geometry of the row version.
geom_centroidstringThe centroid of the geometry of the row version.
geom_center_xdoubleThe x-coordinate of the center of the geometry of the row version.
geom_center_ydoubleThe y-coordinate of the center of the geometry of the row version.
geombinaryThe geometry of the row version.

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
Adapterdelta
Countryfi
Databasefi_geologian_tutkimuskeskus
Id03379f02-0998-49c9-b65f-fcf10fed223b
Package idd8a2d774-bce5-4dd3-8731-e4a640ade449
Position1
Revision idcc3b1cfa-37d8-4b46-b52f-b4bb22b6ba95
Stateactive
Tablerajapinnat_gtk_kalliopera_wfsryhma_muodostuma_litostratigrafiset_yksikot__ryhma_muodostuma_litostratigrafiset_yksikot__history