Perth - Letham and Tulloch circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:46:00 | 09:46:00 | ... | 1 |
|
| ... | 09:46:00 | 09:46:00 | ... | 2 |
|
| ... | 09:46:00 | 09:46:00 | ... | 3 |
|
| ... | 09:47:00 | 09:47:00 | ... | 4 |
|
| ... | 09:48:00 | 09:48:00 | ... | 5 |
|
| ... | 09:49:00 | 09:49:00 | ... | 6 |
|
| ... | 09:49:00 | 09:49:00 | ... | 7 |
|
| ... | 09:50:00 | 09:50:00 | ... | 8 |
|
| ... | 09:51:00 | 09:51:00 | ... | 9 |
|
| ... | 09:52:00 | 09:52:00 | ... | 10 |
|
| ... | 09:53:00 | 09:53:00 | ... | 11 |
|
| ... | 09:53:00 | 09:53:00 | ... | 12 |
|
| ... | 09:53:00 | 09:53:00 | ... | 13 |
|
| ... | 09:54:00 | 09:54:00 | ... | 14 |
|
| ... | 09:55:00 | 09:55:00 | ... | 15 |
|
| ... | 09:56:00 | 09:56:00 | ... | 16 |
|
| ... | 09:57:00 | 09:57:00 | ... | 17 |
|
| ... | 09:57:00 | 09:57:00 | ... | 18 |
|
| ... | 09:58:00 | 09:58:00 | ... | 19 |
|
| ... | 09:59:00 | 09:59:00 | ... | 20 |
|
| ... | 10:00:00 | 10:00:00 | ... | 21 |
|
| ... | 10:01:00 | 10:01:00 | ... | 22 |
|
| ... | 10:02:00 | 10:02:00 | ... | 23 |
|
| ... | 10:03:00 | 10:03:00 | ... | 24 |
|
| ... | 10:04:00 | 10:04:00 | ... | 25 |
|
| ... | 10:05:00 | 10:05:00 | ... | 26 |
|
| ... | 10:07:00 | 10:07:00 | ... | 27 |
|
| ... | 10:08:00 | 10:08:00 | ... | 28 |
|
| ... | 10:09:00 | 10:09:00 | ... | 29 |
|
| ... | 10:11:00 | 10:11:00 | ... | 30 |
|
| ... | 10:12:00 | 10:12:00 | ... | 31 |
|
| 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 | |
| 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 | |
| 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 | |
| 73724734 | Newton House | 56.4115840514 | -3.466448034 |