Terrain Movements Dataset Collection
Tables
-
Geological Survey of Finland - Postglacial Land Uplift HistoryTSV
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',...
-
Postglacial Land Uplift Data from Geologian tutkimuskeskus in FinlandTSV
This table contains data related to post-glacial land uplift extracted from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data is sourced from the country with the ISO country code 'FI', which stands for Finland. The table contains various columns such as '_extract_date', '_row_number', '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'. These columns provide information related to the date of extraction, row number, unique identifiers, site names, references, shape area and length, geometrical information in JSON and geotext formats, geometry type, centroid coordinates, and full geometry. The data in this table can be...
Column Descriptions
Postglacial Land Uplift Data from Geologian tutkimuskeskus in Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the row was extracted. |
| _row_number | long | The unique number assigned to each row. |
| gml_id | string | The GML (Geography Markup Language) ID of the object. |
| objectid | int | The unique identifier for each object. |
| gtk_id | string | The ID assigned by GTK (Geological Survey of Finland) to the object. |
| site_name | string | The name of the site where the object is located. |
| reference | string | The reference information related to the object. |
| shape_area | int | The area of the object shape. |
| shape_len | int | The length of the object shape. |
| geom_geojson | string | The geometry of the object in GeoJSON format. |
| geom_geotext | string | The geometry of the object in geotext format. |
| geom_type | string | The type of the geometry. |
| geom_centroid | string | The centroid (center) of the object geometry. |
| geom_center_x | double | The x-coordinate of the center of the object geometry. |
| geom_center_y | double | The y-coordinate of the center of the object geometry. |
| geom | binary | The geometry of the object. |
Geological Survey of Finland - Postglacial Land Uplift History
| Column | Type | Comment |
|---|---|---|
| _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. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |