avatar ROTHAMSTED RESEARCH LIMITED Services

Pages

  • Page 1

    DATA QUALITY AND SUMMARY STATISTICS FLUME DATA Annual Report 2013 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 1.5 Time series . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 1.6 Correlations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 2 MONTHLY 33 2.1 Flow duration curves . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 2.2 Means . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 2.3 Chloropleth maps of means . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 2.4 Chloropleth maps of standard deviations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 3 ANNUAL 81 3.1 Summary Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 4 APPENDIX 87 4.1 Hydrological areas ‐ Catchments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 4.2 Hydrological areas ‐ Farmlets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87


  • 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 8 Annual summary statistics for nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 9 Annual summary statistics for ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 10 Annual summary statistics for conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 11 Annual summary statistics for dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 12 Annual summary statistics for pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 13 Annual summary statistics for flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 14 Annual summary statistics for turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 15 Annual summary statistics for total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 16 Annual summary statistics for dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 17 Annual summary statistics for ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 18 Catchment hydrological areas (ha) pre‐ and post‐ change to area of Catchment 4 on 13th August 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . 87 19 Farmlet hydrological areas (ha) pre‐ and post‐ change to area of Catchment 4 on 13th August 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 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 Distribution of data ‐ flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 11 Distribution of data ‐ nitrate+nitrite . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 12 Distribution of data ‐ ammonia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 13 Distribution of data ‐ ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 14 Distribution of data ‐ conductivity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 15 Distribution of data ‐ dissolved oxygen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 16 Distribution of data ‐ pH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 17 Distribution of data ‐ flow cell water temperature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 18 Distribution of data ‐ turbidity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 19 Distribution of data ‐ total phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 20 Distribution of data ‐ dissolved organic matter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 21 Distribution of data ‐ ortho‐phosphorus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 22 Time series of precipitation, flow and nitrate+nitrite (NOX‐N) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 23 Time series of precipitation, flow and ammonia (NH3) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 24 Time series of precipitation, flow and ammonium (NH4) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 25 Time series of precipitation, flow and conductivity (CD) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 26 Time series of precipitation, flow and dissolved oxygen (DO) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 27 Time series of precipitation, flow and pH (pH) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 28 Time series of precipitation, flow and flow cell water temperature (Temp) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 29 Time series of precipitation, flow and turbidity (TB) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 30 Time series of precipitation, flow and total phosphorus (TP) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 31 Time series of precipitation, flow and dissolved organic matter (fDOM) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 32 Time series of precipitation, flow and ortho‐phosphorus (OP) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 33 Correlations between catchments ‐ flow, nitrate+nitrite, ammonia, ammonium . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30


  • Page 5

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


  • Page 6

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


  • Page 7

    01 January 2013 00:15:00 to 01 January 2014 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) 624 313 285 593 0 285 3850 285 0 0 36 0 0 0 0 PLC Switch = 0 (no flow) 15377 21727 24555 31829 31204 23729 20054 25809 30284 28842 23259 22127 20208 28880 25003 PLC Switch = 1 (flow) 19038 12999 10199 2617 3835 11025 11135 8945 4755 6197 11744 12912 14831 6159 10036 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 25564 30407 32654 33858 34119 31739 30007 33337 34131 33477 29182 30656 29297 33494 32777 Nitrate+nitrite mg/l 5613 990 1680 997 1361 1469 3406 1649 723 1082 2472 3021 8413 456 949 Ammonia mg/l 18212 9211 9805 2462 3715 10793 10695 8912 4724 5320 11114 11114 13102 6151 9863 Ammonium mg/l 16746 9813 9744 2324 3654 10697 8230 8796 4634 5233 6263 10725 11249 5925 9264 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 6877 672 3616 111 2 267 47 437 2 142 699 911 1208 562 1360 Total phosphorus mg/l NA 4708 NA NA NA NA 3656 NA NA NA 4789 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 87


  • Page 8

    01 January 2013 00:15:00 to 01 January 2014 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 624 313 0 593 0 0 0 0 0 0 36 0 0 0 0 Nitrate+nitrite 16402 23430 25218 32627 31276 24586 25112 27756 30332 30221 24446 22935 21895 29056 25394 Ammonia 16827 25828 25234 32577 31324 24246 24344 26127 30315 29719 23815 23925 21894 28888 25176 Ammonium 18114 24641 25234 32577 31323 24246 25457 26131 30315 29719 25054 23925 23272 28888 25176 Conductivity 16830 24643 25234 32577 31323 24246 24348 26128 30316 29719 24035 23930 22068 28888 25177 Dissolved oxygen 16827 25828 25234 32577 31324 24246 24344 26127 30315 29719 23480 23925 21892 28888 25176 pH 16827 24641 25234 32577 31323 24246 24344 26127 30315 29719 23480 23925 21892 28888 25176 Flow cell water temperature 16827 24641 25234 32577 31323 24246 24344 26127 30315 29719 23480 23925 21892 28888 25176 Turbidity 19149 24900 26052 33258 31325 25766 24356 26346 30315 29843 25558 23928 23249 29138 26618 Total phosphorus 35039 30331 35039 35039 35039 35039 31378 35039 35039 35039 30250 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 2 1 0 2 0 0 0 0 0 0 0 0 0 0 0 PLC Switch 2 1 1 2 0 1 11 1 0 0 0 0 0 0 0 Nitrate+nitrite 47 67 72 93 89 70 72 79 87 86 70 65 62 83 72 Ammonia 48 74 72 93 89 69 69 75 87 85 68 68 62 82 72 Ammonium 52 70 72 93 89 69 73 75 87 85 72 68 66 82 72 Conductivity 48 70 72 93 89 69 69 75 87 85 69 68 63 82 72 Dissolved oxygen 48 74 72 93 89 69 69 75 87 85 67 68 62 82 72 pH 48 70 72 93 89 69 69 75 87 85 67 68 62 82 72 Flow cell water temperature 48 70 72 93 89 69 69 75 87 85 67 68 62 82 72 Turbidity 55 71 74 95 89 74 70 75 87 85 73 68 66 83 76 Total phosphorus 100 87 100 100 100 100 90 100 100 100 86 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 87


  • Page 9

    01 January 2013 00:15:00 to 01 January 2014 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Nitrate+nitrite 401 1390 378 205 72 572 1208 1662 48 1379 1151 808 1687 176 391 Ammonia 826 3788 394 155 120 232 440 33 31 877 520 1798 1686 8 173 Ammonium 2113 2601 394 155 119 232 1553 37 31 877 1759 1798 3064 8 173 Conductivity 829 2603 394 155 119 232 444 34 32 877 740 1803 1860 8 174 Dissolved oxygen 826 3788 394 155 120 232 440 33 31 877 185 1798 1684 8 173 pH 826 2601 394 155 119 232 440 33 31 877 185 1798 1684 8 173 Flow cell water temperature 826 2601 394 155 119 232 440 33 31 877 185 1798 1684 8 173 Turbidity 3148 2860 1212 836 121 1752 452 252 31 1001 2263 1801 3041 258 1615 Dissolved organic matter 19038 12999 10199 2617 3835 11025 11135 8945 4755 6197 11744 12912 14831 6159 10036 Ortho‐phosphorus 19038 12999 10199 2617 3835 11025 11135 8945 4755 6197 11744 12912 14831 6159 10036 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 181 267 344 1316 914 318 315 392 737 565 298 271 236 569 349 Nitrate+nitrite 98 89 96 92 98 95 89 81 99 78 90 94 89 97 96 Ammonia 96 71 96 94 97 98 96 100 99 86 96 86 89 100 98 Ammonium 89 80 96 94 97 98 86 100 99 86 85 86 79 100 98 Conductivity 96 80 96 94 97 98 96 100 99 86 94 86 87 100 98 Dissolved oxygen 96 71 96 94 97 98 96 100 99 86 98 86 89 100 98 pH 96 80 96 94 97 98 96 100 99 86 98 86 89 100 98 Flow cell water temperature 96 80 96 94 97 98 96 100 99 86 98 86 89 100 98 Turbidity 83 78 88 68 97 84 96 97 99 84 81 86 79 96 84 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 87


  • Page 10

    01 January 2013 00:15:00 to 01 January 2014 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 87


  • Page 11

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 2: Timesteps of missing ammonia data Page 5 of 87


  • Page 12

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 3: Timesteps of missing ammonium data Page 6 of 87


  • Page 13

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 4: Timesteps of missing conductivity data Page 7 of 87


  • Page 14

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 5: Timesteps of missing dissolved oxygen data Page 8 of 87


  • Page 15

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 6: Timesteps of missing pH data Page 9 of 87


  • Page 16

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 7: Timesteps of missing flow cell water temperature data Page 10 of 87


  • Page 17

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 8: Timesteps of missing turbidity data Page 11 of 87


  • Page 18

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 9: Timesteps of missing dissolved organic matter data Page 12 of 87


  • Page 19

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA 1.4 Histograms of 15 minute data distribution Figure 10: Distribution of data ‐ flow Figure 11: Distribution of data ‐ nitrate+nitrite Page 13 of 87


  • Page 20

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 12: Distribution of data ‐ ammonia Figure 13: Distribution of data ‐ ammonium Page 14 of 87


  • Page 21

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 14: Distribution of data ‐ conductivity Figure 15: Distribution of data ‐ dissolved oxygen Page 15 of 87


  • Page 22

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 16: Distribution of data ‐ pH Figure 17: Distribution of data ‐ flow cell water temperature Page 16 of 87


  • Page 23

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 18: Distribution of data ‐ turbidity Figure 19: Distribution of data ‐ total phosphorus Page 17 of 87


  • Page 24

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 20: Distribution of data ‐ dissolved organic matter Figure 21: Distribution of data ‐ ortho‐phosphorus Page 18 of 87


  • Page 25

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA 1.5 Time series Figure 22: Time series of precipitation, flow and nitrate+nitrite (NOX‐N) Page 19 of 87


  • Page 26

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 23: Time series of precipitation, flow and ammonia (NH3) Page 20 of 87


  • Page 27

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 24: Time series of precipitation, flow and ammonium (NH4) Page 21 of 87


  • Page 28

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 25: Time series of precipitation, flow and conductivity (CD) Page 22 of 87


  • Page 29

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 26: Time series of precipitation, flow and dissolved oxygen (DO) Page 23 of 87


  • Page 30

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 27: Time series of precipitation, flow and pH (pH) Page 24 of 87


  • Page 31

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 28: Time series of precipitation, flow and flow cell water temperature (Temp) Page 25 of 87


  • Page 32

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 29: Time series of precipitation, flow and turbidity (TB) Page 26 of 87


  • Page 33

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 30: Time series of precipitation, flow and total phosphorus (TP) Page 27 of 87


  • Page 34

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 31: Time series of precipitation, flow and dissolved organic matter (fDOM) Page 28 of 87


  • Page 35

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 32: Time series of precipitation, flow and ortho‐phosphorus (OP) Page 29 of 87


  • Page 36

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA 1.6 Correlations Figure 33: Correlations between catchments ‐ flow, nitrate+nitrite, ammonia, ammonium Page 30 of 87


  • Page 37

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 34: Correlations between catchments ‐ conductivity, dissolved oxygen, pH, flow cell water temperature Page 31 of 87


  • Page 38

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 1 15 MINUTE DATA Figure 35: Correlations between catchments ‐ turbidity, total phosphorus, dissolved organic matter, ortho‐phosphorus Page 32 of 87


  • Page 39

    01 January 2013 00:15:00 to 01 January 2014 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 36: Flow duration curves for January Page 33 of 87


  • Page 40

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 37: Flow duration curves for February Page 34 of 87


  • Page 41

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 38: Flow duration curves for March Page 35 of 87


  • Page 42

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 39: Flow duration curves for April Page 36 of 87


  • Page 43

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 40: Flow duration curves for May Page 37 of 87


  • Page 44

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 41: Flow duration curves for June Page 38 of 87


  • Page 45

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 42: Flow duration curves for July Page 39 of 87


  • Page 46

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 43: Flow duration curves for August Page 40 of 87


  • Page 47

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 44: Flow duration curves for September Page 41 of 87


  • Page 48

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 45: Flow duration curves for October Page 42 of 87


  • Page 49

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 46: Flow duration curves for November Page 43 of 87


  • Page 50

    01 January 2013 00:15:00 to 01 January 2014 00:00:00 2 MONTHLY Figure 47: Flow duration curves for December Page 44 of 87

  • View More

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