Version History of Poimurakenteet 200k Data from Geological Survey of Finland (GTK) in Finland
Click here for a data sample
This table contains the version history of the rows in the base table 'poimurakenteet_200k'. It is sourced from the website of the 'Geological Survey of Finland' from the country 'Finland' (ISO country code 'fi'). The table has additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The data in this table can be utilized in data analytics to analyze the changes in the fold types, fold systems, basis, and geometry of the rock structures over time. It can provide insights into the evolution of rock formations and their characteristics in different regions of Finland.
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 entry. |
|---|
| gml_id | string | The identifier of the row version in GML format. |
|---|
| objectid | int | The unique identifier of the row version object. |
|---|
| fold_type | int | The type of folding observed. |
|---|
| fold_type_c3 | string | The categorization of folding type using C3 classification. |
|---|
| fold_system | int | The system or pattern of folding observed. |
|---|
| fold_system_c5 | string | The categorization of folding system using C5 classification. |
|---|
| fold | int | The fold characteristics for the row version. |
|---|
| fold_c7 | string | The categorization of fold characteristics using C7 classification. |
|---|
| basis | int | The basis or reference for the row version. |
|---|
| basis_c9 | string | The categorization of basis using C9 classification. |
|---|
| shape_len | int | The length of the shape or geometry of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in geotext format. |
|---|
| geom_type | string | The type of geometry for the row version. |
|---|
| geom_centroid | string | The centroid of the geometry for the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The complete geometry of the row version. |
|---|
