CodeforSouth / mdt-bus-sms

:sleeping: TextMyBusMIA: SMS Interface for Miami Dade Transit Bus Systems.
http://codefor.miami/mdt-bus-sms/
MIT License
7 stars 7 forks source link

Bus Stop 10215 (Government center) returned errors #37

Open ErnieAtLYD opened 10 years ago

ErnieAtLYD commented 10 years ago

Hey Adrian, when I tried to do any of the following it gave me "There was an error fetching the route information"

aramonc commented 10 years ago

le sigh (at MDT)

Because even though Google says that the 208 stops there, according to the GTFS DATA, it doesn't.

  1. Download http://gtfs.s3.amazonaws.com/miami-dade-transit_20140115_0120.zip
  2. Open trips.txt (preferably in something that recognizes CSV)
  3. Search for 14415
  4. Copy one of the values from the trip_id column
  5. Open stop_times.txt
  6. Search for the trip_id copied from 4 above
  7. Search 10215 in the stop_id columns.

Alternatively (& could someone better at SQL can verify the query?) connect to the DB & run this query:

SELECT stop_times., routes. FROM stop_times LEFT JOIN trips ON stop_times.trip_id = trips.trip_id LEFT JOIN routes ON trips.route_id = routes.route_id WHERE trips.route_id = 14415 GROUP BY stop_times.stop_id

So either Google never updates their data, MDT is giving them different data, or they're having fun with the GTFS data publicly available :P

PS: The link for the data is retrieved weekly from http://www.gtfs-data-exchange.com/agency/miami-dade-transit/

aramonc commented 10 years ago

For example: Bus 208 at 1241 will work

Stop 1241 is https://goo.gl/maps/8Ofrg