What is this? What does it mean?
This map was created in order to make localized data on lead contamination of United States public water sources available to the public. Such contamination stems from corrosion of old lead and copper plumbing fixtures that may be part of a building’s plumbing or the public water system’s service line. Contamination in a public water system may affect residents of a single building or those of an entire municipality.
Ingestion of lead has been known for millennia to cause serious harm to the neurological system, even in barely detectable amounts. The human body does not have a mechanism to process lead and remove it as waste. Instead it bio-accumulates in the brain and causes permanent harm to mental faculties in proportion to the amount present in the body. For this reason, even a miniscule amount in drinking water can have serious effects over a long period of regular consumption. These effects are especially pronounced in children and can cause lifelong damage. In view of this, the Environmental Protection Agency (EPA) has mandated that a concentration of 15 mg/L (parts-per-billion) of Lead and 1300 mg/L (parts-per-billion) of Copper be deemed an ‘action level’. Detections above this level demand that corrective action be taken in the form of water treatment, replacement of pipes, or in other forms. In addition, regular monitoring of Lead and Copper concentrations are made until the concentration of contaminants falls below the action level.
On the map, public water systems are clustered in the blue circular markers with the number of markers printed in black in order to avoid visually cluttering the map. If you zoom in or click on the blue circular marker, you will be able to view individual public water systems. These are represented by color-coded faucet icons. A red faucet indicates that the public water system is out of compliance and that its highest recorded concentration of lead or copper since the system was deemed out of compliance with the Lead and Copper Rule was above the action level. A yellow faucet indicates that the public water system is out of compliance and that lead has been detected in concentrations below the action level since it was deemed out of compliance with the Lead and Copper Rule. A green faucet indicates that the public water system has returned to compliance or that Lead or Copper have never been detected. The map was designed to intentionally bring attention to those ‘yellow faucet’ systems where lead has been detected but has not risen above the action level. Because tap water is used in so many ways and so much of it is consumed in the household, no level of lead contamination should be considered safe.
Finally, the contact information for your local public water service administrator is provided. If you are in an area with contaminated public water, please consider contacting these people to voice your outrage and improve the health of your community.
How was this made?
The data for this project was compiled from various reports requested through the EPA’s Safe Drinking Water Information System (SDWIS) Federal Reports Advanced Search. From this data portal, three types of reports were required to retrieved the complete data. The site data was pulled from Water System Reports; locational information (such as the city and state) and contact information for the manager of the public water system were taken from the Water System Detail Report; and results of chemical analysis for Lead and Copper concentrations were pulled from the Lead and Copper Reports. All of the reports for a sampling period ending on New Years Eve 2014 or later were retrieved, giving an effective coverage date of mid-2014 to the present.
The data was then compiled with a series of python scripts that joined the data from each reports using the public water systems ID number as a key. Unwanted data was culled and usable data was reformatted in a dictionary container for each of the public water system. Another python script was used to compare the date of each concentration result to the date the system returned to compliance and then to find the highest result that occurred after the return to compliance and code it as clean (green), below action level (yellow), or above action level (red)above action level (red). Because longitude and latitude coordinates were not supplied by the EPA, I geocoded the sites using the available locational information (place name, city, state, zip code) using GoogleMaps API. To handle the quantity of data, it was necessary to make API requests through a separate python script. Initially, this did not produce very reliable results because of the poor quality of place name data supplied. In order to introduce some degree of quality control, I compared the first three digits of the EPA-supplied zip code with that returned by GoogleMaps. If there was a match, the geocoded coordinates and address would be used. If no match occurred, I made a separate geocoding request for the coordinates and address of the center of the EPA-supplied zipcode and used these results in the data. The coordinates, concentrations, contact information, public water system name & id, and compliance status were then formatted into a geoJSON format which would be readable by the mapping software used on the website. This created a single JSON file which contained all of the data for the 20,066 markers for public water systems. Click here to view the github repository for the data wrangling portion of this project.
How do I run it?
The run.py script uses only built-in modules with the exception of requests.
- On line 159, specify the Water System Summary report data you wish to use from SDWIS.
- On line 168, specify the Water System Detail report data from SDWIS. In most cases, the supplied file should have the all of the included sites. If, when running the script, the line that reads "Complete information was not found for the following x non-compliant id's:" indicates that a large number of water system details (x) were not found it may be wise to grab more water system details and append them to the "violations_detail" file.
- On lines 214-244, specify the Lead and Copper Report data you wish to use from SDWIS.
This will generate the GeoJSON "markers.json" file that can be easily mapped. See lines 64-139 of the contamiNation-page "index.html" file for an example of how to create a map, add the markers, add the popups, and cluster the markers.