Geological Survey of Finland - Soil Observation Form
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_date | date | The date when the record was extracted. |
_row_number | long | The row number of the record in the table. |
gml_id | string | The unique identifier of the GML object. |
objectid | int | The unique identifier of the object. |
pohjoiskoordinaatti | int | The latitude coordinate of the observation. |
itakoordinaatti | int | The longitude coordinate of the observation. |
havaintotunnus | string | The unique identifier of the observation. |
havaintolomaketunnus | int | The unique identifier of the observation form. |
havaintolomake_linkki | string | The link to the observation form. |
huomautukset | string | Any additional remarks or comments. |
geom_geojson | string | The geometry in GeoJSON format. |
geom_geotext | string | The geometry in WKT format. |
geom_type | string | The type of the geometry. |
geom_centroid | string | The centroid of the geometry. |
geom_center_x | double | The x-coordinate of the center of the geometry. |
geom_center_y | double | The y-coordinate of the center of the geometry. |
geom | binary | The geometry of the object. |