Hatston - Clouston and Stromness Academy circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:40:00 | 07:40:00 | ... | 1 |
|
| ... | 07:40:00 | 07:40:00 | ... | 2 |
|
| ... | 07:40:00 | 07:40:00 | ... | 3 |
|
| ... | 07:42:00 | 07:42:00 | ... | 4 |
|
| ... | 07:46:00 | 07:46:00 | ... | 5 |
|
| ... | 07:51:00 | 07:51:00 | ... | 6 |
|
| ... | 07:57:00 | 07:57:00 | ... | 7 |
|
| ... | 07:59:00 | 07:59:00 | ... | 8 |
|
| ... | 07:59:00 | 07:59:00 | ... | 9 |
|
| ... | 08:00:00 | 08:00:00 | ... | 10 |
|
| ... | 08:01:00 | 08:01:00 | ... | 11 |
|
| ... | 08:02:00 | 08:02:00 | ... | 12 |
|
| ... | 08:04:00 | 08:04:00 | ... | 13 |
|
| ... | 08:06:00 | 08:06:00 | ... | 14 |
|
| ... | 08:09:00 | 08:09:00 | ... | 15 |
|
| ... | 08:13:00 | 08:13:00 | ... | 16 |
|
| ... | 08:16:00 | 08:16:00 | ... | 17 |
|
| ... | 08:20:00 | 08:20:00 | ... | 18 |
|
| ... | 08:22:00 | 08:22:00 | ... | 19 |
|
| ... | 08:25:00 | 08:25:00 | ... | 20 |
|
| ... | 08:29:00 | 08:29:00 | ... | 21 |
|
| ... | 08:33:00 | 08:33:00 | ... | 22 |
|
| ... | 08:34:00 | 08:34:00 | ... | 23 |
|
| ... | 08:35:00 | 08:35:00 | ... | 24 |
|
| ... | 08:36:00 | 08:36:00 | ... | 25 |
|
| ... | 08:37:00 | 08:37:00 | ... | 26 |
|
| ... | 08:38:00 | 08:38:00 | ... | 27 |
|
| ... | 08:39:00 | 08:39:00 | ... | 28 |
|
| ... | 08:39:00 | 08:39:00 | ... | 29 |
|
| ... | 08:39:00 | 08:39:00 | ... | 30 |
|
| ... | 08:40:00 | 08:40:00 | ... | 31 |
|
| ... | 08:40:00 | 08:40:00 | ... | 32 |
|
| ... | 08:41:00 | 08:41:00 | ... | 33 |
|
| ... | 08:41:00 | 08:41:00 | ... | 34 |
|
| ... | 08:42:00 | 08:42:00 | ... | 35 |
|
| ... | 08:43:00 | 08:43:00 | ... | 36 |
|
| ... | 08:44:00 | 08:44:00 | ... | 37 |
|
| ... | 08:45:00 | 08:45:00 | ... | 38 |
|
| ... | 08:46:00 | 08:46:00 | ... | 39 |
|
| ... | 08:47:00 | 08:47:00 | ... | 40 |
|
| ... | 08:48:00 | 08:48:00 | ... | 41 |
|
| ... | 08:49:00 | 08:49:00 | ... | 42 |
|
| ... | 08:49:00 | 08:49:00 | ... | 43 |
|
| ... | 08:50:00 | 08:50:00 | ... | 44 |
|
| ... | 08:50:00 | 08:50:00 | ... | 45 |
|
| ... | 08:50:00 | 08:50:00 | ... | 46 |
|
| ... | 08:51:00 | 08:51:00 | ... | 47 |
|
| ... | 08:54:00 | 08:54:00 | ... | 48 |
|
| ... | 08:56:00 | 08:56:00 | ... | 49 |
|
| ... | 08:58:00 | 08:58:00 | ... | 50 |
|
| ... | 08:59:00 | 08:59:00 | ... | 51 |
|
| 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 | |
| 67523638 | Post Office | 58.986953339 | -3.2108443191 | |
| 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 | |
| 67523749 | Hatston Park | 58.9910771818 | -2.9897893017 | |
| 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 | |
| 67524389 | Howe Road End | 58.9828408034 | -3.2587719338 | |
| 67524392 | Howe Road End | 58.9829771678 | -3.2586029233 | |
| 67524535 | Academy | 58.9696696093 | -3.2839098979 | |
| 67524683 | Cumminess Road End | 58.9762560625 | -3.2412409089 | |
| 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 | |
| 67524732 | Woodbine | 58.9859044421 | -3.2259106656 | |
| 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 | |
| 67525353 | Stennegeo | 58.9833741228 | -3.2132588966 | |
| 67525354 | Girvan | 58.9813845803 | -3.2204437629 | |
| 67525357 | Villasquoy | 58.9733028565 | -3.2240889169 | |
| 67525375 | Orkney Golf Club | 58.9881429343 | -2.9823795082 | |
| 67525382 | Orcadian Office | 58.9874910378 | -2.9771409092 |