Texas Water Quality Visualization/Map (opens in new tab)
I built a tool that maps all of the water systems in Texas and lets you explore the water quality, check out the guided tour to see a drilldown on one community. The state makes this data available but publishes it as 225,000 individual Word documents behind a search form. I scraped the data, converted it to structured data, geocoded each system, and put it all on a map. There's also a flat 600k-row CSV for people to analyze the data themselves.[Link
Read the original article