Soil Data of Finland (2015)

The dataset collection consists of one or more dataset tables sourced from the website of the Finnish Forest Research Institute in Finland.

Tables

Soil of Finland 2015TSV
This table contains soil data for Finland collected from the website of the Finnish Forest Research Institute (Metsantutkimuslaitos). The data represents various attributes related to the soil in Finland, such as extract date, row number, global ID, Finnish text description, hectares, WRB classification in 2015, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of the geometry, the X coordinate of the center of the geometry, the Y coordinate of the center of the geometry, and the actual geometry itself. The table provides valuable information for performing data analytics related to soil composition, land area measurement, spatial analysis, and geological studies in Finland.
Version History of Soil Off Finland 2015 Data from 'Finnish Forest Research Institute' in FinlandTSV
This table contains the version history of the base table 'Soil of Finland 2015'. It is sourced from the website of Metsantutkimuslaitos, which originates from the country with the ISO country code 'FI' (Finland). The table includes information about the start and end dates of each row, along with other columns such as '_row_number', 'gid', 'fin_txt', 'hectares', 'wrb_2015', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be utilized for various data analytics purposes, such as analyzing changes in soil characteristics over time, identifying trends in land use patterns, and calculating the centroid and center coordinates of the geographical features represented by each row.

Column Descriptions

Soil of Finland 2015

Column	Type	Comment
_extract_date	date	The date and time when the row was extracted.
_row_number	long	The number assigned to the row in the table.
gid	int	The unique identifier for each row in the table.
fin_txt	string	The financial text associated with the row.
hectares	int	The area in hectares.
wrb_2015	string	The World Reference Base for Soil Resources (WRB) classification for 2015.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in well-known text (WKT) format.
geom_type	string	The type of geometry of the row (e.g., Point, LineString, Polygon).
geom_centroid	string	The centroid of the geometry as a point.
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 full geometry of the row.

Version History of Soil Off Finland 2015 Data from 'Finnish Forest Research Institute' 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 unique identifier for each row version
gid	int	The globally unique identifier for each row
fin_txt	string	The financial text associated with the row
hectares	int	The area in hectares associated with the row
wrb_2015	string	The World Reference Base for Soil Resources code associated with the row
geom_geojson	string	The geometry of the row in GeoJSON format
geom_geotext	string	The geometry of the row in Geotext format
geom_type	string	The type of geometry for the row
geom_centroid	string	The centroid of the geometry of the row
geom_center_x	double	The x-coordinate of the center of the geometry of the row
geom_center_y	double	The y-coordinate of the center of the geometry of the row
geom	binary	The geometrical representation of the row

Additional Info

Last Updated	April 23, 2024
Created	September 26, 2018