Perth - Letham and Tulloch circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 23:20:00 | 23:20:00 | ... | 1 |
|
| ... | 23:20:00 | 23:20:00 | ... | 2 |
|
| ... | 23:21:00 | 23:21:00 | ... | 3 |
|
| ... | 23:22:00 | 23:22:00 | ... | 4 |
|
| ... | 23:23:00 | 23:23:00 | ... | 5 |
|
| ... | 23:24:00 | 23:24:00 | ... | 6 |
|
| ... | 23:25:00 | 23:25:00 | ... | 7 |
|
| ... | 23:27:00 | 23:27:00 | ... | 8 |
|
| ... | 23:27:00 | 23:27:00 | ... | 9 |
|
| ... | 23:28:00 | 23:28:00 | ... | 10 |
|
| ... | 23:29:00 | 23:29:00 | ... | 11 |
|
| ... | 23:30:00 | 23:30:00 | ... | 12 |
|
| ... | 23:31:00 | 23:31:00 | ... | 13 |
|
| ... | 23:32:00 | 23:32:00 | ... | 14 |
|
| ... | 23:32:00 | 23:32:00 | ... | 15 |
|
| ... | 23:33:00 | 23:33:00 | ... | 16 |
|
| ... | 23:33:00 | 23:33:00 | ... | 17 |
|
| ... | 23:33:00 | 23:33:00 | ... | 18 |
|
| ... | 23:34:00 | 23:34:00 | ... | 19 |
|
| ... | 23:35:00 | 23:35:00 | ... | 20 |
|
| ... | 23:35:00 | 23:35:00 | ... | 21 |
|
| ... | 23:35:00 | 23:35:00 | ... | 22 |
|
| ... | 23:36:00 | 23:36:00 | ... | 23 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 13/08/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 73725273 | Mill Street | 56.3975122623 | -3.4342641246 | |
| 73723734 | Royal Infirmary | 56.3974807857 | -3.4554714765 | |
| 73723232 | Upper Rannoch Roundabout | 56.401779976 | -3.4763928787 | |
| 73723473 | Langside Road | 56.4067714284 | -3.476002768 | |
| 73723856 | Western Avenue | 56.3971858208 | -3.4515069335 | |
| 73725629 | Leisure Pool | 56.3955335276 | -3.4429545814 | |
| 73723459 | Garth Avenue | 56.4063711359 | -3.4711254848 | |
| 73725297 | Milton Road | 56.4066062657 | -3.4725120723 | |
| 73725324 | Strathtay Road | 56.4062306378 | -3.4685757401 | |
| 73725325 | Fortingall Place | 56.4056066374 | -3.465877777 | |
| 73723274 | Primary School | 56.4038313655 | -3.4678351249 | |
| 73723256 | Our Ladys Primary School | 56.4041256116 | -3.4718166745 | |
| 73723252 | Struan Road | 56.4043868892 | -3.4755377304 | |
| 73723768 | Cluny Terrace | 56.403718265 | -3.4773592034 | |
| 73725265 | Welcome Inn | 56.4016817292 | -3.4725649404 | |
| 73725269 | Day Centre | 56.401209801 | -3.4684147589 | |
| 73725295 | Dunsinane Drive | 56.4007264457 | -3.4652202524 | |
| 73724392 | Letham Road | 56.4000412033 | -3.4608514557 | |
| 73725323 | Goodlyburn Place | 56.3986730836 | -3.4572344631 | |
| 73725632 | Elibank Street | 56.3954461452 | -3.4404238855 | |
| 73725647 | York Place | 56.3953486343 | -3.4372123714 | |
| 73724657 | South Methven Street | 56.3960468152 | -3.4343386223 | |
| 73726796 | Rosslyn House | 56.3956544332 | -3.4464586397 |