Version History of Geologic Features in 'Geological Survey of Finland' Database for 'Rock Layers 200k' (200k Scale) in Finland
This table represents the version history of the 'Geological Survey of Finland' dataset named 'Geological map 1:200 000 - Line features'. It contains the historical information about the base table rows of the dataset. The table includes columns such as '_start_date' and '_end_date' that represent the extraction dates of each row. The 'rajapinnat_gtk_kalliopera_wfsjuoniparvet_200kjuoniparvet_200khistory' table originates from 'Geological Survey of Finland' website which is based in Finland (ISO country code: 'fi').
The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze changes over time in the geological features presented in the dataset. By examining the historical versions of the rows, researchers can investigate the evolution and dynamics of different geological elements. Additionally, the 'geom' column in this table provides geometric information that can be used to analyze the spatial distribution and patterns of the geological features. Data analytics techniques can also be applied to identify correlations or associations between specific geological attributes and extract valuable insights for geological research and exploration.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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 identifier for the row version. |
| objectid | int | The identifier of the row version. |
| eon | int | The eon data. |
| eon_c3 | string | The eon data (alternative column). |
| era | int | The era data. |
| era_c5 | string | The era data (alternative column). |
| period | int | The period data. |
| period_c7 | string | The period data (alternative column). |
| supersuite | int | The supersuite data. |
| supersuite_c9 | string | The supersuite data (alternative column). |
| suite | int | The suite data. |
| suite_c11 | string | The suite data (alternative column). |
| lithodeme | int | The lithodeme data. |
| lithodeme_c13 | string | The lithodeme data (alternative column). |
| original_rock_name | string | The original rock name. |
| rock_class | int | The rock class. |
| rock_class_c16 | string | The rock class (alternative column). |
| rock_name | int | The rock name. |
| rock_name_c18 | string | The rock name (alternative column). |
| basis | int | The basis data. |
| basis_c20 | string | The basis data (alternative column). |
| dyke_width | int | The width of the dyke. |
| dyke_width_c22 | string | The width of the dyke (alternative column). |
| shape_len | int | The length of the shape. |
| age | string | The age data. |
| remarks | string | Remarks about the data. |
| geom_geojson | string | The geometry data in GEOJSON format. |
| geom_geotext | string | The geometry data in GEOTEXT format. |
| geom_type | string | The type of the geometry data. |
| geom_centroid | string | The centroid of the geometry data. |
| geom_center_x | double | The x-coordinate of the center of the geometry data. |
| geom_center_y | double | The y-coordinate of the center of the geometry data. |
| geom | binary | The geometry data. |
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 | |
| Adapter | delta |
| Country | fi |
| Database | fi_geologian_tutkimuskeskus |
| Id | 4b55c2d2-f61d-4892-bd50-e929a59ccdf9 |
| Package id | 65175303-918f-45ff-8c27-e9f204d61d85 |
| Position | 1 |
| Revision id | 796eeb4c-77e9-4cae-b969-29c5cc1059ed |
| State | active |
| Table | rajapinnat_gtk_kalliopera_wfsjuoniparvet_200k__juoniparvet_200k__history |