Data Viz: Mapping D.C. #Potholepalooza 2016


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, 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, 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 Lead
DataWomen Event Recap: Work After COVID Earlier this month, we ran the second-ever panel for DataWomen. DataWomen is a data network that hosts regular webinars, runs a ...
Webinar Recap: Learning Best Practices in Tableau Tableau purchased Power Tools in 2019. Contact Us for more information. This week, Zion Spencer and I teamed up to host a webinar all ...

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


Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Geschäftsführer: Mel Stephenson

Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072