Kirkwall - Houton and Orphir circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 17:10:00 | 17:10:00 | ... | 1 |
|
| ... | 17:11:00 | 17:11:00 | ... | 2 |
|
| ... | 17:12:00 | 17:12:00 | ... | 3 |
|
| ... | 17:13:00 | 17:13:00 | ... | 4 |
|
| ... | 17:14:00 | 17:14:00 | ... | 5 |
|
| ... | 17:15:00 | 17:15:00 | ... | 6 |
|
| ... | 17:15:00 | 17:15:00 | ... | 7 |
|
| ... | 17:16:00 | 17:16:00 | ... | 8 |
|
| ... | 17:17:00 | 17:17:00 | ... | 9 |
|
| ... | 17:17:00 | 17:17:00 | ... | 10 |
|
| ... | 17:18:00 | 17:18:00 | ... | 11 |
|
| ... | 17:19:00 | 17:19:00 | ... | 12 |
|
| ... | 17:20:00 | 17:20:00 | ... | 13 |
|
| ... | 17:21:00 | 17:21:00 | ... | 14 |
|
| ... | 17:22:00 | 17:22:00 | ... | 15 |
|
| ... | 17:23:00 | 17:23:00 | ... | 16 |
|
| ... | 17:23:00 | 17:23:00 | ... | 17 |
|
| ... | 17:24:00 | 17:24:00 | ... | 18 |
|
| ... | 17:25:00 | 17:25:00 | ... | 19 |
|
| ... | 17:25:00 | 17:25:00 | ... | 20 |
|
| ... | 17:26:00 | 17:26:00 | ... | 21 |
|
| ... | 17:27:00 | 17:27:00 | ... | 22 |
|
| ... | 17:28:00 | 17:28:00 | ... | 23 |
|
| ... | 17:29:00 | 17:29:00 | ... | 24 |
|
| ... | 17:30:00 | 17:30:00 | ... | 25 |
|
| ... | 17:31:00 | 17:31:00 | ... | 26 |
|
| ... | 17:32:00 | 17:32:00 | ... | 27 |
|
| ... | 17:34:00 | 17:34:00 | ... | 28 |
|
| ... | 17:35:00 | 17:35:00 | ... | 29 |
|
| ... | 17:36:00 | 17:36:00 | ... | 30 |
|
| ... | 17:37:00 | 17:37:00 | ... | 31 |
|
| ... | 17:38:00 | 17:38:00 | ... | 32 |
|
| ... | 17:39:00 | 17:39:00 | ... | 33 |
|
| ... | 17:41:00 | 17:41:00 | ... | 34 |
|
| ... | 17:42:00 | 17:42:00 | ... | 35 |
|
| ... | 17:42:00 | 17:42:00 | ... | 36 |
|
| ... | 17:42:00 | 17:42:00 | ... | 37 |
|
| ... | 17:43:00 | 17:43:00 | ... | 38 |
|
| ... | 17:44:00 | 17:44:00 | ... | 39 |
|
| ... | 17:45:00 | 17:45:00 | ... | 40 |
|
| ... | 17:46:00 | 17:46:00 | ... | 41 |
|
| ... | 17:47:00 | 17:47:00 | ... | 42 |
|
| ... | 17:48:00 | 17:48:00 | ... | 43 |
|
| ... | 17:49:00 | 17:49:00 | ... | 44 |
|
| ... | 17:49:00 | 17:49:00 | ... | 45 |
|
| ... | 17:50:00 | 17:50:00 | ... | 46 |
|
| ... | 17:51:00 | 17:51:00 | ... | 47 |
|
| ... | 17:52:00 | 17:52:00 | ... | 48 |
|
| ... | 17:52:00 | 17:52:00 | ... | 49 |
|
| ... | 17:53:00 | 17:53:00 | ... | 50 |
|
| ... | 17:54:00 | 17:54:00 | ... | 51 |
|
| ... | 17:55:00 | 17:55:00 | ... | 52 |
|
| ... | 17:56:00 | 17:56:00 | ... | 53 |
|
| ... | 17:57:00 | 17:57:00 | ... | 54 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 02/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 67523473 | West Tankerness Lane | 58.9808847182 | -2.9646716932 | |
| 67523434 | Road End | 58.9673723327 | -2.9773017422 | |
| 67523428 | Road End | 58.9670581949 | -2.977275459 | |
| 67523264 | Community School | 58.9360584505 | -3.1414210009 | |
| 67523263 | Community School | 58.9360247682 | -3.142184372 | |
| 67523249 | Ferry Terminal | 58.918524571 | -3.1846217201 | |
| 67523257 | Clowally Farm | 58.9215222724 | -3.1975242345 | |
| 67523273 | Clestrain Junction | 58.9450825326 | -3.2146425686 | |
| 67523259 | Scorra Dale Road End | 58.9314583277 | -3.1637836857 | |
| 67523629 | Travel Centre | 58.9829694637 | -2.9621029207 | |
| 67523679 | Bloomfield South Road End | 58.9600829153 | -3.0038703633 | |
| 67523682 | Bloomfield South Road End | 58.9600985808 | -3.004166387 | |
| 67523695 | High Street | 58.9775095038 | -2.9656558257 | |
| 67523723 | Langskaill Court | 58.9751597316 | -2.9700255081 | |
| 67523724 | Langskaill Court | 58.9751844532 | -2.970321899 | |
| 67523725 | Waulkmill Bay Road End | 58.9442472875 | -3.0767126749 | |
| 67523726 | Waulkmill Bay Road End | 58.9443912386 | -3.0766824034 | |
| 67523727 | High Street | 58.9776340439 | -2.9658158669 | |
| 67523728 | Germiston Road End | 58.9459706149 | -3.1045387917 | |
| 67523729 | Germiston Road End | 58.9458552257 | -3.1043786876 | |
| 67524242 | Road End | 58.9440918665 | -3.0672886919 | |
| 67524243 | Road End | 58.9440123463 | -3.0671298297 | |
| 67524268 | Daisy Cottage | 58.9387435368 | -3.125054643 | |
| 67524269 | Daisy Cottage | 58.9386637857 | -3.1249304155 | |
| 67524272 | Ivy Cottage | 58.9375042744 | -3.1342927288 | |
| 67524273 | Ivy Cottage | 58.9375668207 | -3.1343295323 | |
| 67524274 | Smithy Cottage | 58.9341375142 | -3.1514343062 | |
| 67524275 | Smithy Cottage | 58.9340650665 | -3.1515013875 | |
| 67524276 | Smoogro Road End | 58.9414393998 | -3.1134648793 | |
| 67524278 | Smoogro Road End | 58.9414925247 | -3.1135534776 | |
| 67524358 | Distillery Cottages | 58.9656420865 | -2.9863646498 | |
| 67524359 | Distillery Cottages | 58.9656860545 | -2.98648763 | |
| 67524367 | Crantit Park | 58.9719962464 | -2.9739020356 | |
| 67524368 | Crantit Park | 58.972031247 | -2.9740247694 | |
| 67524369 | Foveran Road End | 58.9577832176 | -3.0108619062 | |
| 67524372 | Foveran Road End | 58.9578721933 | -3.0109688222 | |
| 67524373 | Greenigoe | 58.9502001597 | -3.0317236648 | |
| 67524374 | Greenigoe | 58.9501011137 | -3.0317554694 | |
| 67524382 | Marness Garage | 58.9547078774 | -3.0159348463 | |
| 67524383 | Marness Garage | 58.9547882793 | -3.0159893625 | |
| 67524384 | Ordquil Road | 58.9702491333 | -2.9757310111 | |
| 67524385 | Ordquil Road | 58.970078399 | -2.975743576 | |
| 67524386 | Twartquoy | 58.9473899635 | -3.0439274404 | |
| 67524387 | Twartquoy | 58.947309293 | -3.0439076227 | |
| 67524659 | Nealand | 58.9265997708 | -3.1657392837 | |
| 67524673 | Gyre Road End | 58.9202049896 | -3.1707163887 | |
| 67524675 | Exchange Cottage | 58.9195026265 | -3.1798099835 | |
| 67524689 | Workwell Road End | 58.929629255 | -3.2056048768 | |
| 67524693 | Sower Road End | 58.938105293 | -3.2135459226 | |
| 67524695 | Scorralee Road End | 58.9301770348 | -3.1694211165 | |
| 67524696 | Culdigo Road End | 58.9313811955 | -3.1870948296 | |
| 67524697 | Glenrae Road End | 58.9349928144 | -3.1918577876 | |
| 67524698 | Norwood | 58.9394242068 | -3.2031141925 |