Version History of Surface and Subsurface Soil Types (200K Scale) from Geological Survey of Finland (GTK) in Finland
Click here for a data sample
This table contains the version history of the rows from the 'Geologian tutkimuskeskus' data source table 'rajapinnat_gtk_maapera_wfsmaapera_200k_maalajit__maapera_200k_maalajit'. The rows in this table include the additional columns '_start_date' and '_end_date', which respectively indicate the extraction date of the row and the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it means that the row is the most recent version. The table provides information related to various attributes such as 'gml_id', 'objectid', 'pintamaalaji_koodi', 'pintamaalaji', 'pohjamaalaji_koodi', 'pohjamaalaji', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be utilized in various data analytics scenarios, such as analyzing the surface and subsurface soil types, calculating the shape area and length, geospatial analytics using the 'geom' field, and identifying the centroid coordinates of features. This data source originates from Finland (ISO country code 'fi') and is available on the website of 'Geological Survey 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 sequential number assigned to the row version. |
|---|
| gml_id | string | The ID associated with the row version in GML format. |
|---|
| objectid | int | The unique identifier of the row version. |
|---|
| pintamaalaji_koodi | int | The code representing the surface material of the row version. |
|---|
| pintamaalaji | string | The surface material of the row version. |
|---|
| pohjamaalaji_koodi | int | The code representing the substrate material of the row version. |
|---|
| pohjamaalaji | string | The substrate material of the row version. |
|---|
| shape_area | int | The area of the geometry associated with the row version. |
|---|
| shape_len | int | The length of the geometry associated with 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 the geometry associated with the row version. |
|---|
| geom_centroid | string | The centroid coordinates 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 complete geometry information associated with the row version. |
|---|
