
π This won an award at the 2019 California Water Data Challenge.
π Congrats to the #CAWaterDataChallenge participants, the @westbigdatahub organizing team, and all the folks at @CA_DWR and @CaWaterBoards that make this event possible!
— Rich Pauloo (@RichPauloo) October 21, 2019
And thanks for the comically large check π΅π !
π§ https://t.co/2ZIgIerDea π
βοΈview my project here https://t.co/7WPfdGGzzv pic.twitter.com/dc1kcw8V0V
Summary
Present sources of water quality information in California (i.e. - consumer confidence reports, or CCRs) are fragmented across thousands of water utilities in the state, lack consistency and clarity, and tend to communicate data via hard-to-understand tables (see 3 examples of CCRs below, or view them in their entirely1.).

Near-real-time, standardized, and easy to understand water quality reports would improve the publicβs understanding of the water they buy and consume. Automated creation of water quality reports would ease reporting responsibilities for water agencies, freeing them to tackle harder problems.
This project aimed to build a βweather appβ for California community water system water quality. The benefits of this approach include standardization, consistency across agencies, ease of use, and near-real-time water quality information.
The project aggregates publicly available water quality data for all California community water systems to report:
- compliance status
- chemicals detected within the past 2 years
- average detection levels for all contaminants tested for
- water quality indicators
- local water and health system contact information