Perth - Spittalfield and Blairgowrie
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:55:00 | 09:55:00 | ... | 1 |
|
| ... | 09:55:00 | 09:55:00 | ... | 2 |
|
| ... | 09:55:00 | 09:55:00 | ... | 3 |
|
| ... | 09:56:00 | 09:56:00 | ... | 4 |
|
| ... | 09:56:00 | 09:56:00 | ... | 5 |
|
| ... | 09:57:00 | 09:57:00 | ... | 6 |
|
| ... | 09:57:00 | 09:57:00 | ... | 7 |
|
| ... | 09:59:00 | 09:59:00 | ... | 8 |
|
| ... | 10:02:00 | 10:02:00 | ... | 9 |
|
| ... | 10:03:00 | 10:03:00 | ... | 10 |
|
| ... | 10:03:00 | 10:03:00 | ... | 11 |
|
| ... | 10:04:00 | 10:04:00 | ... | 12 |
|
| ... | 10:05:00 | 10:05:00 | ... | 13 |
|
| ... | 10:05:00 | 10:05:00 | ... | 14 |
|
| ... | 10:05:00 | 10:05:00 | ... | 15 |
|
| ... | 10:06:00 | 10:06:00 | ... | 16 |
|
| ... | 10:06:00 | 10:06:00 | ... | 17 |
|
| ... | 10:07:00 | 10:07:00 | ... | 18 |
|
| ... | 10:08:00 | 10:08:00 | ... | 19 |
|
| ... | 10:08:00 | 10:08:00 | ... | 20 |
|
| ... | 10:12:00 | 10:12:00 | ... | 21 |
|
| ... | 10:12:00 | 10:12:00 | ... | 22 |
|
| ... | 10:15:00 | 10:15:00 | ... | 23 |
|
| ... | 10:16:00 | 10:16:00 | ... | 24 |
|
| ... | 10:17:00 | 10:17:00 | ... | 25 |
|
| ... | 10:18:00 | 10:18:00 | ... | 26 |
|
| ... | 10:20:00 | 10:20:00 | ... | 27 |
|
| 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 | |
|---|---|---|---|---|
| 73723696 | Mill Street | 56.3976419397 | -3.433151055 | |
| 73724834 | Holiday Inn | 56.4163714259 | -3.4612666909 | |
| 73726724 | Cross | 56.4803360505 | -3.4490621638 | |
| 73736893 | Luncarty House | 56.4490257825 | -3.4648888981 | |
| 73726563 | Scarth Road | 56.4497357721 | -3.4709516999 | |
| 73726587 | Church Hall | 56.484623147 | -3.4520349919 | |
| 73724854 | Royal Bank of Scotland | 56.4017628345 | -3.4396416652 | |
| 73724848 | Retail Park | 56.4007906842 | -3.4382438678 | |
| 73724843 | Southbound Bus Bay | 56.4396480033 | -3.472248829 | |
| 73724838 | Bute Drive | 56.4146521412 | -3.4584775818 | |
| 73724835 | Duncansby Way | 56.4084347953 | -3.4492449297 | |
| 73724842 | ASDA | 56.4053867437 | -3.4448021993 | |
| 73765738 | NISA | 56.4530977092 | -3.4685504217 | |
| 73726546 | Russell Street | 56.4838373515 | -3.4493093158 | |
| 73726543 | East Brougham Street | 56.4823997605 | -3.4508458544 | |
| 73726574 | Marshall Way | 56.4522516725 | -3.4701889962 | |
| 73726726 | Hatton Place | 56.4505598507 | -3.4635688437 | |
| 73726592 | Hatton Place | 56.4505277514 | -3.4632431149 | |
| 73727525 | Denmarkfield | 56.4364663336 | -3.4730827164 | |
| 73728324 | House No 159 | 56.4848655752 | -3.4512810045 | |
| 73727695 | Marshall Crescent | 56.4525897388 | -3.4651558925 | |
| 73727697 | Marshall Crescent | 56.4527244549 | -3.4651610793 | |
| 73727825 | Milton Road | 56.4551985584 | -3.4709681507 | |
| 73727826 | Benchill View | 56.478671969 | -3.4499891728 | |
| 73727829 | Linn Road | 56.4827653256 | -3.4472386365 | |
| 73728527 | Gowrie Farm | 56.4668043875 | -3.4559806665 | |
| 73727694 | Hatton Road | 56.4481634307 | -3.4633469026 |