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.
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.
Abundance: Abundance of macroinvertebrates.

Trait Database

Default trait values for the SPEAR calculation. Trait values here will be copied to ’Species Traits & Classification’ for all linked taxa (see below).

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.

Taxa Link

Link between taxa of ‘Monitoring Data’ and ’Trait Database’.
New taxa added to ‘Monitoring Data’ are automatically added to this table and linked to taxa with similar names in the ’Trait Database’.
Links can be adapted manually. Taxa not linked will be ignored in the SPEAR calculation.

Button 'Reset links': Reset default links of all ‘Taxa of Monitoring Data’.
Button 'Delete taxa not in Monitoring Data': Delete all rows with taxa which are not part of ’Monitoring Data’

Classification

Trait Thresholds

Thresholds for the Species Classification, please check and adjust.

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

Species Traits & Classification

All traits and their SPEAR-classification. Traits can be edited.

Button 'Reset trait values': Reset all trait values as defined in table ’Trait Database’.
Button 'Delete taxa not in Taxa Link': Delete all rows not linked to taxa in ’Monitoring Data’.

To export, right click on a table and choose 'Export CSV' from the context menu.

Taxa: Linked taxa in Trait Database.
Sensitivity, Generation, Migration and Exposed: Traits & Classification used for the calculation of the 'SPEAR_class'. Classification of all traits: Green = sensitive trait value; Gray = 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).
A species is classified as a ‘Species at risk’ (SPEAR_class = 1) if all four traits are classified as sensitive (green). 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’.