At the Children’s Hospital of Pittsburgh’s Primary Care Center in Oakland many patients rely on public transit for transportation to and from their doctor appointment. To support physician researcher Dr. Ana Malinow in investigating the extent to which long travel times negatively impact appointment keeping, I created an ArcMap accessibility utility to estimate the time in transit to reach the Oakland clinic from any location in Allegheny county. Compared with using Google Maps or another travel planning service, the ArcMap accessibility utility 1) can estimate thousands of travel timesContinue Reading “Transit Time to Clinic”

Having previously established that Pittsburgh’s buses do bunch and a technical platform for archiving and accessing historic bus service data, I sought to extend this inquiry by quantifying aspects of frequency, timing, and location of bus bunching. The resulting project is available online at: Dataset Vehicle locations for all buses servicing routes 61, 71, P1, and G2 were recorded once every sixty seconds throughout the month of March, 2016, resulting in a dataset of some 1.5m records of timestamped bus locations. Each location dataContinue Reading “The When and Where of Pittsburgh’s Bunched Buses”

It’s a bit messy (time constraints!) but I recently put together a simple web page that displays the average time between bus arrivals for any PAAC Route 61A/61B/61C/61D stop. It also shows the average wait time, and the excess wait times caused by variance in arrival time spacing. This website can be accessed at the following link:

What began as a casual observation that Pittsburgh’s buses, when running late, often arrive in pairs turned into a data warehouse and empirical investigation. Fellow students Bhavna, Ranjana, Rohita, Enbo and I built a data warehouse to capture the real-time bus location data published by the Port Authority of Allegheny County. Our analysis of the data revealed that, indeed, buses do tend to “bunch.” I’m excited to share that this project and its results are currently features on the CMU Students for Urban Data Analytics website.Continue Reading “Pittsburgh Bus Bunching Project Features on CMU Students for Urban Data Analytics Website”