Interact with the map yourself here
Each water system that is in violation has two vertical bars, the blue one represents the allowed contaminant level and the gray bar represents the percentage overage measured most recently. Clicking on the map marker with the analyte name opens the history view info box which shows all the available previous measurements. If there were multiple violations related to different analytes the info box view will show multiple bar graphs, one for each analyte.
This project was built at Open Oakland Hack nights. Aaron and Yotam attended the Safe Drinking Water Challenge kickoff event in San Francisco. There we met Rucker and started working on a small project to help the Community Water Center get better visibility into the Human Right to Water dataset. The Community Water Center had a VBscript that they used to format the HR2W data. That script stopped working probably due to a data format change. We reimplemented that logic in javascript and put that on a glitch site. It was deduplicating water systems, grabbing the latest violation for each unique system and analyte. We augmented that by flagging systems that were within the Tulare Basin because the Community Water Center were particularly interested in that area.
When we expanded the challenge project into creating an interactive map that made it more obvious which systems were massively exceeding the allowed contaminant levels we created the map you see above. Robert contributed significant data science support. His code in python and all the code for the map is in this open source (MIT licensed) repository
Several Open Oakland attendees contributed advice and helped us hack on this. It was cool meeting Justin who provided deep water treatment expertise and Peter who quickly hacked some datasets in javascript.
Full analysis with the python code to generate the above graphs is on github
This project was buit at Open Oakland Hack nights
