Data Viz: Mapping D.C. #Potholepalooza 2016

Data

Data Viz: Mapping D.C. #Potholepalooza 2016

Spring is here in D.C. For most people, that means any number of things – from the Cherry Blossom Festival, the Rock n’ Roll Marathon, patio dining or, for those as unlucky as I, horrendous seasonal allergies. But, there’s one recurring tradition from D.C. government that certainly deserves attention every spring … #Potholepalooza!

Started since 2009, #Potholepalooza is D.C.’s spring campaign to repair potholes at a faster turnaround time (within 48 hours of the request) than usual (72 hours). District residents can call 311, fill out a form at 311.dc.gov, tweet or send emails to report a pothole. As a city cyclist and Car2Go driver, I’m grateful for the work that D.C. pours into this campaign after all the wear and tear of the winter months. 

I pulled the data for all 2016 311 service requests from D.C.’s open data website, opendata.dc.gov. The open data website makes it easy to download all records in a CSV file. It was easy to find out just how many pothole service requests were called in and how many of those were called in during #Potholepalooza using Tableau. I also pulled D.C.’s ward shapefiles off of the open data site, and with Tableau’s 10.2 release, plotting the ward outlines on the map was a piece of cake! Explore the data below to look at 2016 data and keep your eyes peeled for the Mayor’s announcement for 2017’s #Potholepalooza! 

More About the Author

Debbie Yu

Analytics Consultant
Webinar Recap: Learning Best Practices in Tableau This week, Zion Spencer and I teamed up to host a webinar all about improving your Tableau Desktop and Server performance. In the ...
Open Data Viz: Portland Residential Construction Growth 1996-2016 Portland, Oregon, is no stranger to the construction increase happening in most major metropolitan cities across the city. On a recent ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK