Geological Survey of Finland - Soil Types

The dataset collection consists of one or more tables sourced from the web site of Geologian tutkimuskeskus (Geological Survey of Finland) in Finland.

Tables

Soil Types in 200k Soil Survey Map - FinlandTSV
This table contains data about soil types from the country of Finland. The data is sourced from the website of Geological Survey of Finland. The table provides information about various attributes related to soil types such as surface soil type, subsoil type, object identification, shape area and length, and geometry details. The data in this table can be utilized in data analytics to perform spatial analysis, understand soil composition across different regions, identify areas suitable for agriculture based on soil types, and study the distribution of different soil types in Finland.
Version History of Surface and Subsurface Soil Types (200K Scale) from Geological Survey of Finland (GTK) in FinlandTSV
This table contains the version history of the rows from the 'Geologian tutkimuskeskus' data source table 'rajapinnat_gtk_maapera_wfsmaapera_200k_maalajit__maapera_200k_maalajit'. The rows in this table include the additional columns '_start_date' and '_end_date', which respectively indicate the extraction date of the row and the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it means that the row is the most recent version. The table provides information related to various attributes such as 'gml_id', 'objectid', 'pintamaalaji_koodi', 'pintamaalaji', 'pohjamaalaji_koodi', 'pohjamaalaji', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be...

Column Descriptions

Soil Types in 200k Soil Survey Map - Finland

Column	Type	Comment
_extract_date	date	The date of extraction for the data.
_row_number	long	The row number of the data in the table.
gml_id	string	The GML ID of the object.
objectid	int	The unique identifier of the object.
pintamaalaji_koodi	int	The code representing the surface material type.
pintamaalaji	string	The description of the surface material type.
pohjamaalaji_koodi	int	The code representing the substrate material type.
pohjamaalaji	string	The description of the substrate material type.
shape_area	int	The area of the shape in square units.
shape_len	int	The length of the shape.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in geotext format.
geom_type	string	The type of geometry for the object.
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 Surface and Subsurface Soil Types (200K Scale) from Geological Survey of Finland (GTK) in 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 sequential number assigned to the row version.
gml_id	string	The ID associated with the row version in GML format.
objectid	int	The unique identifier of the row version.
pintamaalaji_koodi	int	The code representing the surface material of the row version.
pintamaalaji	string	The surface material of the row version.
pohjamaalaji_koodi	int	The code representing the substrate material of the row version.
pohjamaalaji	string	The substrate material of the row version.
shape_area	int	The area of the geometry associated with the row version.
shape_len	int	The length of the geometry associated with 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 the geometry associated with the row version.
geom_centroid	string	The centroid coordinates of the geometry associated with the row version.
geom_center_x	double	The x-coordinate of the center of the geometry associated with the row version.
geom_center_y	double	The y-coordinate of the center of the geometry associated with the row version.
geom	binary	The complete geometry information associated with the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024