Geological Survey of Finland - Soil WFS Area-based Stream Sediment Geochemistry Mineral Sample A61 - Version History of Sediment Geochemistry Mineral Samples in Regional Stream Ecosystems - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Version History of Sediment Geochemistry Mineral Samples in Regional Stream Ecosystems

To download the data set, please sign up or log in

This table contains the version history of rows from the 'Geological Survey of Finland' dataset related to regional stream sediment geochemistry and mineral samples. The table includes information such as the start and end dates of each row version, row number, unique identifiers, geographical coordinates, map sheet, material type, width, velocity, site and catchment details, date of sample collection, concentrations of various elements (e.g., cobalt, chromium, copper, iron, manganese, nickel, lead, zinc), fraction, and various geometrical attributes. The table is a historical log that tracks changes in the base table over time, with each row representing a specific version with its corresponding start and end dates. By analyzing the data in this table, researchers and analysts can gain insights into the temporal evolution of stream sediment geochemistry and mineral samples across different sites and catchments in Finland.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date of the row version indicating the validity period of the row.
_end_date	date	The end date of the row version indicating the validity period of the row.
_row_number	long	The row number of the version history table.
gml_id	string	The GML identifier of the base table row.
objectid	int	The unique identifier of the base table row.
id	string	The identifier of the row version.
id_number	string	The numerical identifier of the row version.
easting	int	The easting coordinate of the location.
northing	int	The northing coordinate of the location.
mapsheet20	int	The 20-digit map sheet identifier.
material	string	The material attribute of the row version.
width_m	int	The width in meters of the row version.
velocity	string	The velocity attribute of the row version.
site	string	The site attribute of the row version.
catchment	int	The catchment attribute of the row version.
date_a61	int	The date attribute of the row version.
co_a61_ppm	int	The cobalt attribute in parts per million (ppm) of the row version.
co_l	string	The cobalt attribute in liters of the row version.
cr_l	string	The chromium attribute in liters of the row version.
cu_a61_ppm	int	The copper attribute in parts per million (ppm) of the row version.
cu_l	string	The copper attribute in liters of the row version.
fe_l	string	The iron attribute in liters of the row version.
mn_a61_ppm	int	The manganese attribute in parts per million (ppm) of the row version.
mn_l	string	The manganese attribute in liters of the row version.
ni_a61_ppm	int	The nickel attribute in parts per million (ppm) of the row version.
ni_l	string	The nickel attribute in liters of the row version.
pb_a61_ppm	int	The lead attribute in parts per million (ppm) of the row version.
pb_l	string	The lead attribute in liters of the row version.
zn_a61_ppm	int	The zinc attribute in parts per million (ppm) of the row version.
zn_l	string	The zinc attribute in liters of the row version.
cr_a61_ppm	int	The chromium attribute in parts per million (ppm) of the row version.
fraction	string	The fraction attribute of the row version.
fe_a61_ppm	int	The iron attribute in parts per million (ppm) of the row version.
geom_geojson	string	The geometric representation of the row version in GeoJSON format.
geom_geotext	string	The geometric representation of the row version in GeoText format.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid point of the row version geometry.
geom_center_x	double	The x-coordinate of the center point of the row version geometry.
geom_center_y	double	The y-coordinate of the center point of the row version geometry.
geom	binary	The geometric representation of the row version.

Name

Data type

Description

_start_date

date

The start date of the row version indicating the validity period of the row.

_end_date

date

The end date of the row version indicating the validity period of the row.

_row_number

long

The row number of the version history table.

gml_id

string

The GML identifier of the base table row.

objectid

int

The unique identifier of the base table row.

string

The identifier of the row version.

id_number

string

The numerical identifier of the row version.

easting

int

The easting coordinate of the location.

northing

int

The northing coordinate of the location.

mapsheet20

int

The 20-digit map sheet identifier.

material

string

The material attribute of the row version.

width_m

int

The width in meters of the row version.

velocity

string

The velocity attribute of the row version.

site

string

The site attribute of the row version.

catchment

int

The catchment attribute of the row version.

date_a61

int

The date attribute of the row version.

co_a61_ppm

int

The cobalt attribute in parts per million (ppm) of the row version.

co_l

string

The cobalt attribute in liters of the row version.

cr_l

string

The chromium attribute in liters of the row version.

cu_a61_ppm

int

The copper attribute in parts per million (ppm) of the row version.

cu_l

string

The copper attribute in liters of the row version.

fe_l

string

The iron attribute in liters of the row version.

mn_a61_ppm

int

The manganese attribute in parts per million (ppm) of the row version.

mn_l

string

The manganese attribute in liters of the row version.

ni_a61_ppm

int

The nickel attribute in parts per million (ppm) of the row version.

ni_l

string

The nickel attribute in liters of the row version.

pb_a61_ppm

int

The lead attribute in parts per million (ppm) of the row version.

pb_l

string

The lead attribute in liters of the row version.

zn_a61_ppm

int

The zinc attribute in parts per million (ppm) of the row version.

zn_l

string

The zinc attribute in liters of the row version.

cr_a61_ppm

int

The chromium attribute in parts per million (ppm) of the row version.

fraction

string

The fraction attribute of the row version.

fe_a61_ppm

int

The iron attribute in parts per million (ppm) of the row version.

geom_geojson

string

The geometric representation of the row version in GeoJSON format.

geom_geotext

string

The geometric representation of the row version in GeoText format.

geom_type

string

The type of geometry of the row version.

geom_centroid

string

The centroid point of the row version geometry.

geom_center_x

double

The x-coordinate of the center point of the row version geometry.

geom_center_y

double

The y-coordinate of the center point of the row version geometry.

geom

binary

The geometric representation of the row version.

Additional Information


Last updated	April 22, 2024
Created	April 22, 2024
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	delta
Country	fi
Database	fi_geologian_tutkimuskeskus
Id	e1e12914-daf2-48c0-967a-a75e0bf70ff1
Package id	c7274e29-5518-4353-8f0a-b35eb60d25c5
Position	1
Revision id	68f196db-8eb7-4082-9c7c-9cbeace54a1d
State	active
Table	rajapinnat_gtk_maapera_wfsalueellinen_purosedimenttigeokemia_mineraali_naytteet_a61__alueellinen_purosedimenttigeokemia_mineraali_naytteet_a61__history

Last updated

April 22, 2024

Created

April 22, 2024

License

No License Provided

Geographic coverage

Geographic granularity

Temporal coverage from

Temporal coverage to

Adapter

delta

Country

Database

fi_geologian_tutkimuskeskus

e1e12914-daf2-48c0-967a-a75e0bf70ff1

Package id

c7274e29-5518-4353-8f0a-b35eb60d25c5

Position

Revision id

68f196db-8eb7-4082-9c7c-9cbeace54a1d

State

active

Table

rajapinnat_gtk_maapera_wfsalueellinen_purosedimenttigeokemia_mineraali_naytteet_a61__alueellinen_purosedimenttigeokemia_mineraali_naytteet_a61__history

Version History of Sediment Geochemistry Mineral Samples in Regional Stream Ecosystems

Field Descriptions

No sample for this dataset

Additional Information