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

Monitoring-Data-Converter

Version: 2018.05

Monitoring-Data-Converter is a tool to convert monitoring data from a format used in the ASTERICS software into a format suitable for the SPEAR Calculator and vice versa.

Monitoring Data (Asterics): Table for monitoring data in Asterics format.
Monitoring Data (UFZ): Table for monitoring data in UFZ format.
Paste the monitoring data in the respective table and use the buttons in the toolbar to start the conversion.

Please note: This tool is not perfect! You should double check your results!

Monitoring Data (Asterics)

Please, have a close look at the example monitoring data. The first two columns of the first row must contain the special keyword TAXON_NAME.
Columns S1 to S50 in the first row contain the names of up to 50 sampling sites.
For a detailed explanation, please refer to the documentation of the ASTERICS software.

Key: Key for a sampling site property or taxon name. Except for the special key Recovery all other values are ignored.
A recovery area is defined as an uncontaminated stream section (e.g. forest, meadow) of more than ~100 m length and within ~3. Presence of recovery areas. Coding: 1 = presence; 0 = absence; (empty cell) = undefined
Taxa: Taxa used in your monitoring dataset.
S1 ... S50: Abundances for each sampling site and taxa. The maximum number of sampling sites

Monitoring Data (UFZ)

Name1, Name2 and Name3: 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 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.
Taxa: Family, genus or species name of the sampled macroinvertebrates.
Abundance: Abundance of macroinvertebrates. Unit has to be defined uniformly.