Department of Public Works

| Current Road Stats

Overlay Year vs. Road Condition

Welcome, please view this site on a tablet or desktop to see more information including interactive scatter plot charts



Current Pavement Type


About Me

My picture

I'm a web developer living in NY. Check out some random things here on my codepen.io account.


I also have a GitHub account and a personal webpage you can visit.

What I Used

Here are some things I used that allowed me to create this project.


  • Atom and Sublime Text Atom had some packages Sublime Text didn't and vice versa. Atom Beautify, Emmet, and Sublime's excellent multi-line selection support were life savers when working with 7,000+ rows of data. For most of the charts I copied whole columns of data and then used the COUNTIF function in Google Sheets to add up the amounts for the graphs.

  • Google Maps API Google Maps API is a deep awesome API with a lot of options and customization.

  • Other Google Apps! Google Fusion Tables, Google Sheets mainly.

  • Chart.Js An easy to use Javascript library to map data to various styles of chart.

  • D3js An extremely deep Javascript library to display data. I started working with this and realized it at times was too deep and Chart.Js was better suited for this project. Still neat to learn about and see. Check out some amazing examples here.

  • tauCharts D3js chart API that allows interactive elements and labels seen on the scatter plot. It's pretty cool but can be hard to find information on when facing an issue. See it here.

  • List.Js Sorting and searching through list made fast and easy.

  • Bootstrap Responsive webpages are created faster using Bootstrap. Knowing bootstrap class names saves a lot of time, too.