Geological Survey of Finland Soil Characteristics dataset collection

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

Tables

Geological Survey of Finland - Soil WFS FeaturesTSV
This table contains data from the 'Geological Survey of Finland' (Geologian tutkimuskeskus) website. It includes information about various geological features in Finland. The table consists of multiple columns, including '_extract_date' which represents the date the data was extracted, '_row_number' which indicates the row number of each record, 'gml_id' representing the unique identifier for each feature, 'objectid' which serves as an additional identifier, 'pohjoiskoordinaatti' and 'itakoordinaatti' which provide the latitude and longitude coordinates respectively, 'jaatikon_tulosuunta' indicating the direction of ice movement, 'suhteellinen_ika' representing the relative age of the feature, 'z' which represents the elevation, 'havaintovuosi' indicating the year of observation,...
Historical versions of Base Table - Geologic-mapping_data - FinlandTSV
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',...

Column Descriptions

Geological Survey of Finland - Soil WFS Features

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique row number for each record.
gml_id	string	The GML identifier for the record.
objectid	int	The unique identifier for each object.
pohjoiskoordinaatti	int	The value of the northern coordinate.
itakoordinaatti	int	The value of the eastern coordinate.
jaatikon_tulosuunta	int	The result direction of the box.
suhteellinen_ika	string	The relative age of the record.
z	int	The z-value or elevation of the record.
havaintovuosi	int	The year when the observation was made.
organisaatio	string	The organization associated with the record.
sijaintitarkkuusluokka	string	The accuracy class of the location.
xy_paikannusmenetelma	string	The method used for XY positioning.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in well-known text (WKT) format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The spatial geometry of the record.

Historical versions of Base Table - Geologic-mapping_data - Finland

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 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.

Additional Info

Last Updated	June 6, 2024
Created	April 22, 2024