Version History of Soil Types in Finland (Geological Survey of Finland)
Click here for a data sample
This table contains the version history of the base table 'rajapinnat_gtk_maapera_wfsriutat__riutat'. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when the corresponding 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 means that the row is the most recent version. This table includes several other columns such as 'gml_id', 'objectid', 'luontotyyppi_koodi', 'luontotyyppi', 'aluenimi', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data is sourced from the web site of 'Geological Survey of Finland' (Geologian tutkimuskeskus), which is based in Finland (ISO country code: FI).
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The number of the row version. |
|---|
| gml_id | string | The GML identifier of the row version. |
|---|
| objectid | int | The identifier of the row version. |
|---|
| luontotyyppi_koodi | int | The code representing the nature type of the row version. |
|---|
| luontotyyppi | string | The nature type of the row version. |
|---|
| aluenimi | string | The name of the area related to the row version. |
|---|
| shape_area | int | The area of the shape representing the row version. |
|---|
| shape_len | int | The length of the shape representing 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 of the row version. |
|---|
| geom_centroid | string | The centroid of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry of the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
