This version is deprecated! The current version is 2021.02.!

SPEAR_pesticide

SPEAR_pesticide is a trait based bioindicator that estimates exposure and ecological effect of pesticide contamination in streams on the base of invertebrate monitoring data.

Input

Monitoring Data

Paste your monitoring data here. Select data by clicking on (i) the upper left corner of the table, (ii) row numbers and column names, (iii) single cells.
Before first use, please delete the example dataset.

Name₁, Name₂ and Name_3: Names of the samplings. A sampling can be identified by one name or, optionally, by a combination of maximal three names (e.g. Germany-Leipzig-2014).
Recovery: Presence of recovery areas. A recovery area is defined as an uncontaminated stream section (e.g. forest, meadow) of more than ~100 m length and within ~3 kilometers upstream of the sampling site. Coding: 1 = presence; 0 = absence.
TU_measured: Measured exposure to pesticides given in Toxic Units (TU). The toxicity of pesticide exposure is standardized to the acute 48h-LC₅₀ of D. magna.
Taxa: Family, genus or species name of the sampled macroinvertebrates.
Taxa_Alternative: Alternative taxa name (e.g. a higher taxonomic rank).
Abundance: Abundance of macroinvertebrates.

Trait Databaase

Default trait values for the SPEAR calculation. Trait values can be modified here.

Group, Family, Genus, Taxa: Group, family, genus and species name according to the AQEM project.
Rank: Level of the taxonomic hierarchy.
Sensitivity: Toxicological sensitivity of a species to organic pollutions including pesticides. Values are standardized by the toxicological sensitivity of D. magna. Coding: Less sensitive than D. magna < 0 < more sensitive than D. magna.
Generation: Generation time of a species. Unit: Year/Generation.
Migration: Ability of a species to migrate. Coding: 1: No migration, 0: Migration.
Exposed: Possibility of a species to be exposed. Coding: 1: Exposed; 0: Not exposed.

Link

Monitoring & Traits

Press the button to link the taxa of your 'Monitoring Data' with the taxa of the 'Trait Database'. Check and adjust the result in 'Monitoring & Traits'. Existing entries in 'Monitoring & Traits' will NOT be overwritten.

Button 1: All taxa of ‘Monitorings Data’ will be linked to the ‘Trait Database’; links are displayed in ‘Monitoring & Traits’. Note: This function DELETES all previous links.
Button 2: This function links only taxa which are not yet linked.

Monitoring & Traits

Link between ‘Monitoring Data’ and Trait Database’. Links can be adapted manually. Unlinked taxa will be ignored in the SPEAR calculation.

Classification

Thresholds

Thresholds for the following Species Classification, please check and adjust.

Thresholds for the following Species Classification.
Coding: Not sensitive < THRESHOLD ≤ Sensitive.

Classification

Calculated table, modifications are not possible. To export, right click on a table and choose 'Export CSV' from the context menu.

Taxa: Linked taxa in Trait Database.
Taxa_Monitoring: Taxa of your Monitoring Data.
Sensitivity_Code, Generation_Code, Migration_Code and Exposed_Code: Codings used for the calculation of the 'SPEAR_class'. Coding of all traits: 1 = sensitive trait value; 0 = not sensitive trait value.
SPEAR_class: Final classification of species into ‘Species at risk’ (SPEAR_class = 1) and ‘Species not at risk’ (SPEAR_class = 0). Classification is based on the following formula: SPEAR_class = Sensitivity x Generation x Migration x Exposed. Species are NOT considered in case of missing trait values.

Results

Effect & Exposure Estimates

Calculated table, modifications are not possible. To export, right click on a table and choose 'Export CSV' from the context menu.

SPEAR_pesticide: SPEAR_pesticide of sampling sites is given as the relative abundance of ‘Species at risk’ (SPEAR; SPEAR_Class = 1).
EQ_pesticide: The environmental quality of a sampling site with respect to pesticide contamination. The quality classes are based on the concept of the ecological status (WFD) with the following five levels:
‘high’, ‘good’, ‘moderate’, ‘poor’ and ‘bad’.
TU_measured: Measured exposure to pesticides given in Toxic Units (TU). The toxicity of pesticide exposure is standardized to the acute 48h-LC₅₀ of D. magna.
TU_estimated: The estimated exposure to pesticides given in Toxic Units (TU). The toxicity of pesticide exposure is standardized to the acute 48h-LC₅₀ of D. magna.

Effect Plot

SPEAR_pesticide of sampling sites is given as the relative abundance of ‘Species at risk’ (SPEAR; SPEAR_Class = 1).

Effect Distribution

The environmental impact of pesticide contamination given as the distribution of EQ_pesticide for all sampling sites. The quality classes are based on the concept of the ecological status (WFD) with the following five levels:
‘high’, ‘good’, ‘moderate’, ‘poor’ and ‘bad’.