Running Boards

This SQL will allow you to make a running board of a particular block. SELECT route_id, gtfs_trips.trip_id, departure_time, stop_name, stop_headsign FROM gtfs_trips LEFT JOIN gtfs_stop_times ON gtfs_stop_times.trip_id = gtfs_trips.trip_id LEFT…

Read More

Metro’s GTFS data

Hello Developers! I haven’t introduced myself properly yet. I am a developer working for Metro’s Dept. of Creative Services. I will save a more general introduction for another post. But first I would like to dive into this discussion the GTFS data set. [more]

Read More

Interesting development in the Bay Area

There’s an interesting development in public data access playing out in the Bay Area. An favorite iPhone application called “Routesy” has ceased to function. Broken iPhone apps aren’t generally newsworthy except in this case the failure was caused by denial to public data.

Read More