Geological Survey of Finland Soil Observation Forms Collection

The dataset collection comprises one or more dataset tables sourced from the website of Geologian tutkimuskeskus in Finland.

Tables

Geological Survey of Finland - Soil Observation FormTSV
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...
Version History of Havaintolomake Table (Geological Survey of Finland - Finnish Country)TSV
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.

Column Descriptions

Geological Survey of Finland - Soil Observation Form

Column	Type	Comment
_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.

Version History of Havaintolomake Table (Geological Survey of Finland - Finnish Country)

Column	Type	Comment
_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.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024