Rothesay - Canada Hill circular anticlockwise
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:55:00 | 14:55:00 | ... | 1 |
|
| ... | 14:57:00 | 14:57:00 | ... | 2 |
|
| ... | 15:00:00 | 15:00:00 | ... | 3 |
|
| ... | 15:03:00 | 15:03:00 | ... | 4 |
|
| ... | 15:05:00 | 15:05:00 | ... | 5 |
|
| ... | 15:06:00 | 15:06:00 | ... | 6 |
|
| ... | 15:07:00 | 15:07:00 | ... | 7 |
|
| ... | 15:07:00 | 15:07:00 | ... | 8 |
|
| ... | 15:07:00 | 15:07:00 | ... | 9 |
|
| ... | 15:08:00 | 15:08:00 | ... | 10 |
|
| ... | 15:09:00 | 15:09:00 | ... | 11 |
|
| ... | 15:09:00 | 15:09:00 | ... | 12 |
|
| ... | 15:09:00 | 15:09:00 | ... | 13 |
|
| ... | 15:10:00 | 15:10:00 | ... | 14 |
|
| ... | 15:11:00 | 15:11:00 | ... | 15 |
|
| ... | 15:12:00 | 15:12:00 | ... | 16 |
|
| ... | 15:13:00 | 15:13:00 | ... | 17 |
|
| ... | 15:15:00 | 15:15:00 | ... | 18 |
|
| ... | 15:17:00 | 15:17:00 | ... | 19 |
|
| ... | 15:18:00 | 15:18:00 | ... | 20 |
|
| ... | 15:23:00 | 15:23:00 | ... | 21 |
|
| ... | 15:28:00 | 15:28:00 | ... | 22 |
|
| ... | 15:28:00 | 15:28:00 | ... | 23 |
|
| ... | 15:29:00 | 15:29:00 | ... | 24 |
|
| ... | 15:29:00 | 15:29:00 | ... | 25 |
|
| ... | 15:31:00 | 15:31:00 | ... | 26 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 14/10/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 54724854 | The Boathouse | 55.8397480532 | -5.0483680017 | |
| 54726765 | Russell Street | 55.8348762977 | -5.0552226409 | |
| 54726862 | King's Mill | 55.8348304157 | -5.0577908227 | |
| 54729363 | Suardale | 55.8427822068 | -5.0409207154 | |
| 54723836 | Guildford Square | 55.8377961116 | -5.053486885 | |
| 54723835 | Guildford Square | 55.8376356635 | -5.0537937976 | |
| 54723849 | Beattie Court | 55.8416103059 | -5.0450469513 | |
| 54723825 | Cemetery | 55.827955287 | -5.0566280527 | |
| 54723826 | Cemetery | 55.8284281806 | -5.0564096349 | |
| 54724798 | Victoria Hospital | 55.8303046909 | -5.0561416647 | |
| 54723827 | Swimming Pool | 55.8317600136 | -5.0565434054 | |
| 54723837 | Castle Street | 55.8362279656 | -5.0532840064 | |
| 54723834 | The Ritz | 55.8347504331 | -5.0548613401 | |
| 54723832 | Ministers Brae junction | 55.8339549412 | -5.0550385201 | |
| 54724823 | Russell Street | 55.8350030965 | -5.0551846706 | |
| 54723823 | King's Mill | 55.8346362018 | -5.0576477781 | |
| 54724893 | Gowanfield Terrace | 55.8338673416 | -5.0603667671 | |
| 54723787 | Gowanfield Terrace | 55.8333218709 | -5.060611406 | |
| 54723879 | Ardencraig Lane | 55.8411262722 | -5.0282499613 | |
| 54723843 | Roseland Caravan Park | 55.8329347919 | -5.046157348 | |
| 54724724 | Victoria Hospital | 55.8303529744 | -5.056369062 | |
| 54724729 | Victoria Hospital Annexe | 55.8266545779 | -5.0568773056 | |
| 54724734 | Rothesay Academy Joint Campus | 55.8255743536 | -5.0569362419 | |
| 54727528 | Glebe Terrace | 55.8334385524 | -5.0526659079 | |
| 54726834 | Suardale | 55.842672962 | -5.0409760872 |