History of Soil Layers and Formations in Finland - rajapinnat_gtk_maapera_wfsmaapera_1m_kerrostumat_ja_muodostumat__maapera_1m_kerrostumat_ja_muodostumat
Click here for a data sample
This table contains the version history of the rows extracted from the Geologian tutkimuskeskus website in the country Finland (ISO country code 'fi'). It is a historical record of the 'rajapinnat_gtk_maapera_wfsmaapera_1m_kerrostumat_ja_muodostumat__maapera_1m_kerrostumat_ja_muodostumat' base table. The rows in this table represent different versions of the data, with each row having a start date and an end date indicating when it was extracted from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table contains various columns such as '_row_number', 'gml_id', 'objectid', 'tunnus', 'maalaji', 'shape_length', 'shape_area', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' representing different attributes of the data. This table provides valuable information for data analytics purposes, allowing for analysis and comparison of different versions of the data over time.
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 unique identifier for each row version. |
|---|
| gml_id | string | The GML ID of the row. |
|---|
| objectid | int | The object ID of the row. |
|---|
| tunnus | string | The tunnus of the row. |
|---|
| maalaji | string | The maalaji of the row. |
|---|
| shape_length | int | The length of the shape in the row. |
|---|
| shape_area | int | The area of the shape in the row. |
|---|
| geom_geojson | string | The GeoJSON representation of the geometry in the row. |
|---|
| geom_geotext | string | The geotext representation of the geometry in the row. |
|---|
| geom_type | string | The type of the geometry in the row. |
|---|
| geom_centroid | string | The centroid of the geometry in the row. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry in the row. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry in the row. |
|---|
| geom | binary | The geometry in the row. |
|---|
