Rothesay - Ballochgoy and Bush circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:15:00 | 09:15:00 | ... | 1 |
|
| ... | 09:16:00 | 09:16:00 | ... | 2 |
|
| ... | 09:16:00 | 09:16:00 | ... | 3 |
|
| ... | 09:18:00 | 09:18:00 | ... | 4 |
|
| ... | 09:19:00 | 09:19:00 | ... | 5 |
|
| ... | 09:19:00 | 09:19:00 | ... | 6 |
|
| ... | 09:19:00 | 09:19:00 | ... | 7 |
|
| ... | 09:20:00 | 09:20:00 | ... | 8 |
|
| ... | 09:21:00 | 09:21:00 | ... | 9 |
|
| ... | 09:22:00 | 09:22:00 | ... | 10 |
|
| ... | 09:23:00 | 09:23:00 | ... | 11 |
|
| ... | 09:23:00 | 09:23:00 | ... | 12 |
|
| ... | 09:24:00 | 09:24:00 | ... | 13 |
|
| ... | 09:24:00 | 09:24:00 | ... | 14 |
|
| ... | 09:24:00 | 09:24:00 | ... | 15 |
|
| ... | 09:25:00 | 09:25:00 | ... | 16 |
|
| ... | 09:26:00 | 09:26:00 | ... | 17 |
|
| ... | 09:26:00 | 09:26:00 | ... | 18 |
|
| ... | 09:27:00 | 09:27:00 | ... | 19 |
|
| ... | 09:28:00 | 09:28:00 | ... | 20 |
|
| ... | 09:28:00 | 09:28:00 | ... | 21 |
|
| ... | 09:30:00 | 09:30:00 | ... | 22 |
|
| ... | 09:30:00 | 09:30:00 | ... | 23 |
|
| ... | 09:30:00 | 09:30:00 | ... | 24 |
|
| ... | 09:31:00 | 09:31:00 | ... | 25 |
|
| ... | 09:32:00 | 09:32:00 | ... | 26 |
|
| ... | 09:33:00 | 09:33:00 | ... | 27 |
|
| ... | 09:33:00 | 09:33:00 | ... | 28 |
|
| ... | 09:34:00 | 09:34:00 | ... | 29 |
|
| ... | 09:35:00 | 09:35:00 | ... | 30 |
|
| ... | 09:35:00 | 09:35:00 | ... | 31 |
|
| ... | 09:36:00 | 09:36:00 | ... | 32 |
|
| ... | 09:38:00 | 09:38:00 | ... | 33 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 21/09/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 54726573 | Castle Street | 55.836364132 | -5.053230789 | |
| 54726862 | King's Mill | 55.8348304157 | -5.0577908227 | |
| 54726962 | Waverley Avenue | 55.8326460769 | -5.0635611923 | |
| 54727274 | Caledonia Walk | 55.8333007397 | -5.0625425027 | |
| 54727374 | Hillhouse Road | 55.8363785646 | -5.0591584382 | |
| 54727959 | Glebe Terrace | 55.8334347173 | -5.053544134 | |
| 54725685 | Foley Road | 55.831508746 | -5.05146042 | |
| 54723835 | Guildford Square | 55.8376356635 | -5.0537937976 | |
| 54723825 | Cemetery | 55.827955287 | -5.0566280527 | |
| 54723826 | Cemetery | 55.8284281806 | -5.0564096349 | |
| 54724798 | Victoria Hospital | 55.8303046909 | -5.0561416647 | |
| 54723839 | Foley Road | 55.8305892308 | -5.0515640483 | |
| 54723834 | The Ritz | 55.8347504331 | -5.0548613401 | |
| 54723832 | Ministers Brae junction | 55.8339549412 | -5.0550385201 | |
| 54724823 | Russell Street | 55.8350030965 | -5.0551846706 | |
| 54724893 | Gowanfield Terrace | 55.8338673416 | -5.0603667671 | |
| 54723787 | Gowanfield Terrace | 55.8333218709 | -5.060611406 | |
| 54723758 | Waverley Avenue | 55.8326030362 | -5.0638453182 | |
| 54723764 | Caledonia Walk | 55.8333661606 | -5.0628032208 | |
| 54723767 | Robertson Drive | 55.834279654 | -5.0622201706 | |
| 54723796 | St Andrews Church | 55.8357655935 | -5.0585032481 | |
| 54723795 | Hillhouse Road | 55.8365107654 | -5.0592646745 | |
| 54723756 | Blain Terrace | 55.8368983267 | -5.0649980961 | |
| 54724957 | St Brides Road | 55.8375934292 | -5.0634393553 | |
| 54723759 | Prospect Terrace | 55.8361723282 | -5.0641901366 | |
| 54723765 | Bowling Club | 55.8362280197 | -5.0626769507 | |
| 54723824 | St Johns Hall | 55.8372659742 | -5.057454974 | |
| 54724724 | Victoria Hospital | 55.8303529744 | -5.056369062 | |
| 54724729 | Victoria Hospital Annexe | 55.8266545779 | -5.0568773056 | |
| 54724734 | Rothesay Academy Joint Campus | 55.8255743536 | -5.0569362419 | |
| 54725483 | Wallace Avenue | 55.8299011166 | -5.0546565566 | |
| 54725749 | Foley Park | 55.8329212038 | -5.051778774 |