Geological Survey of Finland - Soil Profiles and Formations

The dataset collection consists of one or more dataset tables sourced from the website of 'Geological Survey of Finland' in Finland.

Tables

Geological Survey of Finland - Soil Types and FormationsTSV
This table contains data from the 'Geological Survey of Finland' website. The data represents the geological layers and formations for a specific soil type. It provides information such as the extraction date, row number, GML ID, object ID, identifier, soil type, shape length, shape area, geographic JSON representation, geographic text representation, geometry type, centroid coordinates, center X coordinate, center Y coordinate, and the geometry. The table can be utilized in various data analytics tasks, such as analyzing the distribution and characteristics of different soil types, calculating the area and length of specific geological formations, and performing spatial analysis to identify patterns or relationships between the geological layers and other spatial datasets. The data...
History of Soil Layers and Formations in Finland - rajapinnat_gtk_maapera_wfsmaapera_1m_kerrostumat_ja_muodostumat__maapera_1m_kerrostumat_ja_muodostumatTSV
This table contains the version history of the rows extracted from the Geologian tutkimuskeskus website in the country Finland (ISO country code 'fi'). It is a historical record of the 'rajapinnat_gtk_maapera_wfsmaapera_1m_kerrostumat_ja_muodostumat__maapera_1m_kerrostumat_ja_muodostumat' base table. The rows in this table represent different versions of the data, with each row having a start date and an end date indicating when it was extracted from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table contains various columns such as '_row_number', 'gml_id', 'objectid', 'tunnus', 'maalaji', 'shape_length', 'shape_area', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and...

Column Descriptions

Geological Survey of Finland - Soil Types and Formations

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source
_row_number	long	The unique identifier of each row in the table
gml_id	string	The unique identifier in Geography Markup Language (GML) format
objectid	int	The object identifier of each record in the table
tunnus	string	The unique identifier for each item
maalaji	string	The type of land parcel
shape_length	int	The length of the geometric shape
shape_area	int	The area of the geometric shape
geom_geojson	string	The geometric shape in GeoJSON format
geom_geotext	string	The geometric shape in Geotext format
geom_type	string	The type of geometric shape
geom_centroid	string	The centroid of the geometric shape
geom_center_x	double	The X-coordinate of the center of the geometric shape
geom_center_y	double	The Y-coordinate of the center of the geometric shape
geom	binary	The geometric shape

History of Soil Layers and Formations in Finland - rajapinnat_gtk_maapera_wfsmaapera_1m_kerrostumat_ja_muodostumat__maapera_1m_kerrostumat_ja_muodostumat

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 for each row version.
gml_id	string	The GML ID of the row.
objectid	int	The object ID of the row.
tunnus	string	The tunnus of the row.
maalaji	string	The maalaji of the row.
shape_length	int	The length of the shape in the row.
shape_area	int	The area of the shape in the row.
geom_geojson	string	The GeoJSON representation of the geometry in the row.
geom_geotext	string	The geotext representation of the geometry in the row.
geom_type	string	The type of the geometry in the row.
geom_centroid	string	The centroid of the geometry in the row.
geom_center_x	double	The x-coordinate of the center of the geometry in the row.
geom_center_y	double	The y-coordinate of the center of the geometry in the row.
geom	binary	The geometry in the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024