What Does 6,500 Bus Trips Look Like?
First, the data.
Many transit systems publish their schedule data in the General Transit Feed Specification (GTFS) format. These files describe all the system’s routes, stop locations, trips, and stop times. Mapping services like Google use these data to provide transit directions.
First, consider the routes. Port Authority has over 300. GTFS data includes a shapes table of the latitude and longitude point sequence for each route. To plot these, we used PostGIS to convert them into lines and exported them to GeoJSON. Using Leaflet and D3.js, Steve mapped them.
Mapping routes is only step one. There were numerous challenges to follow which are detailed in the full article about this project. The final product is pretty cool. Remember, all of this comes from data stored in numerous databases. Visualizing it is complicated to build, but simple to digest.