Geological Survey of Finland - Soil Observation Form

To download the data set, please sign up or log in

Click here for a data sample

This table contains data sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data originates from Finland (ISO country code: FI). The table includes various fields such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'pohjoiskoordinaatti', 'itakoordinaatti', 'havaintotunnus', 'havaintolomaketunnus', 'havaintolomake_linkki', 'huomautukset', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These fields contain information that can be utilized in data analytics. For example, the 'pohjoiskoordinaatti' and 'itakoordinaatti' fields provide latitude and longitude coordinates respectively, which can be used to analyze the spatial distribution of the observations. The 'havaintotunnus' field represents the observation identifier, which can be used to track and analyze specific observations. The 'huomautukset' field contains comments or remarks associated with the observations, providing additional context or information for analysis. The 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' fields contain geometric data that can be used for spatial analysis, such as determining the shape or centroid of an observation. The 'havaintolomake_linkki' field provides a link to the observation form, allowing easy access to the original data source. Overall, this table provides valuable data for conducting various data analytics tasks related to geological observations in Finland.

Field Descriptions

Name Data type Description
_extract_datedateThe date when the record was extracted.
_row_numberlongThe row number of the record in the table.
gml_idstringThe unique identifier of the GML object.
objectidintThe unique identifier of the object.
pohjoiskoordinaattiintThe latitude coordinate of the observation.
itakoordinaattiintThe longitude coordinate of the observation.
havaintotunnusstringThe unique identifier of the observation.
havaintolomaketunnusintThe unique identifier of the observation form.
havaintolomake_linkkistringThe link to the observation form.
huomautuksetstringAny additional remarks or comments.
geom_geojsonstringThe geometry in GeoJSON format.
geom_geotextstringThe geometry in WKT format.
geom_typestringThe type of the geometry.
geom_centroidstringThe centroid of the geometry.
geom_center_xdoubleThe x-coordinate of the center of the geometry.
geom_center_ydoubleThe y-coordinate of the center of the geometry.
geombinaryThe geometry of the object.

No sample for this dataset

Additional Information

Last updated April 22, 2024
Created April 22, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_geologian_tutkimuskeskus
Id20e8bd93-65a8-4389-bf08-afdf21a3f4b5
Package idec013abf-d285-4e77-9682-d3b711ddd1ad
Revision idcf714786-f7be-453e-a9a8-22e9f798074c
Stateactive
Tablerajapinnat_gtk_maapera_wfshavaintolomake__havaintolomake