avatar ROTHAMSTED RESEARCH LIMITED Services
  • Location: HERTFORDSHIRE 
  • Founded:
  • Website:

Pages

  • Page 1

    DATA QUALITY AND SUMMARY STATISTICS FLUME DATA Annual Report 2015 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 2015 00:15:00 to 01 January 2016 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) 48 2422 2200 1891 3037 0 88 11478 101 1 1 0 2590 101 119 PLC Switch = 0 (no flow) 18082 22020 22232 31869 29171 23631 24959 15938 31785 30517 25349 21251 17104 31133 25291 PLC Switch = 1 (flow) 16909 10597 10607 1279 2831 11408 9992 7623 3153 4521 9689 13788 15345 3805 9629 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 25205 30343 31933 32828 31375 32188 31266 22109 34495 33855 30467 30525 27784 34328 33806 Nitrate+nitrite mg/l 795 184 978 717 712 389 2762 389 44 2215 2234 820 2825 31 514 Ammonia mg/l 13955 10127 10415 1173 2823 11391 9897 7495 3033 4440 9580 13689 15205 3797 9556 Ammonium mg/l 13944 10031 10372 1202 2797 11385 9554 7421 2996 4437 8824 13616 15156 3787 9068 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Turbidity FNU 1984 763 400 0 0 507 33 61 42 83 223 524 2227 27 1154 Total phosphorus mg/l NA 8216 NA NA NA NA 7940 NA NA NA 11052 NA NA NA NA Dissolved organic matter ug/l QSU NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Ortho‐phosphorus mg/l NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table 2: Number of zero values (out of 35039) Page 1 of 88


  • Page 8

    01 January 2015 00:15:00 to 01 January 2016 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 1986 2 1427 1894 3039 1 92 11558 2 116 1112 6 141 221 5 Nitrate+nitrite 20140 24565 24913 33787 32262 23994 26055 28014 31922 30595 25458 21466 20512 31289 25757 Ammonia 21084 24912 24624 33866 32216 23648 25141 27544 32006 30599 25459 21350 19834 31242 25483 Ammonium 21084 24912 24622 33762 32216 23648 25141 27542 32006 30600 25459 21350 19834 31242 25484 Conductivity 18237 24912 24623 33761 32216 23649 25142 27554 32007 30883 25460 21351 19836 31243 25485 Dissolved oxygen 21012 24912 24624 33865 32216 23648 25141 27544 32006 30599 25459 21351 19836 31243 25483 pH 18235 24912 24622 33762 32216 23648 25141 27542 32006 30599 25459 21350 19834 31242 25483 Flow cell water temperature 18235 24912 24622 33761 32216 23648 25141 27542 32006 30599 25459 21350 19834 31242 25483 Turbidity 21119 24913 24637 33986 32216 23730 25144 29640 32084 30607 25484 21917 19963 31326 25958 Total phosphorus 35039 26823 35039 35039 35039 35039 27099 35039 35039 35039 23987 35039 35039 35039 35039 Dissolved organic matter 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 Ortho‐phosphorus 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 35039 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 0 4 5 9 0 0 33 0 0 3 0 0 1 0 PLC Switch 0 7 6 5 9 0 0 33 0 0 0 0 7 0 0 Nitrate+nitrite 57 70 71 96 92 68 74 80 91 87 73 61 59 89 74 Ammonia 60 71 70 97 92 67 72 79 91 87 73 61 57 89 73 Ammonium 60 71 70 96 92 67 72 79 91 87 73 61 57 89 73 Conductivity 52 71 70 96 92 67 72 79 91 88 73 61 57 89 73 Dissolved oxygen 60 71 70 97 92 67 72 79 91 87 73 61 57 89 73 pH 52 71 70 96 92 67 72 79 91 87 73 61 57 89 73 Flow cell water temperature 52 71 70 96 92 67 72 79 91 87 73 61 57 89 73 Turbidity 60 71 70 97 92 68 72 85 92 87 73 63 57 89 74 Total phosphorus 100 77 100 100 100 100 77 100 100 100 68 100 100 100 100 Dissolved organic matter 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Ortho‐phosphorus 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 Table 4: Total number of missing values as a percentage Page 2 of 88


  • Page 9

    01 January 2015 00:15:00 to 01 January 2016 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 21 2 2 0 1 1 4 60 1 1 37 3 2 120 1 Nitrate+nitrite 2010 123 481 27 54 363 1008 598 36 77 108 215 818 55 347 Ammonia 2954 470 192 106 8 17 94 128 120 81 109 99 140 8 73 Ammonium 2954 470 190 2 8 17 94 126 120 82 109 99 140 8 74 Conductivity 107 470 191 1 8 18 95 138 121 365 110 100 142 9 75 Dissolved oxygen 2882 470 192 105 8 17 94 128 120 81 109 100 142 9 73 pH 105 470 190 2 8 17 94 126 120 81 109 99 140 8 73 Flow cell water temperature 105 470 190 1 8 17 94 126 120 81 109 99 140 8 73 Turbidity 2989 471 205 226 8 99 97 2224 198 89 134 666 269 92 548 Dissolved organic matter 16909 10597 10607 1279 2831 11408 9992 7623 3153 4521 9689 13788 15345 3805 9629 Ortho‐phosphorus 16909 10597 10607 1279 2831 11408 9992 7623 3153 4521 9689 13788 15345 3805 9629 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 195 331 317 2591 1130 307 350 308 1111 772 350 254 227 915 364 Nitrate+nitrite 88 99 95 98 98 97 90 92 99 98 99 98 95 99 96 Ammonia 83 96 98 92 100 100 99 98 96 98 99 99 99 100 99 Ammonium 83 96 98 100 100 100 99 98 96 98 99 99 99 100 99 Conductivity 99 96 98 100 100 100 99 98 96 92 99 99 99 100 99 Dissolved oxygen 83 96 98 92 100 100 99 98 96 98 99 99 99 100 99 pH 99 96 98 100 100 100 99 98 96 98 99 99 99 100 99 Flow cell water temperature 99 96 98 100 100 100 99 98 96 98 99 99 99 100 99 Turbidity 82 96 98 82 100 99 99 71 94 98 99 95 98 98 94 Dissolved organic matter NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Ortho‐phosphorus NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 00:00:00 1 15 MINUTE DATA Figure 2: Timesteps of missing ammonia data Page 5 of 88


  • Page 12

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


  • Page 13

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


  • Page 14

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


  • Page 15

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


  • Page 16

    01 January 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 00:00:00 1 15 MINUTE DATA Figure 8: Timesteps of missing turbidity data Page 11 of 88


  • Page 18

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


  • Page 19

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


  • Page 20

    01 January 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 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 2015 00:15:00 to 01 January 2016 00:00:00 2 MONTHLY Figure 38: Flow duration curves for February Page 35 of 88


  • Page 42

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


  • Page 43

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


  • Page 44

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


  • Page 45

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


  • Page 46

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


  • Page 47

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


  • Page 48

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


  • Page 49

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


  • Page 50

    01 January 2015 00:15:00 to 01 January 2016 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!