Geological Survey of Finland Soil Data Collection

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

Tables

Historical Versions of Sand Dunes from Finnish Geological SurveyTSV
This table contains the version history of the 'Geologian tutkimuskeskus' dataset related to the 'hiekkasarkat' feature. It has additional columns compared to the base table, namely '_start_date' and '_end_date', which represent the extraction dates of each row. The data in this table can be utilized for various data analytics purposes. For example, it can be used to track changes in the 'luontotyyppi' (nature type) and 'aluenimi' (area name) over time. Additionally, by analyzing the 'shape_area' and 'shape_len' columns, one can gain insights into the size and perimeter of the features. The 'geom_geojson', 'geom_geotext', and 'geom' columns provide geometrical information that can be utilized for spatial analyses. By examining the 'geom_type' column, the type of geometry can be...
Sand Dunes in Finland: Geologic Survey of Finland - Soil typesTSV
This table contains data on sand dunes from the website of the Geological Survey of Finland ('Geologian tutkimuskeskus'). The data is sourced from the country Finland (ISO country code: 'fi'). The table provides information on various attributes related to sand dunes, including extraction date, row number, GML ID, object ID, land type code, land type, area name, shape area, shape length, geographical coordinates in GeoJSON format, geographical coordinates in Geotext format, geometry type, centroid coordinates, centroid X-coordinate, centroid Y-coordinate, and the geometry itself. The table can be utilized in data analytics to analyze the distribution and characteristics of sand dunes in Finland, study their shapes and sizes, calculate the area and perimeter of individual dunes,...

Column Descriptions

Sand Dunes in Finland: Geologic Survey of Finland - Soil types

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the entry in the table.
gml_id	string	The ID of the GML object.
objectid	int	The unique identifier of the object.
luontotyyppi_koodi	int	The code for the type of nature area.
luontotyyppi	string	The type of nature area.
aluenimi	string	The name of the area.
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 Well-Known Text (WKT) 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 center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry of the object.

Historical Versions of Sand Dunes from Finnish Geological Survey

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	A sequential number assigned to each row in the table.
gml_id	string	The ID of the geographic markup language (GML) associated with the row.
objectid	int	The unique identifier for the row.
luontotyyppi_koodi	int	The code representing the type of nature.
luontotyyppi	string	The type of nature.
aluenimi	string	The name of the area.
shape_area	int	The area of the shape geometry.
shape_len	int	The length of the shape geometry.
geom_geojson	string	The geometric data represented in GeoJSON format.
geom_geotext	string	The geometric data represented in Geotext format.
geom_type	string	The type of geometric data.
geom_centroid	string	The centroid point 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 geometric data.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024