Geological Survey of Finland - Rock Classification History (Finland)
Click here for a data sample
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', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain various attributes related to the geological characteristics of the rock formations. The data in this table can be utilized for data analytics purposes, such as trend analysis of geological changes over time, identification of rock formations based on their attributes, or spatial analysis using the geometric information. The table is sourced from Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
