Geological Survey of Finland - Postglacial Land Uplift History
Click here for a data sample
This table contains the version history of the 'Geological Survey of Finland' (Geologian tutkimuskeskus, GTK) table named 'postglasiaalinen_maanvyory__postglasiaalinen_maanvyory'. It tracks the changes made to the rows in the base table by including additional columns '_start_date' and '_end_date'. The '_start_date' column represents the date when a particular row version was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it implies that the corresponding row is the most recent version. The table includes various columns such as 'gml_id', 'objectid', 'gtk_id', 'site_name', 'reference', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' to provide relevant descriptive information about the data. This historical record table may be utilized for data analytics purposes like tracking changes in the geological parameters over time, identifying trends, conducting spatial analysis, or understanding the geological landscape. The data source for this table is the website of the Geological Survey of Finland (GTK) from the country with the ISO country code 'FI'.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | A timestamp indicating the start date of the validity period for the row version. |
|---|
| _end_date | date | A timestamp indicating the end date of the validity period for the row version. |
|---|
| _row_number | long | A sequence number assigned to each row version in the table. |
|---|
| gml_id | string | An identifier for the row version in the GML format. |
|---|
| objectid | int | A unique identifier for the row version in the table. |
|---|
| gtk_id | string | An identifier for the row version in the GTK format. |
|---|
| site_name | string | The name of the site associated with the row version. |
|---|
| reference | string | A reference value associated with the row version. |
|---|
| shape_area | int | The area of the shape associated with the row version. |
|---|
| shape_len | int | The length of the shape associated with the row version. |
|---|
| geom_geojson | string | The geometry of the row version in the GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in the Geotext format. |
|---|
| geom_type | string | The type of geometry associated with the row version. |
|---|
| geom_centroid | string | The centroid of the geometry associated with the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry associated with the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry associated with the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
