Perth - Letham and Tulloch circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 22:10:00 | 22:10:00 | ... | 1 |
|
| ... | 22:10:00 | 22:10:00 | ... | 2 |
|
| ... | 22:11:00 | 22:11:00 | ... | 3 |
|
| ... | 22:12:00 | 22:12:00 | ... | 4 |
|
| ... | 22:13:00 | 22:13:00 | ... | 5 |
|
| ... | 22:14:00 | 22:14:00 | ... | 6 |
|
| ... | 22:15:00 | 22:15:00 | ... | 7 |
|
| ... | 22:17:00 | 22:17:00 | ... | 8 |
|
| ... | 22:17:00 | 22:17:00 | ... | 9 |
|
| ... | 22:18:00 | 22:18:00 | ... | 10 |
|
| ... | 22:19:00 | 22:19:00 | ... | 11 |
|
| ... | 22:20:00 | 22:20:00 | ... | 12 |
|
| ... | 22:21:00 | 22:21:00 | ... | 13 |
|
| ... | 22:22:00 | 22:22:00 | ... | 14 |
|
| ... | 22:22:00 | 22:22:00 | ... | 15 |
|
| ... | 22:23:00 | 22:23:00 | ... | 16 |
|
| ... | 22:23:00 | 22:23:00 | ... | 17 |
|
| ... | 22:24:00 | 22:24:00 | ... | 18 |
|
| ... | 22:25:00 | 22:25:00 | ... | 19 |
|
| ... | 22:25:00 | 22:25:00 | ... | 20 |
|
| ... | 22:26:00 | 22:26:00 | ... | 21 |
|
| ... | 22:26:00 | 22:26:00 | ... | 22 |
|
| ... | 22:27:00 | 22:27:00 | ... | 23 |
|
| ... | 22:27:00 | 22:27:00 | ... | 24 |
|
| ... | 22:28:00 | 22:28:00 | ... | 25 |
|
| ... | 22:29:00 | 22:29:00 | ... | 26 |
|
| ... | 22:29:00 | 22:29:00 | ... | 27 |
|
| ... | 22:30:00 | 22:30:00 | ... | 28 |
|
| ... | 22:31:00 | 22:31:00 | ... | 29 |
|
| ... | 22:32:00 | 22:32:00 | ... | 30 |
|
| ... | 22:32:00 | 22:32:00 | ... | 31 |
|
| ... | 22:33:00 | 22:33:00 | ... | 32 |
|
| ... | 22:34:00 | 22:34:00 | ... | 33 |
|
| ... | 22:35:00 | 22:35:00 | ... | 34 |
|
| ... | 22:36:00 | 22:36:00 | ... | 35 |
|
| ... | 22:37:00 | 22:37:00 | ... | 36 |
|
| ... | 22:39:00 | 22:39:00 | ... | 37 |
|
| ... | 22:39:00 | 22:39:00 | ... | 38 |
|
| ... | 22:41:00 | 22:41:00 | ... | 39 |
|
| ... | 22:42:00 | 22:42:00 | ... | 40 |
|
| 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 | |
| 73723972 | Institute | 56.4080291286 | -3.4692122605 | |
| 73724574 | Kinnoull Street | 56.3984758906 | -3.4325180955 | |
| 73723672 | Crematorium | 56.4075375281 | -3.4712677368 | |
| 73723658 | Viewfield Place | 56.4037357077 | -3.444609993 | |
| 73723473 | Langside Road | 56.4067714284 | -3.476002768 | |
| 73723856 | Western Avenue | 56.3971858208 | -3.4515069335 | |
| 73725629 | Leisure Pool | 56.3955335276 | -3.4429545814 | |
| 73723682 | McDiarmid Park | 56.4075050659 | -3.4755125685 | |
| 73723674 | Unity Terrace | 56.4044709048 | -3.4516708512 | |
| 73724854 | Royal Bank of Scotland | 56.4017628345 | -3.4396416652 | |
| 73724848 | Retail Park | 56.4007906842 | -3.4382438678 | |
| 73724865 | Fairfield | 56.4054723311 | -3.4559224169 | |
| 73724953 | Bruce Crescent | 56.4069098335 | -3.4589916587 | |
| 73724247 | Tulloch Terrace | 56.4099309882 | -3.4611008115 | |
| 73723436 | Primary School | 56.4119009281 | -3.4624405741 | |
| 73724389 | Sandeman Court | 56.4136679122 | -3.4642265348 | |
| 73724239 | Newton Place | 56.4133538834 | -3.4672293244 | |
| 73724343 | Pullar Terrace | 56.4100183703 | -3.468916164 | |
| 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 | |
| 73724734 | Newton House | 56.4115840514 | -3.466448034 | |
| 73726796 | Rosslyn House | 56.3956544332 | -3.4464586397 |