Skip to content
This repository has been archived by the owner on Oct 30, 2019. It is now read-only.

Bus Stop 10215 (Government center) returned errors #37

Open
ErnieAtLYD opened this issue Apr 15, 2014 · 2 comments
Open

Bus Stop 10215 (Government center) returned errors #37

ErnieAtLYD opened this issue Apr 15, 2014 · 2 comments
Assignees
Labels

Comments

@ErnieAtLYD
Copy link

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

  • BUS 208 AT 10215
  • BUS 1 AT 10215
@aramonc
Copy link
Contributor

aramonc commented Apr 15, 2014

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
Copy link
Contributor

aramonc commented Apr 15, 2014

For example: Bus 208 at 1241 will work

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

3 participants