Traffic charts for my commute
When I changed jobs, my commute changed from mostly surface streets to mostly highway. I-80 is notoriously congested and I wanted to strategically plan my commute to avoid as much traffic as possible.
I started by watching traffic online and then found Traffic.com, where I could create custom drives and receive alerts, etc. Pretty cool...but I wanted a way to SEE traffic trends, so I designed a way to get data from Traffic.com and to then display that data in a graph.
Traffic.com offers a RSS feed, so my plan was to use data from that feed to generate the graphs. So, I signed up at Traffic.com and created two custom drives; "Home to Work" and "Work to Home". Next I created a database and tables to hold the data:














