Perth - Spittalfield and Blairgowrie
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:55:00 | 16:55:00 | ... | 1 |
|
| ... | 16:55:00 | 16:55:00 | ... | 2 |
|
| ... | 16:56:00 | 16:56:00 | ... | 3 |
|
| ... | 16:58:00 | 16:58:00 | ... | 4 |
|
| ... | 16:59:00 | 16:59:00 | ... | 5 |
|
| ... | 17:00:00 | 17:00:00 | ... | 6 |
|
| ... | 17:03:00 | 17:03:00 | ... | 7 |
|
| ... | 17:05:00 | 17:05:00 | ... | 8 |
|
| ... | 17:06:00 | 17:06:00 | ... | 9 |
|
| ... | 17:09:00 | 17:09:00 | ... | 10 |
|
| ... | 17:09:00 | 17:09:00 | ... | 11 |
|
| ... | 17:10:00 | 17:10:00 | ... | 12 |
|
| ... | 17:11:00 | 17:11:00 | ... | 13 |
|
| ... | 17:11:00 | 17:11:00 | ... | 14 |
|
| ... | 17:11:00 | 17:11:00 | ... | 15 |
|
| ... | 17:13:00 | 17:13:00 | ... | 16 |
|
| ... | 17:16:00 | 17:16:00 | ... | 17 |
|
| ... | 17:16:00 | 17:16:00 | ... | 18 |
|
| ... | 17:16:00 | 17:16:00 | ... | 19 |
|
| ... | 17:17:00 | 17:17:00 | ... | 20 |
|
| ... | 17:20:00 | 17:20:00 | ... | 21 |
|
| ... | 17:21:00 | 17:21:00 | ... | 22 |
|
| ... | 17:23:00 | 17:23:00 | ... | 23 |
|
| ... | 17:23:00 | 17:23:00 | ... | 24 |
|
| ... | 17:24:00 | 17:24:00 | ... | 25 |
|
| ... | 17:26:00 | 17:26:00 | ... | 26 |
|
| ... | 17:27:00 | 17:27:00 | ... | 27 |
|
| ... | 17:29:00 | 17:29:00 | ... | 28 |
|
| ... | 17:31:00 | 17:31:00 | ... | 29 |
|
| 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 | |
| 73723475 | Inveralmond House | 56.4166955175 | -3.4634999309 | |
| 73723928 | Holiday Inn | 56.4165623283 | -3.4618413701 | |
| 73726586 | Scarth Road | 56.4500300322 | -3.4711415429 | |
| 73726725 | Cross | 56.4801556707 | -3.4491202373 | |
| 73725436 | Spittalfield | 56.5514030836 | -3.4525419331 | |
| 73726535 | Church Hall | 56.4846657742 | -3.4522314915 | |
| 73724528 | Royal Bank of Scotland | 56.4025897628 | -3.4411636799 | |
| 73724234 | Barrack Street | 56.399796989 | -3.4371531885 | |
| 73723945 | Kinnoull Street | 56.3987331667 | -3.4328032045 | |
| 73723947 | Northbound Bus Bay | 56.4417952471 | -3.4722669821 | |
| 73728267 | Gowrie Farm | 56.466711341 | -3.4562530418 | |
| 73723929 | Bute Drive | 56.412738672 | -3.4561513597 | |
| 73723932 | Duncansby Way | 56.4082081827 | -3.4494145873 | |
| 73723782 | ASDA | 56.405168552 | -3.4450208052 | |
| 73769435 | Bankfoot road end | 56.5118310383 | -3.4596081824 | |
| 73723875 | Primary School | 56.5202732751 | -3.4660282521 | |
| 73723874 | Village Hall | 56.5293551057 | -3.466964431 | |
| 73723873 | Druids Park | 56.5316779605 | -3.4696069719 | |
| 73723872 | Broompark | 56.5341232854 | -3.4717667786 | |
| 73723878 | Bus Shelter | 56.5424991511 | -3.4837043672 | |
| 73723687 | Glendelvine Primary School | 56.5477414933 | -3.4689932713 | |
| 73726545 | East Brougham Street | 56.4825142383 | -3.4510450839 | |
| 73726723 | Kirkhill House | 56.4472378951 | -3.4732237734 | |
| 73726589 | Marshall Way | 56.4534704055 | -3.4704632455 | |
| 73726823 | Denmarkfield | 56.4369392501 | -3.4733605153 | |
| 73726857 | Boatlands | 56.5397185741 | -3.4833028614 | |
| 73727824 | Milton Road | 56.454560135 | -3.4710083768 | |
| 73729826 | Lynton Farm | 56.4913850157 | -3.4508315808 |