von Gönner Julia 0000-0002-5901-9158 Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 Gröning Jonas 0000-0001-9650-362X Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 Grescho Volker 0000-0001-5547-7373 Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 Neuer Lilian Hänsch Veit G 0000-0003-0102-2124 Gottfried Benjamin Molsberger-Lange Eva Wilharm Elke 0009-0002-6860-5973 Liess Matthias matthias.liess@ufz.de 0000-0002-3321-8909 Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 Bonn Aletta 0000-0002-8345-4600 Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 2024 Stream monitoring data from the citizen science project FLOW, 2021 - 2023 dataset https://doi.org/10.1594/PANGAEA.971638 2024-08-30T10:17:27 This dataset contains the results of the citizen science stream monitoring project FLOW (www.flow-projekt.de), which aims to complement official freshwater monitoring programs with data on small streams. We provide data for 172 stream sites across Germany, which were monitored by over 90 trained citizen science groups in 2021, 2022 and 2023. For each stream site (i.e., 100m sample section), we list data on stream hydromorphology (according to LAWA, 2019), point measurements of physico-chemical water parameters (i.e., water temperature, oxygen content, ammonium, nitrite, nitrate, phosphate, pH, ion conductivity, flow velocity). The related dataset (DOI) lists recorded benthic invertebrate communities (sampled according to Meier et al., 2006 and identified at least to the family level). Most of the sampled streams (80%) had small catchment areas of less than 30km2 and 83 % of the stream sites were located in agricultural catchments with at least 20 % agricultural land cover (CORINE land cover class 2). 57 % of the stream sites were located in highland streams (primarily types 5, 6, and 7) and 43 % in lowland streams (primarily types 14, 18, 11, and 16). We also provide data on the biological indicator SPEARpesticides (Liess & v.d. Ohe 2005, Liess et al., 2021) for each stream site to assess pesticide exposure and effects based on macroinvertebrate community composition. The database produced by citizen science groups was characterized by a high degree of accuracy, as results obtained by citizen scientists and professionals were highly correlated for SPEARpesticides index and hydromorphology index values (von Gönner et al., 2024). The dataset is the basis of the following publication: Julia von Gönner, Jonas Gröning, Volker Grescho, Lilian Neuer, Benjamin Gottfried, Veit G. Hänsch, Eva Molsberger-Lange, Elke Wilharm, Matthias Liess, Aletta Bonn: Citizen science shows that small agricultural streams in Germany are in a poor ecological status. Science of The Total Environment, Volume 922, 2024, 171183, ISSN 0048-9697, https://doi.org/10.1016/j.scitotenv.2024.171183. von Gönner Julia 0000-0002-5901-9158 Gröning Jonas 0000-0001-9650-362X Grescho Volker 0000-0001-5547-7373 Neuer Lilian Gottfried Benjamin Hänsch Veit G 0000-0003-0102-2124 Molsberger-Lange Eva Wilharm Elke 0009-0002-6860-5973 Liess Matthias matthias.liess@ufz.de 0000-0002-3321-8909 Bonn Aletta 0000-0002-8345-4600 2024 Citizen science shows that small agricultural streams in Germany are in a poor ecological status journal article Science of the Total Environment 922 https://doi.org/10.1016/j.scitotenv.2024.171183 171183 von Gönner Julia 0000-0002-5901-9158 Gröning Jonas 0000-0001-9650-362X Grescho Volker 0000-0001-5547-7373 Neuer Lilian Hänsch Veit G 0000-0003-0102-2124 Gottfried Benjamin Molsberger-Lange Eva Wilharm Elke 0009-0002-6860-5973 Liess Matthias matthias.liess@ufz.de 0000-0002-3321-8909 Bonn Aletta 0000-0002-8345-4600 2024 Macroinvertebrate taxonomic data from the citizen science project FLOW, 2021-2023 dataset https://doi.org/10.1594/PANGAEA.971944 6.0945 14.9095 47.856 53.75 10.6750128844186 50.970704445232556 2021-04-13T14:00:00 2023-07-13T11:00:00 uncoded table FLOW FLOW: Fließgewässer erforschen – gemeinsam Wissen schaffen https://www.flow-projekt.de/index.php/de/ Helmholtz Centre for Environmental Research - UFZ UFZ http://www.ufz.de/ https://ror.org/000h6jb29 Federal Ministry of Education and Research BMBF https://www.bmbf.de/ https://doi.org/10.13039/501100002347 01BF2103A Teilvorhaben BUND: Citizen Scientists erforschen bundesweit die Pestizidbelastung und die Insektendiversität kleiner Fließgewässer https://foerderportal.bund.de/foekat/jsp/SucheAction.do?actionMode=view&fkz=01BF2103B Federal Ministry of Education and Research BMBF https://www.bmbf.de/ https://doi.org/10.13039/501100002347 01BF2103B Teilvorhaben UFZ: Citizen Scientists erforschen bundesweit die Pestizidbelastung und die Insektendiversität kleiner Fließgewässer https://foerderportal.bund.de/foekat/jsp/SucheAction.do?actionMode=view&fkz=01BF2103B FLOW_2021-2023 50.97 10.67 Germany 2021-04-13T14:00:00 2023-07-13T11:00:00 Monitoring MON 7990 CC-BY-4.0 Creative Commons Attribution 4.0 International https://creativecommons.org/licenses/by/4.0/ Site Site site Number of sample site Site (Number of sample site) Area/locality Area Area http://dbpedia.org/resource/Area Federal state of germany Area (Federal state of germany) DATE/TIME Date/Time http://en.wikipedia.org/wiki/ISO_8601 Time T http://dbpedia.org/resource/Time Date/Time LONGITUDE Longitude http://en.wikipedia.org/wiki/ISO_6709 Longitude LATITUDE Latitude http://en.wikipedia.org/wiki/ISO_6709 Latitude Year of observation Year obs a AD year Time T http://dbpedia.org/resource/Time Year of stream sampling event Year obs [a AD] (Year of stream sampling event) River, classification ecological River type eco river http://purl.obolibrary.org/obo/ENVO_00000022 According to German river typology (LAWA 2019) River type eco (According to German river typ...) SPEAR index SPEAR index https://www.systemecology.de/indicate/templates/spear-pesticides-calculation/2023.08/CHANGELOG.html Bioindicator values to quantify pesticide exposure based on the invertebrate communities recorded at each site SPEAR index (Bioindicator values to quanti...) SPEAR, class SPEAR class Categorization of SPEAX_index values into one of the five ecological status classes with 1= high (>0.8), 2= good (>0.6-0.8), 3= moderate (>0.4-0.6), 4 =poor (>0.2-0.4), 5= bad (≤0.2) SPEAR class (Categorization of SPEAX_index...) SPEAR, status SPEAR stat Categorization of SPEAX_index values into one of the two states - 1 = 'good', including SPEAR_classes 1 and 2, or 0 = 'poor', including SPEAR_classes 3, 4, and 5 SPEAR stat (Categorization of SPEAX_index...) Hydromorphology index Hydromorphology index Index values to assess stream hydromorphology calculated according to LAWA, 2019 based on the six subcomponents of hydromorphology watercourse, longitudinal profile, cross profile, substrate, riverbank, landuse Hydromorphology index (Index values to assess stream...) Hydromorphology, class Hydromorphology class morphology http://purl.obolibrary.org/obo/PATO_0000051 Categorization of morphology_index values into one of the five status classes with 1= unchanged (≤2.2), 2= slightly changed (>2.2-3.4), 3= moderately changed (>3.4-4.6), 4 =strongly changed (>4.6-5.8), 5= completely changed (>5.8) Hydromorphology class (Categorization of morphology_...) Hydromorphology, status Hydromorphology stat morphology http://purl.obolibrary.org/obo/PATO_0000051 Categorization of morphology_index values into one of the two states - 1 = 'good', including morphology_classes 1 and 2, or 0 = 'poor', including morphology_classes 3, 4, and 5 Hydromorphology stat (Categorization of morphology_...) Watercourse index Watercourse index Index value to assess the ecological quality of the water course within the 100m stream sample site according to LAWA, 2019 Watercourse index (Index value to assess the eco...) Long profile index Long profile index Index value to assess the ecological quality of the longitudinal profile within the 100m stream sample site according to LAWA, 2019 Long profile index (Index value to assess the eco...) Cross profile index Cross profile index Index value to assess the ecological quality of the cross profile within the 100m stream sample site according to LAWA, 2019 Cross profile index (Index value to assess the eco...) Substrate index Substrate index Index value to assess the ecological quality of the stream bed substrates within the 100m stream sample site according to LAWA, 2019 Substrate index (Index value to assess the eco...) Riverbank index Riverbank index Index value to assess the ecological quality of the river bank vegetation within the 100m stream sample site according to LAWA, 2019 Riverbank index (Index value to assess the eco...) Landuse index Landuse index Index value to assess the land use in a 100m radius around the stream sample site according to LAWA, 2019 Landuse index (Index value to assess the lan...) Present weather ww Weather on the day of stream sampling event ww (Weather on the day of stream ...) Temperature, air TTT °C Temperature Θ http://dbpedia.org/resource/Temperature air Point measurement of air temperature on the day of stream sampling event TTT [°C] (Point measurement of air temp...) Water, color Water c water http://purl.obolibrary.org/obo/CHEBI_15377 Color of the stream water (qualitative assessment, i.e., clear, brown, green, turbid) Water c (Color of the stream water (qu...) Water, foaming Water foam water http://purl.obolibrary.org/obo/CHEBI_15377 0=no foam present on the stream water surface, 1=foam present on the stream water surface Water foam (0=no foam present on the stre...) Water, shiny Water shiny water http://purl.obolibrary.org/obo/CHEBI_15377 0=no oil film present on the stream water surface, 1=oil film present on the stream water surface Water shiny (0=no oil film present on the ...) Water, smell Water smell water http://purl.obolibrary.org/obo/CHEBI_15377 Smell of the stream water (qualitative assessment, i.e., neutral, odour of rotten eggs, fishy/earthy, mouldy) Water smell (Smell of the stream water (qu...) Indicator, sulfit stain Indicator sulfit stain indicator http://purl.obolibrary.org/obo/CHEBI_47867 0=no sulphite stains present on stones in stream bed, 1=sulphite stains present on stones in stream bed Indicator sulfit stain (0=no sulphite stains present ...) Temperature, water Temp °C Temperature Θ http://dbpedia.org/resource/Temperature water http://purl.obolibrary.org/obo/CHEBI_15377 Point measurement of water temperature on the day of stream sampling event Temp [°C] (Point measurement of water te...) Oxygen, dissolved DO mg/l oxygen O https://www.ebi.ac.uk/chebi/searchId.do?chebiId=CHEBI:25805 dissolved http://purl.obolibrary.org/obo/PATO_0001986 Density http://dbpedia.org/resource/Density Point measurement of oxygen content of stream water at sample site DO [mg/l] (Point measurement of oxygen c...) Oxygen, dissolved DO % oxygen O https://www.ebi.ac.uk/chebi/searchId.do?chebiId=CHEBI:25805 dissolved http://purl.obolibrary.org/obo/PATO_0001986 Dimensionless Ratio ψ Point measurement of oxygen concentration of stream water at sample site DO [%] (Point measurement of oxygen c...) Conductivity, electrical EC µS/cm conductivity http://purl.obolibrary.org/obo/PATO_0001585 Point measurement of electrical conductivity of stream water at sample site EC [µS/cm] (Point measurement of electric...) pH pH Point measurement of pH value of stream water at sample site pH (Point measurement of pH value...) Flow velocity, water Vel water m/s water http://purl.obolibrary.org/obo/CHEBI_15377 Linear Velocity http://dbpedia.org/resource/Velocity Point measurement of flow velocity of stream water at sample site Vel water [m/s] (Point measurement of flow vel...) Ammonium, dissolved [NH4]+ diss mg/l ammonium http://purl.obolibrary.org/obo/CHEBI_28938 dissolved http://purl.obolibrary.org/obo/PATO_0001986 Density http://dbpedia.org/resource/Density Point measurement of ammonium (NH4) concentration in stream water at sample site [NH4]+ diss [mg/l] (Point measurement of ammonium...) Nitrite [NO2]- mg/l nitrite http://purl.obolibrary.org/obo/CHEBI_16301 Density http://dbpedia.org/resource/Density Point measurement of nitrite (NO2) concentration in stream water at sample site [NO2]- [mg/l] (Point measurement of nitrite ...) Nitrate, dissolved [NO3]- diss mg/l nitrate http://purl.obolibrary.org/obo/CHEBI_17632 dissolved http://purl.obolibrary.org/obo/PATO_0001986 Density http://dbpedia.org/resource/Density Point measurement of nitrate (NO3) concentration in stream water at sample site [NO3]- diss [mg/l] (Point measurement of nitrate ...) Phosphate [PO4]3- mg/l phosphate http://purl.obolibrary.org/obo/CHEBI_26020 Density http://dbpedia.org/resource/Density Point measurement of phosphate (PO4) concentration in stream water at sample site [PO4]3- [mg/l] (Point measurement of phosphat...) Chloride Cl- mg/l chloride http://purl.obolibrary.org/obo/CHEBI_17996 Density http://dbpedia.org/resource/Density Point measurement of chloride (Cl-) concentration in stream water at sample site Cl- [mg/l] (Point measurement of chloride...) Catchment area Catch area km**2 Area http://dbpedia.org/resource/Area Total catchment area Catch area [km**2] (Total catchment area) Area, forest Area forest km**2 Area http://dbpedia.org/resource/Area forest http://purl.obolibrary.org/obo/ENVO_00000111 Forest area in catchment Area forest [km**2] (Forest area in catchment) Areal extent, urban area Area urban km**2 Area http://dbpedia.org/resource/Area Urban area in catchment Area urban [km**2] (Urban area in catchment) Land cover, agriculture LC agri km**2 Area http://dbpedia.org/resource/Area Agricultural land cover in catchment in km2 (CORINE land cover class 2) LC agri [km**2] (Agricultural land cover in ca...) Land cover, arable LC arab km**2 Area http://dbpedia.org/resource/Area Arable land cover in catchment in km2 (CORINE land cover class 2.1) LC arab [km**2] (Arable land cover in catchmen...) Land cover, forest LC forest % forest http://purl.obolibrary.org/obo/ENVO_00000111 Dimensionless Ratio ψ Percent forest land cover in catchment LC forest [%] (Percent forest land cover in ...) Areal extent, urban area Area urban % Dimensionless Ratio ψ Percent urban land cover in catchment Area urban [%] (Percent urban land cover in c...) Land cover, agriculture LC agri % Dimensionless Ratio ψ Percent agricultural land cover in catchment (CORINE land cover class 2) LC agri [%] (Percent agricultural land cov...) Land cover, arable LC arab % Dimensionless Ratio ψ Percent arable land cover in catchment (CORINE land cover class 2.1) LC arab [%] (Percent arable land cover in ...) Type Type type categorization into agricultural streams (>20% agricultural land cover in catchment) and non-agricultural streams (<20% agricultural land cover in catchment) Type (categorization into agricultu...) Number percentage N perc % Dimensionless Ratio ψ Correct_families: Percentage of macroinvertebrate families correctly identified by the citizen science groups at each of the n = 81 sample sites for which citizen science samples were conserved and reassessed by professional ecologists in the laboratory. N perc [%] (Correct_families: Percentage ...) SPEAR index SPEAR index https://www.systemecology.de/indicate/templates/spear-pesticides-calculation/2023.08/CHANGELOG.html professional value SPEAR index (professional value) SPEAR, class SPEAR class professional value SPEAR class (professional value) SPEAR, status SPEAR stat professional value SPEAR stat (professional value) Hydromorphology index Hydromorphology index professional value Hydromorphology index (professional value) Hydromorphology, class Hydromorphology class morphology http://purl.obolibrary.org/obo/PATO_0000051 professional value Hydromorphology class (professional value) Hydromorphology, status Hydromorphology stat morphology http://purl.obolibrary.org/obo/PATO_0000051 professional value Hydromorphology stat (professional value) Comment Comment sites included into the main analysis of the linked manuscript Comment (sites included into the main ...) Comment Comment sites included into the analysis per monitoring year Comment (sites included into the analy...) citable Agricultural streams Citizen science hydromorphology Macroinvertebrate community composition pesticides Water Framework Directive author105603 author105604 author105605 author105606 author105607 author105608 author105609 author105610 author105611 author78546 award4045 award4047 event3181311 funder20473 geocode1599 geocode1600 geocode1601 inst468 journal14514 license21 method10690 param106233 param107870 param127016 param130429 param145013 param145231 param145232 param15373 param1570 param15954 param180431 param181343 param27072 param4610 param48491 param48494 param48928 param501850 param530607 param530608 param530609 param530610 param530611 param530612 param530613 param530614 param530615 param530616 param530617 param530618 param530619 param530620 param530621 param530622 param530623 param530624 param530625 param530626 param530627 param530628 param530629 param530630 param530631 param717 param764 param88113 project4930 ref126252 refds971944 term1073162 term1073173 term1073174 term1073482 term1073483 term1073484 term1073493 term1073970 term1074359 term1074520 term1102892 term21134 term2606205 term37810 term38494 term40453 term41076 term43770 term43792 term43794 term43876 term43972 term43975 term49506 term50850 term51489 term60801 term69483 term74562 term74563 topotype11