The other day I worked on a project at work that I found really exciting, and I wanted to talk about it here.
My coworker was working on a project to identify how garbage routes affect transit reliability. As part of that, they needed to assign each bus stop to a trash pick-up day. [1] They started with a shapefile published on the City’s website, but it didn’t work for bus stops that were on the borders of two zones.
For those, they needed to use the City of Philadelphia’s trash and recycling day tool to identify the correct day. This was really labor intensive, but I started asking them about it and figured that this could probably be automated with some API calls. I had them export the list of 500 bus stops that were on the border of two zones and I got to work.
Using my knowledge of front-end from my days as a junior engineer, I tracked down the API that was used to fetch this data.


