Client: Friends of Sligo Creek
Project: Interactive map showing water-quality data results at various locations along an urban stream that flows through southern Montgomery County, Md.
Solution: Used Python and Tableau to create an interactive map that shows water-quality test results and relative rankings for eight testing locations.
More: Friends of Sligo Creek (FOSC) is a nonprofit group dedicated to protecting, improving, and appreciating the ecological health of Sligo Creek and its surrounding park and watershed. Sligo Creek is a tributary of the Northwest Branch of the Anacostia River (which flows into the Potomac River, which, in turn, leads to the Chesapeake Bay). Flowing primarily through Montgomery County, Md., Sligo Creek has an intensely urban watershed and is subject to numerous environmental pressures, including unhealthily high levels of Escherichia coli (E. coli), a bacteria that is typically an indicator of contamination by sewage and/or animal waste.
FOSC volunteers conduct water-quality testing at several locations along the creek; this project converts site-specific testing results as reported by FOSC into a clickable map that leads to pages for each site showing site data; site photo; and site rankings compared to other sites.
Main screen with clickable map
Screen showing data for individual testing site
Comprehensive design packages for government and nonprofit institutions.