Skip to main content
Log in

REBECCA databases: experiences from compilation and analyses of monitoring data from 5,000 lakes in 20 European countries

  • Published:
Aquatic Ecology Aims and scope Submit manuscript

Abstract

Chemical and biological data from more than 5,000 lakes in 20 European countries have been compiled into databases within the EU project REBECCA. The project’s purpose was to provide scientific support for implementation of the EU Water Framework Directive (WFD). The databases contain the biological elements phytoplankton, macrophytes, macroinvertebrates and fish, together with relevant chemistry data and station information. The common database strategy has enabled project partners to perform analyses of chemical–biological relationships and to describe reference conditions for large geographic regions in Europe. This strategy has obvious benefits compared with single-country analyses: results will be more representative for larger European regions, and the statistical power and precision will be larger. The high number of samples within some regions has also enabled analysis of type-specific relationships for several lake types. These results are essential for the intercalibration of ecological assessment systems for lakes, as required by the WFD. However, the common database approach has also involved costs and limitations. The data process has been resource-demanding, and the requirements for a flexible database structure have made it less user-friendly for project partners. Moreover, there are considerable heterogeneities among datasets from different countries regarding sampling methods and taxonomic precision; this may reduce comparability of the data and increase the uncertainty of the results. This article gives an overview of the contents and functions of the REBECCA Lakes databases, and of our experiences from constructing and using the databases. We conclude with recommendations for compilation of environmental data for future international projects.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2

Similar content being viewed by others

Abbreviations

BQE:

Biological quality element

GIG:

Geographical Intercalibration Group

IC:

Intercalibration

REBECCA:

RElationships Between Ecological and Chemical stAtus in surface waters

TOC:

Total organic carbon

WFD:

Water Framework Directive

References

  • Beier U, Degerman E, Melcher A, Rogers C, Wirlöf H (2007) Processes of collating a European fisheries database to meet the objectives of the European Union Water Framework Directive. Fish Manag Ecol 14:407–416

    Article  Google Scholar 

  • Borja A, Josefson AB, Miles A, Muxika I, Olsgard F, Phillips G, Rodriguez JG, Rygg B (2007) An approach to the intercalibration of benthic ecological status assessment in the North Atlantic ecoregion, according to the European Water Framework Directive. Mar Pollut Bull 55:42–52

    Article  PubMed  CAS  Google Scholar 

  • Brack W, Bakker J, de Deckere E, Deerenberg C, van Gils J, Hein M, Jurajda P, Kooijman B, Lamoree M, Lek S, de Alda MJL, Marcomini A, Munoz I, Rattei S, Segner H, Thomas K, Von der Ohe PC, Westrich B, de Zwart D, Schmitt-Jansen M (2005) MODELKEY—Models for assessing and forecasting the impact of environmental key pollutants on freshwater and marine ecosystems and biodiversity. Environ Sci Pollut Res 12:252–256

    Article  CAS  Google Scholar 

  • Carstensen J, Heiskanen AS (2007) Phytoplankton responses to nutrient status: application of a screening method to the northern Baltic Sea. Mar Ecol Prog Ser 336:29–42

    Article  CAS  Google Scholar 

  • Carvalho L, Solimini A, Phillips G, Berg Mvd, Pietiläinen O–P, Solheim AL, Poikane S, Mischke U (2008) Chlorophyll reference conditions for European lake types used for intercalibration of ecological status. Aquat Ecol. doi:10.1007/s10452-008-9189-4

  • Clarke R, Hering D (2006) Errors and uncertainty in bioassessment methods—major results and conclusions from the STAR project and their application using STARBUGS. Hydrobiologia 566:433–440

    Article  Google Scholar 

  • Degerman E, Beier U, Breine J, Melcher A, Quataert P, Rogers C, Roset N, Simoens I (2007) Classification and assessment of degradation in European running waters. Fish Manag Ecol 14(6):417–426. doi:10.1111/j.1365-2400.2007.00578.x

    Article  Google Scholar 

  • European Commission (2003) Common Implementation Strategy for the Water Framework Directive (2000/60/EC). Guidance document no. 6. Towards a guidance on establishment of the intercalibration network and the process on the intercalibration exercise. Produced by Working Group 2.5 Intercalibration, pp. 54

  • European Commission (2005) Common Implementation Strategy for the Water Framework Directive (2000/60/EC). Guidance document no. 14. In guidance on the intercalibration process 2004–2006, pp. 26

  • Furse M, Hering D, Moog O, Verdonschot P, Johnson R, Brabec K, Gritzalis K, Buffagni A, Pinto P, Friberg N, Murray-Bligh J, Kokes J, Alber R, Usseglio-Polatera P, Haase P, Sweeting R, Bis B, Szoszkiewicz K, Soszka H, Springe G, Sporka F, Krno I (2006) The STAR project: context, objectives and approaches. Hydrobiologia 566:3–32

    Article  Google Scholar 

  • G.-Tóth L, Poikane S, Penning WE, Free G, Mäemets H, Kolada A (2008) Comparing national assessment methods for macrophytes as a biological quality element for the WFD: results from the first steps of the Central-Baltic intercalibration exercise. Aquat Ecol. doi:10.1007/s10452-008-9184-9

  • Haase P, Murray-Bligh J, Lohse S, Pauls S, Sundermann A, Gunn R, Clarke R (2006) Assessing the impact of errors in sorting and identifying macroinvertebrate samples. Hydrobiologia 566:505–522

    Article  Google Scholar 

  • Hering D, Moog O, Sandin L, Verdonschot P (2004) Overview and application of the AQEM assessment system. Hydrobiologia 516:1–20

    Article  Google Scholar 

  • Lorenz A, Kirchner L, Hering D (2004) “Electronic subsampling” of macrobenthic samples: how many individuals are needed for a valid assessment result? Hydrobiologia 516:299–312

    Article  Google Scholar 

  • Lyche Solheim A, Rekolainen S, Moe SJ, Carvalho L, Phillips G, Ptacnik R, Penning E, Toth LG, O’Toole C, Schartau AKL, Hesthagen T (2008) Ecological threshold responses in European Lakes and their applicability for WFD implementation—synthesis of REBECCA Lakes results. Aquat Ecol. doi:10.1007/s10452-008-9188-5

  • Moe SJ, Ptacnik R, Penning E, Kuikka S, Malve O (2007) Statistical and modelling methods for assessing the relationships between ecological and chemical status in lakes. REBECCA Deliverable 12. NIVA report nr. 5459–2007, pp. 38

  • O’Toole C, Donohue I, Moe SJ, Irvine K (2008) Relationships between nutrient status and benthic invertebrate communities: application of the REBECCA database. Aquat Ecol. doi:10.1007/s10452-008-9185-8

  • Ohe PCvd, Prüß A, Schäfer RB, Liess M, Deckeree Ed, Brack W (2007) Water quality indices across Europe – a comparison of the good ecological status of five river basins. J Environ Monitor 9:970–978

    Article  Google Scholar 

  • Penning WE, Dudley B, Mjelde M, Hellsten S, Hanganu J, Ecke F, Willby N, Phillips G (2008a) Using aquatic macrophyte community indices to define the ecological status of European lakes. Aquat Ecol. doi:10.1007/s10452-008-9183-x

  • Penning WE, Mjelde M, Dudley B, Hellsten S, Hanganu J, Ecke F, Willby N, Phillips G (2008b) Classifying aquatic macrophytes as indicators of eutrophication in European lakes. Aquat Ecol. doi:10.1007/s10452-008-9182-y

  • Phillips G, Pietiläinen O-P, Carvalho L, Solimini A, Solheim AL, Cardoso AC (2008) Chlorophyll—nutrient relationships of different lake types using a large European dataset. Aquat Ecol. doi:10.1007/s10452-008-9180-0

  • Pont D, Hugueny B, Rogers C (2007) Development of a fish-based index for the assessment of river health in Europe: the European Fish Index. Fish Manag Ecol 14(6):427–439. doi:10.1111/j.1365-2400.2007.00577.x

    Article  Google Scholar 

  • Ptacnik R, Andersen T, Solimini AG, Brettum P, Lepistö L, Willén E, Rekolainen S, Tamminen T (2008a) Diversity predicts stability and resource use efficiency in natural phytoplankton communities. Proc Natl Acad Sci 105:5134–5138

    Article  PubMed  CAS  Google Scholar 

  • Ptacnik R, Lepistö L, Willén E, Brettum P, Andersen T, Rekolainen S, Solheim AL (2008b) Phytoplankton classes sensitive to eutrophication. Aquat Ecol. doi:10.1007/s10452-008-9181-z

  • Refsgaard JC, Nilsson B, Brown J, Klauer B, Moore R, Bech T, Vurro M, Blind M, Castilla G, Tsanis L, Biza P (2005) Harmonised techniques and representative river basin data for assessment and use of uncertainty information in integrated water management (HarmoniRiB). Environ Sci Policy 8:267–277

    Article  Google Scholar 

  • Refsgaard JC, Jørgensen LF, Højberg AL (2007) Data availability and accessibility. State of the art on existing data required for modelling for research purposes and for the implementation of the Water Framework Directive: Geological Survey of Denmark and Greenland

  • Schafer RB, Caquet T, Siimes K, Mueller R, Lagadic L, Liess M (2007) Effects of pesticides on community structure and ecosystem functions in agricultural streams of three biogeographical regions in Europe. Sci Total Environ 382:272–285

    Article  PubMed  Google Scholar 

  • Schartau AK, Moe SJ, Sandin L, McFarland B, Raddum G (2008) Macroinvertebrate indicators of lake acidification: testing on data from UK, Norway and Sweden. Aquat Ecol. doi:10.1007/s10452-008-9186-7

  • Schmidt-Kloiber A, Nijboer R (2004) The effect of taxonomic resolution on the assessment of ecological water quality classes. Hydrobiologia 516:269–284

    Article  Google Scholar 

  • Schmidt-Kloiber A, Graf W, Lorenz A, Moog O (2006) The AQEM/STAR taxalist—a pan-European macro-invertebrate ecological database and taxa inventory. Hydrobiologia 566:325–342

    Article  Google Scholar 

  • Schriever CA, Liess M (2007) Mapping ecological risk of agricultural pesticide runoff. Sci Total Environ 384:264–279

    Article  PubMed  CAS  Google Scholar 

  • Verdonschot P (2006a) Data composition and taxonomic resolution in macroinvertebrate stream typology. Hydrobiologia 566:59–74

    Article  Google Scholar 

  • Verdonschot P (2006b) Evaluation of the use of Water Framework Directive typology descriptors, reference sites and spatial scale in macroinvertebrate stream typology. Hydrobiologia 566:39–58

    Article  Google Scholar 

  • Verdonschot P, Moog O (2006) Tools for assessing European streams with macroinvertebrates: major results and conclusions from the STAR project. Hydrobiologia 566:299–310

    Article  Google Scholar 

  • Vlek H, Šporka F, Krno I (2006) Influence of macroinvertebrate sample size on bioassessment of streams. Hydrobiologia 566:523–542

    Article  Google Scholar 

Download references

Acknowledgements

We thank the all data providers and contact persons for their contributions, and especially those from institutes external to the REBECCA project. REBECCA partners: DDNI: Orhan Ibram, Jenica Hanganu; IRSA: Gianni Tartari, Elena Legani; NINA: Ann Kristin Schartau; CEH: Laurence Carvalho; SLU: Leonard Sandin, Mats Wallin, Eva Willén; SYKE: Arjen Raateland, Olli-Pekka Pietiläinen, Seppo Hellsten; TCD: Constanze O’Toole, Ian Donohue; WL|Delft: Ellis Penning; NIVA: Anne Lyche Solheim, Pål Brettum, Marit Mjelde. External data providers: JRC (CB-GIG): Sandra Poikane; Finland: Jukka Aroviita, Heikki Hämäläinen; Germany: Ute Mische, Rita Adrian, Stella Berger, Peter Krause, Ursula Gaedke, Tom Kunz; Ireland: Deirdre Thierny, Ruth Little, Alice Wermer, John White; Norway: Gunnar Raddum; Poland: Malgorzata Golub, Agnieska Kolada; Portugal: Joao Padua; Spain: Mª Luisa Serrano; Sweden: Mikaela Gonczi, Eva Willén; UK: Geoff Phillips. Finally, we thank Gunnar Severinsen for enormous help with constructing the databases at NIVA and for training and assistance, Thrond O. Haugen for providing information on the fish data and Birger Bjerkeng for providing the Microsoft Excel™ macro for reorganising data. REBECCA is jointly funded by the EC 6th Framework Programme (Contract number SSPI-CT-2003-502158), various national research organisations and the project partners.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to S. Jannicke Moe.

Appendix 1

Appendix 1

Table A1 Overview of major chemical determinands in the REBECCA databases: (A) Phytoplankton, (B) Macrophytes, (C) Macroinvertebrates

Rights and permissions

Reprints and permissions

About this article

Cite this article

Moe, S.J., Dudley, B. & Ptacnik, R. REBECCA databases: experiences from compilation and analyses of monitoring data from 5,000 lakes in 20 European countries. Aquat Ecol 42, 183–201 (2008). https://doi.org/10.1007/s10452-008-9190-y

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10452-008-9190-y

Keywords

Navigation