Geological Survey of Finland - Rock Formation Lithostratigraphic Units
Tables
-
Lithostratigraphic Units in Geological Survey of Finland - Rock Formations, Groups, and LithodemesTSV
This table contains data from the 'Geological Survey of Finland' website. It provides information about various lithostratigraphic units. The table has 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',...
-
Version History of Lithostratigraphic Units in GTK Bedrock DatasetTSV
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,...
Column Descriptions
Lithostratigraphic Units in Geological Survey of Finland - Rock Formations, Groups, and Lithodemes
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the data. |
| gml_id | string | The ID of the gml entry. |
| objectid | int | The unique identifier of the object. |
| eon | int | The eon value. |
| eon_c3 | string | The C3 eon value. |
| era | int | The era value. |
| era_c5 | string | The C5 era value. |
| period | int | The period value. |
| period_c7 | string | The C7 period value. |
| chronostraticraphic_unit | int | The chronostraticraphic unit value. |
| chronostraticraphic_unit_c9 | string | The C9 chronostraticraphic unit value. |
| epoch | int | The epoch value. |
| epoch_c11 | string | The C11 epoch value. |
| supersuite | int | The supersuite value. |
| supersuite_c13 | string | The C13 supersuite value. |
| suite | int | The suite value. |
| suite_c15 | string | The C15 suite value. |
| lithodeme | int | The lithodeme value. |
| lithodeme_c17 | string | The C17 lithodeme value. |
| unit_criterion | int | The unit criterion value. |
| unit_criterion_c19 | string | The C19 unit criterion value. |
| original_name | string | The original name value. |
| rock_class | int | The rock class value. |
| rock_class_c22 | string | The C22 rock class value. |
| rock_name | int | The rock name value. |
| rock_name_c24 | string | The C24 rock name value. |
| shape_area | int | The area of the shape. |
| shape_len | int | The length of the shape. |
| nick_name | string | The nickname of the object. |
| phase | int | The phase value. |
| phase_c29 | string | The C29 phase value. |
| supergroup | int | The supergroup value. |
| supergroup_c31 | string | The C31 supergroup value. |
| group_col | int | The group column value. |
| group_col_c33 | string | The C33 group column value. |
| formation | int | The formation value. |
| formation_c35 | string | The C35 formation value. |
| member | int | The member value. |
| member_c37 | string | The C37 member value. |
| complex | int | The complex value. |
| complex_c39 | string | The C39 complex value. |
| geom_geojson | string | The geometry in GeoJSON format. |
| geom_geotext | string | The geometry in Geotext format. |
| geom_type | string | The type of the geometry. |
| geom_centroid | string | The centroid coordinates 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 of the object. |
Version History of Lithostratigraphic Units in GTK Bedrock Dataset
| 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 | The row number of the version in the table's version history. |
| gml_id | string | The GML ID of the row version. |
| objectid | int | The object ID of the row version. |
| eon | int | The eon value of the row version. |
| eon_c3 | string | The value indicating the eon in C3. |
| era | int | The era value of the row version. |
| era_c5 | string | The value indicating the era in C5. |
| period | int | The period value of the row version. |
| period_c7 | string | The value indicating the period in C7. |
| chronostraticraphic_unit | int | The chronostratigraphic unit of the row version. |
| chronostraticraphic_unit_c9 | string | The value indicating the chronostratigraphic unit in C9. |
| epoch | int | The epoch value of the row version. |
| epoch_c11 | string | The value indicating the epoch in C11. |
| supersuite | int | The supersuite value of the row version. |
| supersuite_c13 | string | The value indicating the supersuite in C13. |
| suite | int | The suite value of the row version. |
| suite_c15 | string | The value indicating the suite in C15. |
| lithodeme | int | The lithodeme value of the row version. |
| lithodeme_c17 | string | The value indicating the lithodeme in C17. |
| unit_criterion | int | The unit criterion value of the row version. |
| unit_criterion_c19 | string | The value indicating the unit criterion in C19. |
| original_name | string | The original name value of the row version. |
| rock_class | int | The rock class value of the row version. |
| rock_class_c22 | string | The value indicating the rock class in C22. |
| rock_name | int | The rock name value of the row version. |
| rock_name_c24 | string | The value indicating the rock name in C24. |
| shape_area | int | The area of the shape of the row version. |
| shape_len | int | The length of the shape of the row version. |
| nick_name | string | The nick name value of the row version. |
| phase | int | The phase value of the row version. |
| phase_c29 | string | The value indicating the phase in C29. |
| supergroup | int | The supergroup value of the row version. |
| supergroup_c31 | string | The value indicating the supergroup in C31. |
| group_col | int | The group column value of the row version. |
| group_col_c33 | string | The value indicating the group column in C33. |
| formation | int | The formation value of the row version. |
| formation_c35 | string | The value indicating the formation in C35. |
| member | int | The member value of the row version. |
| member_c37 | string | The value indicating the member in C37. |
| complex | int | The complex value of the row version. |
| complex_c39 | string | The value indicating the complex in C39. |
| geom_geojson | string | The geojson geometry of the row version. |
| geom_geotext | string | The geotext geometry 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 |