avatar ROTHAMSTED RESEARCH LIMITED Services

Pages

  • Page 1

    DATA QUALITY AND SUMMARY STATISTICS FLUME DATA Annual Report 2017 This report complements the data available on the data portal and is designed to help users by giving an overview of the quality and key statistics of the flume data. Data Version: 3 Release date: 14 November 2018 Report produced on: 13 October 2020 Compiled by: Jane Hawkins using R version 3.6.1 (2019‐07‐05)


  • Page 2

    Table of Contents Table of Contents 1 15 MINUTE DATA 1 1.1 Counts of PLC switch settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.2 Zero values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.3 Missing values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.3.1 Total number of missing values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.3.2 Total number of missing values as a percentage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.3.3 Total number of missing values when PLC switch = 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.3.4 Total number of measured values in flume data as a percentage of possible values when PLC switch = 1 . . . . . . . . . . . . . . . . . . . . . 3 1.3.5 Timesteps of missing 15 minute data when PLC switch = 1 (flow >0.2 l/s) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.4 Histograms of 15 minute data distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 1.5 Time series . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 1.6 Correlations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 2 MONTHLY 34 2.1 Flow duration curves . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 2.2 Means . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 2.3 Chloropleth maps of means . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58 2.4 Chloropleth maps of standard deviations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 3 ANNUAL 82 3.1 Summary Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 4 APPENDIX 88 4.1 Hydrological areas ‐ Catchments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 4.2 Hydrological areas ‐ Farmlets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88


  • Page 3

    List of Figures List of Tables 1 Counts of PLC switch settings ‐ missing data, no flow, flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2 Number of zero values (out of 35039) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 3 Total number of missing values (out of 35039) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 4 Total number of missing values as a percentage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 5 Total number of missing values when PLC switch = 1 (flow >0.2 l/s) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 6 Total number of measured values in flume data as a percentage of possible values when PLC switch = 1 (flow >0.2 l/s) . . . . . . . . . . . . . . . . . . 3 7 Annual summary statistics for flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 8 Annual summary statistics for nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 9 Annual summary statistics for ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 10 Annual summary statistics for conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 11 Annual summary statistics for dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 12 Annual summary statistics for pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 13 Annual summary statistics for flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 14 Annual summary statistics for turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 15 Annual summary statistics for total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 16 Annual summary statistics for dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 17 Annual summary statistics for ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 18 Catchment hydrological areas (ha) pre‐ and post‐ change to area of Catchment 4 on 13th August 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . 88 19 Farmlet hydrological areas (ha) pre‐ and post‐ change to area of Catchment 4 on 13th August 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 List of Figures 1 Timesteps of missing nitrate+nitrite data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2 Timesteps of missing ammonia data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3 Timesteps of missing ammonium data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4 Timesteps of missing conductivity data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5 Timesteps of missing dissolved oxygen data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8


  • Page 4

    List of Figures 6 Timesteps of missing pH data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 7 Timesteps of missing flow cell water temperature data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 8 Timesteps of missing turbidity data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 9 Timesteps of missing dissolved organic matter data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 10 Timesteps of missing ortho‐phosphorus data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 11 Distribution of data ‐ flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 12 Distribution of data ‐ nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 13 Distribution of data ‐ ammonia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 14 Distribution of data ‐ ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 15 Distribution of data ‐ conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 16 Distribution of data ‐ dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 17 Distribution of data ‐ pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 18 Distribution of data ‐ flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 19 Distribution of data ‐ turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 20 Distribution of data ‐ total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 21 Distribution of data ‐ dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 22 Distribution of data ‐ ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 23 Time series of precipitation, flow and nitrate+nitrite (NOX‐N) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 24 Time series of precipitation, flow and ammonia (NH3) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 25 Time series of precipitation, flow and ammonium (NH4) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 26 Time series of precipitation, flow and conductivity (CD) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 27 Time series of precipitation, flow and dissolved oxygen (DO) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 28 Time series of precipitation, flow and pH (pH) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 29 Time series of precipitation, flow and flow cell water temperature (Temp) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 30 Time series of precipitation, flow and turbidity (TB) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 31 Time series of precipitation, flow and total phosphorus (TP) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 32 Time series of precipitation, flow and dissolved organic matter (fDOM) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 33 Time series of precipitation, flow and ortho‐phosphorus (OP) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30


  • Page 5

    List of Figures 34 Correlations between catchments ‐ flow, nitrate+nitrite, ammonia, ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 35 Correlations between catchments ‐ conductivity, dissolved oxygen, pH, flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 36 Correlations between catchments ‐ turbidity, total phosphorus, dissolved organic matter, ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . 33 37 Flow duration curves for January . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 38 Flow duration curves for February . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 39 Flow duration curves for March . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 40 Flow duration curves for April . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 41 Flow duration curves for May . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 42 Flow duration curves for June . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 43 Flow duration curves for July . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 44 Flow duration curves for August . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 45 Flow duration curves for September . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 46 Flow duration curves for October . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 47 Flow duration curves for November . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 48 Flow duration curves for December . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 49 Monthly means for flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 50 Monthly means for nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 51 Monthly means for ammonia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 52 Monthly means for ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 53 Monthly means for conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 54 Monthly means for dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 55 Monthly means for pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 56 Monthly means for flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 57 Monthly means for turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 58 Monthly means for total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 59 Monthly means for dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 60 Monthly means for ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 61 Mapped means for flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58


  • Page 6

    List of Figures 62 Mapped means for nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 63 Mapped means for ammonia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 64 Mapped means for ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 65 Mapped means for conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 66 Mapped means for dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 67 Mapped means for pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 68 Mapped means for flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 69 Mapped means for turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 70 Mapped means for total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 71 Mapped means for dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 72 Mapped means for ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 73 Mapped standard deviations for flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 74 Mapped standard deviations for nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 75 Mapped standard deviations for ammonia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 76 Mapped standard deviations for ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 77 Mapped standard deviations for conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 78 Mapped standard deviations for dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 79 Mapped standard deviations for pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 80 Mapped standard deviations for flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 81 Mapped standard deviations for turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 82 Mapped standard deviations for total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 83 Mapped standard deviations for dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 84 Mapped standard deviations for ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81


  • Page 7

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1 15 MINUTE DATA • Catchments arranged from largest to smallest across tables (left to right) for each farmlet. • Where PLC switch = 0, this refers to timesteps when flume flow was <0.2 l/s (flow conditions not met) and so the pump is not activated to fill the by‐pass flow cell. Therefore, flume data are considered invalid and are classified as missing values (‘NA’) in the quality control process. • Where PLC switch = 1, flume flow is >0.2 l/s (flow conditions met) and so the pump is activated to fill the by‐pass flow cell. • For further explanation, refer to Sections 3.3 & 7.1.2 in the ‘User Guide to 15 Minute Data’ (FP_UG.Doc.002_15MinData) available on the Farm Platform website: http://resources.rothamsted.ac.uk/farm‐platform‐national‐capability/data‐portal‐guides‐and‐information 1.1 Counts of PLC switch settings Catchment Number Variable Green Blue Red 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 PLC Switch = NA (missing) 2421 1084 1471 582 664 488 1023 732 572 1093 875 1320 7436 1050 969 PLC Switch = 0 (no flow) 17581 21243 28424 32790 32217 26596 23414 25383 31951 30952 24871 18064 10831 30046 27839 PLC Switch = 1 (flow) 15037 12712 5144 1667 2158 7955 10602 8924 2516 2994 9293 15655 16772 3943 6231 Table 1: Counts of PLC switch settings ‐ missing data, no flow, flow 1.2 Zero values Catchment Number Variable Green Blue Red units 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 Flow l/s 29399 31909 33175 33628 33100 33169 32241 32170 33718 32886 31667 31442 30300 33346 32749 Nitrate+nitrite mg/l 1046 146 305 66 554 590 1347 1133 342 367 1124 332 2158 91 143 Ammonia mg/l 15008 12705 5140 1667 2158 7950 10485 8916 2514 2994 9289 15615 16756 3941 6227 Ammonium mg/l 14255 12016 4827 1480 2108 7302 7791 8810 2388 2754 7255 14296 16583 3418 5284 Conductivity uS/cm 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Dissolved oxygen % 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 pH unitless 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Flow cell water temperature °C 4 0 0 0 0 0 0 1 5 0 0 0 0 0 0 Turbidity FNU 2813 318 239 19 0 733 1095 2 6 0 694 1102 1548 431 52 Total phosphorus mg/l NA 8560 NA NA NA NA 7551 NA NA NA 7038 1434 NA NA NA Dissolved organic matter ug/l QSU 8 1 2 0 0 1 1 17 5 40 0 1 1 1 75 Ortho‐phosphorus mg/l NA 8562 NA NA NA NA 7556 NA NA NA 7038 1442 NA NA NA Table 2: Number of zero values (out of 35039) Page 1 of 88


  • Page 8

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.3 Missing values 1.3.1 Total number of missing values Catchment Number Variable Green Blue Red 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 Flow 2065 1072 978 1024 1337 488 520 921 816 1312 1544 1016 1122 1294 1243 Nitrate+nitrite 21064 23693 29975 33687 32909 27170 24597 26212 32566 32079 25842 19548 18459 31418 28911 Ammonia 20009 22333 29899 33372 32881 27089 24554 26123 32525 32045 25750 19424 18283 31098 28812 Ammonium 20152 22334 29914 33372 32881 27089 24607 26125 32526 32045 25750 19387 18285 31120 28816 Conductivity 20352 22333 29901 33372 32881 27090 24445 26124 32530 32045 25750 19388 18285 31112 28814 Dissolved oxygen 20013 22333 32781 33372 32882 27089 24445 26125 32530 32045 25750 19388 18284 31098 28812 pH 20013 22333 29899 33372 32882 27090 24445 26124 32530 32045 25751 19387 18285 31098 28813 Flow cell water temperature 20009 22333 29899 33372 32881 27089 24445 26123 32525 32045 25750 19387 18283 31098 28812 Turbidity 20234 22419 30008 33372 32881 27089 24983 26123 32525 32045 26036 19391 18284 31098 28812 Total phosphorus 35039 26477 35039 35039 35039 35039 27483 35039 35039 35039 28001 33597 35039 35039 35039 Dissolved organic matter 20015 22333 29899 33372 32881 27089 24445 26166 32525 32108 25750 19387 18284 31098 28892 Ortho‐phosphorus 35039 26477 35039 35039 35039 35039 27483 35039 35039 35039 28001 33597 35039 35039 35039 Table 3: Total number of missing values (out of 35039) 1.3.2 Total number of missing values as a percentage Catchment Number Variable Green Blue Red 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 Flow 6 3 3 3 4 1 1 3 2 4 4 3 3 4 4 PLC Switch 7 3 4 2 2 1 3 2 2 3 2 4 21 3 3 Nitrate+nitrite 60 68 86 96 94 78 70 75 93 92 74 56 53 90 83 Ammonia 57 64 85 95 94 77 70 75 93 91 73 55 52 89 82 Ammonium 58 64 85 95 94 77 70 75 93 91 73 55 52 89 82 Conductivity 58 64 85 95 94 77 70 75 93 91 73 55 52 89 82 Dissolved oxygen 57 64 94 95 94 77 70 75 93 91 73 55 52 89 82 pH 57 64 85 95 94 77 70 75 93 91 73 55 52 89 82 Flow cell water temperature 57 64 85 95 94 77 70 75 93 91 73 55 52 89 82 Turbidity 58 64 86 95 94 77 71 75 93 91 74 55 52 89 82 Total phosphorus 100 76 100 100 100 100 78 100 100 100 80 96 100 100 100 Dissolved organic matter 57 64 85 95 94 77 70 75 93 92 73 55 52 89 82 Ortho‐phosphorus 100 76 100 100 100 100 78 100 100 100 80 96 100 100 100 Table 4: Total number of missing values as a percentage Page 2 of 88


  • Page 9

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.3.3 Total number of missing values when PLC switch = 1 Catchment Number Variable Green Blue Red 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 Flow 438 146 0 16 94 0 3 42 1 2 161 235 171 0 35 Nitrate+nitrite 1062 1366 80 315 28 86 160 97 43 34 96 164 192 322 103 Ammonia 7 6 4 0 0 5 117 8 2 0 4 40 16 2 4 Ammonium 150 7 19 0 0 5 170 10 3 0 4 3 18 24 8 Conductivity 350 6 6 0 0 6 8 9 7 0 4 4 18 16 6 Dissolved oxygen 11 6 2886 0 1 5 8 10 7 0 4 4 17 2 4 pH 11 6 4 0 1 6 8 9 7 0 5 3 18 2 5 Flow cell water temperature 7 6 4 0 0 5 8 8 2 0 4 3 16 2 4 Turbidity 232 92 113 0 0 5 546 8 2 0 290 7 17 2 4 Dissolved organic matter 13 6 4 0 0 5 8 51 2 63 4 3 17 2 84 Ortho‐phosphorus 15037 4773 5144 1667 2158 7955 4793 8924 2516 2994 3886 14634 16772 3943 6231 Table 5: Total number of missing values when PLC switch = 1 (flow >0.2 l/s) 1.3.4 Total number of measured values in flume data as a percentage of possible values when PLC switch = 1 Catchment Number Variable Green Blue Red 4 5 6 12 13 9 8 7 11 14 2 3 1 10 15 Flow 219 267 662 2040 1562 434 326 382 1360 1126 360 217 202 856 542 Nitrate+nitrite 93 89 98 81 99 99 98 99 98 99 99 99 99 92 98 Ammonia 100 100 100 100 100 100 99 100 100 100 100 100 100 100 100 Ammonium 99 100 100 100 100 100 98 100 100 100 100 100 100 99 100 Conductivity 98 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Dissolved oxygen 100 100 44 100 100 100 100 100 100 100 100 100 100 100 100 pH 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Flow cell water temperature 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Turbidity 98 99 98 100 100 100 95 100 100 100 97 100 100 100 100 Dissolved organic matter 100 100 100 100 100 100 100 99 100 98 100 100 100 100 99 Ortho‐phosphorus 0 67 0 0 0 0 71 0 0 0 76 9 0 0 0 Table 6: Total number of measured values in flume data as a percentage of possible values when PLC switch = 1 (flow >0.2 l/s) Page 3 of 88


  • Page 10

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.3.5 Timesteps of missing 15 minute data when PLC switch = 1 (flow >0.2 l/s) • Data are in farmlet/catchment/triplet order with catchments arranged from largest to smallest down the page. • Colour bars represent missing 15 minute timestep water quality data for each farmlet when flow >0.2 l/s and may reflect data loss due to sensor downtime or where data failed the quality control process. • NB. Total phosphorus, ortho‐phosphorus and flume temperature not included as sampling and measurement are not influenced by the PLC switch values. Figure 1: Timesteps of missing nitrate+nitrite data Page 4 of 88


  • Page 11

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 2: Timesteps of missing ammonia data Page 5 of 88


  • Page 12

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 3: Timesteps of missing ammonium data Page 6 of 88


  • Page 13

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 4: Timesteps of missing conductivity data Page 7 of 88


  • Page 14

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 5: Timesteps of missing dissolved oxygen data Page 8 of 88


  • Page 15

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 6: Timesteps of missing pH data Page 9 of 88


  • Page 16

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 7: Timesteps of missing flow cell water temperature data Page 10 of 88


  • Page 17

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 8: Timesteps of missing turbidity data Page 11 of 88


  • Page 18

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 9: Timesteps of missing dissolved organic matter data Page 12 of 88


  • Page 19

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 10: Timesteps of missing ortho‐phosphorus data Page 13 of 88


  • Page 20

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.4 Histograms of 15 minute data distribution Figure 11: Distribution of data ‐ flow Figure 12: Distribution of data ‐ nitrate+nitrite Page 14 of 88


  • Page 21

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 13: Distribution of data ‐ ammonia Figure 14: Distribution of data ‐ ammonium Page 15 of 88


  • Page 22

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 15: Distribution of data ‐ conductivity Figure 16: Distribution of data ‐ dissolved oxygen Page 16 of 88


  • Page 23

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 17: Distribution of data ‐ pH Figure 18: Distribution of data ‐ flow cell water temperature Page 17 of 88


  • Page 24

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 19: Distribution of data ‐ turbidity Figure 20: Distribution of data ‐ total phosphorus Page 18 of 88


  • Page 25

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 21: Distribution of data ‐ dissolved organic matter Figure 22: Distribution of data ‐ ortho‐phosphorus Page 19 of 88


  • Page 26

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.5 Time series Figure 23: Time series of precipitation, flow and nitrate+nitrite (NOX‐N) Page 20 of 88


  • Page 27

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 24: Time series of precipitation, flow and ammonia (NH3) Page 21 of 88


  • Page 28

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 25: Time series of precipitation, flow and ammonium (NH4) Page 22 of 88


  • Page 29

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 26: Time series of precipitation, flow and conductivity (CD) Page 23 of 88


  • Page 30

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 27: Time series of precipitation, flow and dissolved oxygen (DO) Page 24 of 88


  • Page 31

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 28: Time series of precipitation, flow and pH (pH) Page 25 of 88


  • Page 32

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 29: Time series of precipitation, flow and flow cell water temperature (Temp) Page 26 of 88


  • Page 33

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 30: Time series of precipitation, flow and turbidity (TB) Page 27 of 88


  • Page 34

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 31: Time series of precipitation, flow and total phosphorus (TP) Page 28 of 88


  • Page 35

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 32: Time series of precipitation, flow and dissolved organic matter (fDOM) Page 29 of 88


  • Page 36

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 33: Time series of precipitation, flow and ortho‐phosphorus (OP) Page 30 of 88


  • Page 37

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA 1.6 Correlations Figure 34: Correlations between catchments ‐ flow, nitrate+nitrite, ammonia, ammonium Page 31 of 88


  • Page 38

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 35: Correlations between catchments ‐ conductivity, dissolved oxygen, pH, flow cell water temperature Page 32 of 88


  • Page 39

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 1 15 MINUTE DATA Figure 36: Correlations between catchments ‐ turbidity, total phosphorus, dissolved organic matter, ortho‐phosphorus Page 33 of 88


  • Page 40

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY 2 MONTHLY 2.1 Flow duration curves Data are in triplet/catchment order with catchments arranged from largest to smallest across the page. NB. Data may include missing values. Figure 37: Flow duration curves for January Page 34 of 88


  • Page 41

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 38: Flow duration curves for February Page 35 of 88


  • Page 42

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 39: Flow duration curves for March Page 36 of 88


  • Page 43

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 40: Flow duration curves for April Page 37 of 88


  • Page 44

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 41: Flow duration curves for May Page 38 of 88


  • Page 45

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 42: Flow duration curves for June Page 39 of 88


  • Page 46

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 43: Flow duration curves for July Page 40 of 88


  • Page 47

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 44: Flow duration curves for August Page 41 of 88


  • Page 48

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 45: Flow duration curves for September Page 42 of 88


  • Page 49

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 46: Flow duration curves for October Page 43 of 88


  • Page 50

    01 January 2017 00:15:00 to 01 January 2018 00:00:00 2 MONTHLY Figure 47: Flow duration curves for November Page 44 of 88

  • View More

Get the full picture and Receive alerts on lawsuits, news articles, publications and more!