Version History of Havaintolomake Table (Geological Survey of Finland - Finnish Country)
Click here for a data sample
This table contains the version history of the rows in 'Geologian tutkimuskeskus' web site's 'maapera_wfshavaintolomake__havaintolomake' table. It includes information about the start and end dates when each row was extracted from the data source. The table is sourced from the country Finland (ISO country code 'fi'). The data in this table can be utilized for various data analytics purposes. For example, it can be used to track changes over time in the 'havaintolomake' data, analyze patterns in the geographical coordinates, identify relationships between 'havaintolomaketunnus' and other attributes, and visualize the 'geom' data using different types of geometry.
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 assigned to each row version. |
|---|
| gml_id | string | The GML ID for the row version. |
|---|
| objectid | int | The unique identifier for the row version. |
|---|
| pohjoiskoordinaatti | int | The northern coordinate value for the row version. |
|---|
| itakoordinaatti | int | The eastern coordinate value for the row version. |
|---|
| havaintotunnus | string | The observation identifier for the row version. |
|---|
| havaintolomaketunnus | int | The observation form identifier for the row version. |
|---|
| havaintolomake_linkki | string | The link to the observation form for the row version. |
|---|
| huomautukset | string | Any additional remarks or comments for 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 geometry for the row version. |
|---|
| geom_centroid | string | The centroid of the geometry for the row version. |
|---|
| geom_center_x | double | The X coordinate value of the centroid of the geometry for the row version. |
|---|
| geom_center_y | double | The Y coordinate value of the centroid of the geometry for the row version. |
|---|
| geom | binary | The geometry for the row version. |
|---|
