Geological Survey of Finland - Soil Data

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

Tables

Geological Survey of Finland - Soil Attributes and GeomorphologyTSV
This table contains data from the 'Geological Survey of Finland' website. The data pertains to geographical areas and their characteristics in Finland. The table includes information about the extraction date, row numbers, IDs, creation types and codes, area and length of shapes, as well as various geometry properties. The data is provided in JSON and geotext formats, along with the centroid and center coordinates of the geometry. The 'geom' column contains the actual geometry data. This table can be utilized in data analytics to analyze the distribution of different types of geographical areas in Finland, calculate the area and length of shapes, perform geospatial queries using the geometry data, and visualize the data on maps for further analysis.
Version History of Soil Types in Finland (Geological Survey of Finland)TSV
This table contains the version history of the base table 'rajapinnat_gtk_maapera_wfsriutat__riutat'. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when the corresponding row version 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 value in the '_end_date' column is null, it means that the row is the most recent version. This table includes several other columns such as 'gml_id', 'objectid', 'luontotyyppi_koodi', 'luontotyyppi', 'aluenimi', 'shape_area', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data is sourced from the web site of 'Geological...

Column Descriptions

Geological Survey of Finland - Soil Attributes and Geomorphology

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
gml_id	string	The GML ID of the object.
objectid	int	The ID of the object.
luontotyyppi_koodi	int	The code for the nature type.
luontotyyppi	string	The name of the nature type.
aluenimi	string	The name of the area.
shape_area	int	The area of the shape.
shape_len	int	The length of the shape.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext 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 in binary format.

Version History of Soil Types in Finland (Geological Survey of Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The number of the row version.
gml_id	string	The GML identifier of the row version.
objectid	int	The identifier of the row version.
luontotyyppi_koodi	int	The code representing the nature type of the row version.
luontotyyppi	string	The nature type of the row version.
aluenimi	string	The name of the area related to the row version.
shape_area	int	The area of the shape representing the row version.
shape_len	int	The length of the shape representing 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 of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center of the geometry of the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024