Historical versions of Base Table - Geologic-mapping_data - Finland
Click here for a data sample
This table contains the version history of the rows in the 'Geologian tutkimuskeskus Maaperä-WFSUURteet' table. The rows in this table represent different versions of the data extracted from the data source. Each row is identified by a unique '_row_number' and 'gml_id' value. The '_start_date' column indicates the date when the row 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 '_end_date' column is null, it means that the row represents the most recent version of the data. The table includes various columns such as 'objectid', 'pohjoiskoordinaatti', 'itakoordinaatti', 'jaatikon_tulosuunta', 'suhteellinen_ika', 'z', 'havaintovuosi', 'organisaatio', 'sijaintitarkkuusluokka', 'xy_paikannusmenetelma', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' providing additional information about the data. The 'geom' column stores the geometry information related to each row. This table offers valuable historical perspectives on the 'Geologian tutkimuskeskus Maaperä-WFSUURteet' data, allowing data analysts to track changes over time and perform various analytical tasks. The data source for this table is the website of the Geological Survey of Finland (Geologian tutkimuskeskus), which originates from Finland (FI).
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 row number of the version history entry. |
|---|
| gml_id | string | The GML identifier for the row. |
|---|
| objectid | int | The identifier for the object. |
|---|
| pohjoiskoordinaatti | int | The northern coordinate value. |
|---|
| itakoordinaatti | int | The eastern coordinate value. |
|---|
| jaatikon_tulosuunta | int | The result direction of the box. |
|---|
| suhteellinen_ika | string | The relative age. |
|---|
| z | int | The z-axis value. |
|---|
| havaintovuosi | int | The year of observation. |
|---|
| organisaatio | string | The organization name. |
|---|
| sijaintitarkkuusluokka | string | The location accuracy class. |
|---|
| xy_paikannusmenetelma | string | The XY positioning method. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the geometry center. |
|---|
| geom_center_y | double | The y-coordinate of the geometry center. |
|---|
| geom | binary | The geometry. |
|---|
