Hatston - Clouston and Stromness Academy circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 13:30:00 | 13:30:00 | ... | 1 |
|
| ... | 13:30:00 | 13:30:00 | ... | 2 |
|
| ... | 13:30:00 | 13:30:00 | ... | 3 |
|
| ... | 13:31:00 | 13:31:00 | ... | 4 |
|
| ... | 13:33:00 | 13:33:00 | ... | 5 |
|
| ... | 13:35:00 | 13:35:00 | ... | 6 |
|
| ... | 13:37:00 | 13:37:00 | ... | 7 |
|
| ... | 13:38:00 | 13:38:00 | ... | 8 |
|
| ... | 13:38:00 | 13:38:00 | ... | 9 |
|
| ... | 13:39:00 | 13:39:00 | ... | 10 |
|
| ... | 13:39:00 | 13:39:00 | ... | 11 |
|
| ... | 13:39:00 | 13:39:00 | ... | 12 |
|
| ... | 13:40:00 | 13:40:00 | ... | 13 |
|
| ... | 13:41:00 | 13:41:00 | ... | 14 |
|
| ... | 13:42:00 | 13:42:00 | ... | 15 |
|
| ... | 13:43:00 | 13:43:00 | ... | 16 |
|
| ... | 13:44:00 | 13:44:00 | ... | 17 |
|
| ... | 13:45:00 | 13:45:00 | ... | 18 |
|
| ... | 13:46:00 | 13:46:00 | ... | 19 |
|
| ... | 13:47:00 | 13:47:00 | ... | 20 |
|
| ... | 13:47:00 | 13:47:00 | ... | 21 |
|
| ... | 13:48:00 | 13:48:00 | ... | 22 |
|
| ... | 13:48:00 | 13:48:00 | ... | 23 |
|
| ... | 13:49:00 | 13:49:00 | ... | 24 |
|
| ... | 13:49:00 | 13:49:00 | ... | 25 |
|
| ... | 13:50:00 | 13:50:00 | ... | 26 |
|
| ... | 13:50:00 | 13:50:00 | ... | 27 |
|
| ... | 13:51:00 | 13:51:00 | ... | 28 |
|
| ... | 13:51:00 | 13:51:00 | ... | 29 |
|
| ... | 13:52:00 | 13:52:00 | ... | 30 |
|
| ... | 13:53:00 | 13:53:00 | ... | 31 |
|
| ... | 13:54:00 | 13:54:00 | ... | 32 |
|
| ... | 13:55:00 | 13:55:00 | ... | 33 |
|
| ... | 13:57:00 | 13:57:00 | ... | 34 |
|
| ... | 13:59:00 | 13:59:00 | ... | 35 |
|
| ... | 14:00:00 | 14:00:00 | ... | 36 |
|
| ... | 14:02:00 | 14:02:00 | ... | 37 |
|
| ... | 14:04:00 | 14:04:00 | ... | 38 |
|
| ... | 14:06:00 | 14:06:00 | ... | 39 |
|
| ... | 14:11:00 | 14:11:00 | ... | 40 |
|
| ... | 14:13:00 | 14:13:00 | ... | 41 |
|
| ... | 14:14:00 | 14:14:00 | ... | 42 |
|
| ... | 14:15:00 | 14:15:00 | ... | 43 |
|
| ... | 14:17:00 | 14:17:00 | ... | 44 |
|
| ... | 14:17:00 | 14:17:00 | ... | 45 |
|
| ... | 14:18:00 | 14:18:00 | ... | 46 |
|
| ... | 14:20:00 | 14:20:00 | ... | 47 |
|
| ... | 14:27:00 | 14:27:00 | ... | 48 |
|
| ... | 14:32:00 | 14:32:00 | ... | 49 |
|
| ... | 14:38:00 | 14:38:00 | ... | 50 |
|
| ... | 14:40:00 | 14:40:00 | ... | 51 |
|
| ... | 14:41:00 | 14:41:00 | ... | 52 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 05/01/2015 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 67523495 | Allan's of Gillock | 59.0060152303 | -3.1144012137 | |
| 67523494 | Allan's of Gillock | 59.0062392478 | -3.1144606864 | |
| 67523479 | Brig O'Waithe | 58.9833123043 | -3.248106299 | |
| 67523482 | Brig O'Waithe | 58.983373643 | -3.2482651071 | |
| 67523625 | Hatston Park | 58.9910128653 | -2.9899788769 | |
| 67523497 | Bakie's Store | 59.0082225186 | -3.1219244642 | |
| 67523496 | Bakie's Store | 59.008292302 | -3.1211258309 | |
| 67523484 | Hatston Bus Garage | 58.9881233806 | -2.9766542109 | |
| 67523636 | Harray Road End | 59.0052071849 | -3.1533548576 | |
| 67523637 | Harray Road End | 59.005063838 | -3.1533152422 | |
| 67523639 | Post Office | 58.9868168735 | -3.2110309331 | |
| 67523658 | Rennibister | 58.9938720524 | -3.0499983631 | |
| 67523659 | Rennibister | 58.9938009268 | -3.0499091801 | |
| 67523672 | Tormiston Mill | 58.9946596136 | -3.1865574147 | |
| 67523673 | Tormiston Mill | 58.9948300449 | -3.1865806836 | |
| 67523674 | Ring of Brodgar Road End | 58.9897428131 | -3.1996658456 | |
| 67523675 | Ring of Brodgar Road End | 58.9898389965 | -3.1999476214 | |
| 67523964 | Firth Bay Bungalows | 59.0030502598 | -3.1061582766 | |
| 67523965 | Firth Bay Bungalows | 59.0029517914 | -3.1061203004 | |
| 67523969 | Marsdene | 59.0009361438 | -3.0949498307 | |
| 67523972 | Marsdene | 59.0008548937 | -3.0949994715 | |
| 67523973 | Old Finstown Road | 59.0039927473 | -3.110418852 | |
| 67523974 | Old Finstown Road | 59.0040904683 | -3.1105438617 | |
| 67523978 | Quanterness Cottages | 59.0021478674 | -3.0168277549 | |
| 67523979 | Quanterness Cottages | 59.0022375204 | -3.016847807 | |
| 67524253 | Grainbank Road End | 58.9866556632 | -2.9759688659 | |
| 67524254 | Grainbank Road End | 58.9867908741 | -2.9759030926 | |
| 67524389 | Howe Road End | 58.9828408034 | -3.2587719338 | |
| 67524392 | Howe Road End | 58.9829771678 | -3.2586029233 | |
| 67524535 | Academy | 58.9696696093 | -3.2839098979 | |
| 67524682 | Cumminess Road End | 58.9763822589 | -3.2411932625 | |
| 67524723 | Kimberely | 59.0079957049 | -3.1294211527 | |
| 67524724 | Kimberely | 59.0080763607 | -3.1294412067 | |
| 67524725 | Binscarth Cottages | 59.0065994124 | -3.1401522872 | |
| 67524726 | Binscarth Cottages | 59.0067007813 | -3.1398596667 | |
| 67524727 | Germiston Road End | 59.0010729125 | -3.1746625226 | |
| 67524728 | Germiston Road End | 59.0010343149 | -3.1749571344 | |
| 67524729 | Woodbine | 58.9858110347 | -3.2262901447 | |
| 67524987 | Navershaw Road End | 58.9722991219 | -3.2813987203 | |
| 67524989 | Bu Road End | 58.974769832 | -3.2749501157 | |
| 67525232 | Quoybow | 58.9767975404 | -3.2715111345 | |
| 67525234 | Howe Farm | 58.979660791 | -3.2643621146 | |
| 67525346 | Navershaw Road End | 58.9721388917 | -3.2812536256 | |
| 67525347 | Bu Road End | 58.9746821051 | -3.2747381409 | |
| 67525348 | Quoybow | 58.9766920223 | -3.2712811052 | |
| 67525349 | Howe Farm | 58.9795364547 | -3.2642183833 | |
| 67525352 | Stennegeo | 58.9835076576 | -3.2133853839 | |
| 67525356 | Girvan | 58.9814818666 | -3.220603784 | |
| 67525358 | Villasquoy | 58.9733547533 | -3.2242994814 | |
| 67525375 | Orkney Golf Club | 58.9881429343 | -2.9823795082 |