Perth - Moncreiffe and Craigie circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 11:50:00 | 11:50:00 | ... | 1 |
|
| ... | 11:50:00 | 11:50:00 | ... | 2 |
|
| ... | 11:51:00 | 11:51:00 | ... | 3 |
|
| ... | 11:52:00 | 11:52:00 | ... | 4 |
|
| ... | 11:54:00 | 11:54:00 | ... | 5 |
|
| ... | 11:55:00 | 11:55:00 | ... | 6 |
|
| ... | 11:56:00 | 11:56:00 | ... | 7 |
|
| ... | 11:57:00 | 11:57:00 | ... | 8 |
|
| ... | 11:58:00 | 11:58:00 | ... | 9 |
|
| ... | 11:58:00 | 11:58:00 | ... | 10 |
|
| ... | 12:00:00 | 12:00:00 | ... | 11 |
|
| ... | 12:00:00 | 12:00:00 | ... | 12 |
|
| ... | 12:01:00 | 12:01:00 | ... | 13 |
|
| ... | 12:02:00 | 12:02:00 | ... | 14 |
|
| ... | 12:02:00 | 12:02:00 | ... | 15 |
|
| ... | 12:03:00 | 12:03:00 | ... | 16 |
|
| ... | 12:03:00 | 12:03:00 | ... | 17 |
|
| ... | 12:04:00 | 12:04:00 | ... | 18 |
|
| ... | 12:04:00 | 12:04:00 | ... | 19 |
|
| ... | 12:06:00 | 12:06:00 | ... | 20 |
|
| ... | 12:06:00 | 12:06:00 | ... | 21 |
|
| ... | 12:07:00 | 12:07:00 | ... | 22 |
|
| ... | 12:08:00 | 12:08:00 | ... | 23 |
|
| ... | 12:09:00 | 12:09:00 | ... | 24 |
|
| ... | 12:10:00 | 12:10:00 | ... | 25 |
|
| ... | 12:11:00 | 12:11:00 | ... | 26 |
|
| ... | 12:12:00 | 12:12:00 | ... | 27 |
|
| ... | 12:14:00 | 12:14:00 | ... | 28 |
|
| ... | 12:16:00 | 12:16:00 | ... | 29 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 20/04/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 73784357 | Glenturret Terrace | 56.3790392007 | -3.4404199144 | |
| 73723694 | Mill Street | 56.3976380083 | -3.4334911519 | |
| 73724687 | Scott Street | 56.3939687811 | -3.4322192002 | |
| 73724674 | Scott Street | 56.3927375959 | -3.4322377687 | |
| 73724672 | Scott Street | 56.3958731886 | -3.4322583161 | |
| 73724945 | Shops | 56.3790010335 | -3.4359650619 | |
| 73724949 | Darnhall Drive | 56.3892540349 | -3.447479427 | |
| 73724638 | Glenartney Terrace | 56.379619678 | -3.4422718033 | |
| 73725486 | Kings Place | 56.3920804145 | -3.4362306337 | |
| 73723847 | St Leonards Bank | 56.3916571437 | -3.4370894739 | |
| 73723485 | Post Office | 56.3898065218 | -3.4393847798 | |
| 73724654 | Post Office | 56.3892947775 | -3.4393492714 | |
| 73724864 | Glenearn Community Campus | 56.386692276 | -3.4390729088 | |
| 73724857 | Glenearn Carpets | 56.3853953149 | -3.4370155674 | |
| 73724932 | Edwards Engineering | 56.383463424 | -3.4362463734 | |
| 73725634 | Glenlyon Road | 56.3822681381 | -3.437043553 | |
| 73724647 | Craigie Road | 56.3809845873 | -3.4361530709 | |
| 73724645 | Glenfarg Terrace | 56.3776555416 | -3.434991397 | |
| 73724376 | Quarry | 56.3779600632 | -3.4381768281 | |
| 73723836 | Glendevon Road | 56.380295829 | -3.4451638368 | |
| 73723876 | Glenlochy Road | 56.3814172409 | -3.4445423022 | |
| 73723939 | Craigie Knowes Road | 56.3828556762 | -3.4452445949 | |
| 73724293 | Craigie Knowes Avenue | 56.3842066388 | -3.4449718393 | |
| 73724374 | Knowelea Terrace | 56.3866299541 | -3.4444319215 | |
| 73724287 | Abbot Crescent | 56.3878972869 | -3.4459377287 | |
| 73724375 | Needless Road | 56.3903517011 | -3.4450426229 | |
| 73724947 | Parish Church | 56.3891088511 | -3.4437482547 | |
| 73728682 | King Street | 56.3935376656 | -3.4345358664 |