Geological Surveys - Rock Formations Database (200k) in Finland
Click here for a data sample
This table contains geological data sourced from the website of Geologian tutkimuskeskus, which is a research center for geology in Finland (ISO country code: 'fi'). The table stores information about different rock formations, their names, classifications, ages, and other relevant attributes. The data can be utilized for various data analytics purposes such as analyzing the distribution of rock types, studying geological periods, identifying lithodemes, assessing dyke widths, and conducting spatial analysis using the provided geometries. The table also includes additional metadata fields like extraction date, row number, and unique identifiers for each record. The 'geom' column contains geometry information in GeoJSON format, which can be used for performing spatial operations and visualizations.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The row number of the data entry. |
|---|
| gml_id | string | The GML ID of the object. |
|---|
| objectid | int | The unique identifier of the object. |
|---|
| eon | int | The eon to which the data belongs. |
|---|
| eon_c3 | string | The C3 category of eon. |
|---|
| era | int | The era to which the data belongs. |
|---|
| era_c5 | string | The C5 category of era. |
|---|
| period | int | The period to which the data belongs. |
|---|
| period_c7 | string | The C7 category of period. |
|---|
| supersuite | int | The supersuite to which the data belongs. |
|---|
| supersuite_c9 | string | The C9 category of supersuite. |
|---|
| suite | int | The suite to which the data belongs. |
|---|
| suite_c11 | string | The C11 category of suite. |
|---|
| lithodeme | int | The lithodeme to which the data belongs. |
|---|
| lithodeme_c13 | string | The C13 category of lithodeme. |
|---|
| original_rock_name | string | The original name of the rock. |
|---|
| rock_class | int | The class of the rock. |
|---|
| rock_class_c16 | string | The C16 category of rock class. |
|---|
| rock_name | int | The name of the rock. |
|---|
| rock_name_c18 | string | The C18 category of rock name. |
|---|
| basis | int | The basis of the data. |
|---|
| basis_c20 | string | The C20 category of basis. |
|---|
| dyke_width | int | The width of the dyke. |
|---|
| dyke_width_c22 | string | The C22 category of dyke width. |
|---|
| shape_len | int | The length of the shape. |
|---|
| age | string | The age of the data. |
|---|
| remarks | string | Any remarks or comments. |
|---|
| geom_geojson | string | The geometric representation of the data in GeoJSON format. |
|---|
| geom_geotext | string | The geometric representation of the 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 of the data. |
|---|
