wat21209.pdf (2.13 MB)

The “dirty dozen” of freshwater science: Detecting then reconciling hydrological data biases and errors

Download (2.13 MB)
journal contribution
posted on 17.03.2017, 10:57 by Robert Wilby, Nicholas Clifford, Paolo De Luca, Shaun Harrigan, John Hillier, Richard Hodgkins, Matthew F. Johnson, Tom K.R. Matthews, Conor Murphy, Simon Noone, Simon Parry, Christel Prudhomme, Stephen Rice, Louise Slater, Katie Smith, Paul Wood
Sound water policy and management rests on sound hydrometeorological and ecological data. Conversely, unrepresentative, poorly collected or erroneously archived data introduces uncertainty regarding the magnitude, rate and direction of environmental change, in addition to undermining confidence in decision-making processes. Unfortunately, data biases and errors can enter the information flow at various stages, starting with site selection, instrumentation, sampling/ measurement procedures, post-processing and ending with archiving systems. Techniques such as visual inspection of raw data, graphical representation and comparison between sites, outlier and trend detection, and referral to metadata can all help uncover spurious data. Tell-tale signs of ambiguous and/or anomalous data are highlighted using 12 carefully chosen cases drawn mainly from hydrology (‘the dirty dozen’). These include evidence of changes in site or local conditions (due to land management, river regulation or urbanisation); modifications to instrumentation or inconsistent observer behaviour; mismatched or misrepresentative sampling in space and time; treatment of missing values, post-processing and data storage errors. As well as raising awareness of pitfalls, recommendations are provided for uncovering lapses in data quality after the information has been gathered. It is noted that error detection and attribution are more problematic for very large data sets, where observation networks are automated, or when various information sources have been combined. In these cases, more holistic indicators of data integrity are needed that reflect the overall information life-cycle and application(s) of the hydrological data.

Funding

This paper was inspired by a capacity building program supported by the European Bank for Reconstruction and Development. Data for Exhibits #3, #5 and #12 are freely available from the UK NRFA. Other public data sources are acknowledged in Figure legends. Authors CP, KS, SH and SP are supported by the NERC-CEH Water Resources Science Area

History

School

  • Social Sciences

Department

  • Geography and Environment

Published in

Wiley Interdisciplinary Reviews (WIREs) Water

Citation

WILBY, R.L. ...et al., 2017. The “dirty dozen” of freshwater science: Detecting then reconciling hydrological data biases and errors. Wiley Interdisciplinary Reviews (WIREs) Water, 4 (3), e1209.

Publisher

Wiley

Version

VoR (Version of Record)

Publisher statement

This work is made available according to the conditions of the Creative Commons Attribution 4.0 International (CC BY 4.0) licence. Full details of this licence are available at: http://creativecommons.org/licenses/by/4.0/

Acceptance date

26/01/2017

Publication date

2017-03-24

Copyright date

2017

Notes

This is an open access article under the terms of the Creative Commons Attribution-NonCommercial License, which permits use, distribution and reproduction in any medium, provided the original work is properly cited and is not used for commercial purposes.

ISSN

2049-1948

Language

en

Licence

Exports

Logo branding

Licence

Exports