brnstz / bus

Mobile web app for discovering public transit in NYC --
https://token.live
MIT License
5 stars 2 forks source link

Add Staten Island Ferry partner / feed #99

Closed brnstz closed 8 years ago

brnstz commented 8 years ago

http://www.nyc.gov/html/dot/html/about/datafeeds.shtml

http://www.nyc.gov/html/dot/downloads/misc/siferry-gtfs.zip

brnstz commented 8 years ago

Almost working but:

brnstz commented 8 years ago

We need one stop for each direction, which would probably fix both issues above:

bseitz=# select * from stop where agency_id = 'NYC DOT';
-[ RECORD 1 ]+---------------------------------------------------
agency_id    | NYC DOT
stop_id      | stgeorge
stop_name    | St. George Ferry Terminal
direction_id | 1
headsign     | To St. George
route_id     | SIF
location     | 0101000020E61000006B0C3A2174524440446FF1F09E8452C0
-[ RECORD 2 ]+---------------------------------------------------
agency_id    | NYC DOT
stop_id      | whitehall
stop_name    | Whitehall Ferry Terminal
direction_id | 1
headsign     | To St. George
route_id     | SIF
location     | 0101000020E61000007D5C1B2AC65944405AF10D85CF8052C0