Ratho - Hermiston Gait or Chesser ASDA
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 05:02:00 | 05:02:00 | ... | 1 |
|
| ... | 05:03:00 | 05:03:00 | ... | 2 |
|
| ... | 05:04:00 | 05:04:00 | ... | 3 |
|
| ... | 05:05:00 | 05:05:00 | ... | 4 |
|
| ... | 05:06:00 | 05:06:00 | ... | 5 |
|
| ... | 05:07:00 | 05:07:00 | ... | 6 |
|
| ... | 05:08:00 | 05:08:00 | ... | 7 |
|
| ... | 05:08:00 | 05:08:00 | ... | 8 |
|
| ... | 05:08:00 | 05:08:00 | ... | 9 |
|
| ... | 05:09:00 | 05:09:00 | ... | 10 |
|
| ... | 05:09:00 | 05:09:00 | ... | 11 |
|
| ... | 05:10:00 | 05:10:00 | ... | 12 |
|
| ... | 05:11:00 | 05:11:00 | ... | 13 |
|
| ... | 05:11:00 | 05:11:00 | ... | 14 |
|
| ... | 05:12:00 | 05:12:00 | ... | 15 |
|
| ... | 05:12:00 | 05:12:00 | ... | 16 |
|
| ... | 05:13:00 | 05:13:00 | ... | 17 |
|
| ... | 05:15:00 | 05:15:00 | ... | 18 |
|
| ... | 05:16:00 | 05:16:00 | ... | 19 |
|
| ... | 05:16:00 | 05:16:00 | ... | 20 |
|
| ... | 05:17:00 | 05:17:00 | ... | 21 |
|
| ... | 05:18:00 | 05:18:00 | ... | 22 |
|
| ... | 05:18:00 | 05:18:00 | ... | 23 |
|
| ... | 05:19:00 | 05:19:00 | ... | 24 |
|
| ... | 05:20:00 | 05:20:00 | ... | 25 |
|
| ... | 05:20:00 | 05:20:00 | ... | 26 |
|
| ... | 05:21:00 | 05:21:00 | ... | 27 |
|
| ... | 05:22:00 | 05:22:00 | ... | 28 |
|
| ... | 05:22:00 | 05:22:00 | ... | 29 |
|
| ... | 05:23:00 | 05:23:00 | ... | 30 |
|
| ... | 05:23:00 | 05:23:00 | ... | 31 |
|
| ... | 05:23:00 | 05:23:00 | ... | 32 |
|
| ... | 05:24:00 | 05:24:00 | ... | 33 |
|
| ... | 05:25:00 | 05:25:00 | ... | 34 |
|
| ... | 05:28:00 | 05:28:00 | ... | 35 |
|
| ... | 05:30:00 | 05:30:00 | ... | 36 |
|
| ... | 05:30:00 | 05:30:00 | ... | 37 |
|
| ... | 05:31:00 | 05:31:00 | ... | 38 |
|
| ... | 05:32:00 | 05:32:00 | ... | 39 |
|
| ... | 05:33:00 | 05:33:00 | ... | 40 |
|
| ... | 05:34:00 | 05:34:00 | ... | 41 |
|
| ... | 05:36:00 | 05:36:00 | ... | 42 |
|
| ... | 05:36:00 | 05:36:00 | ... | 43 |
|
| ... | 05:37:00 | 05:37:00 | ... | 44 |
|
| ... | 05:37:00 | 05:37:00 | ... | 45 |
|
| ... | 05:39:00 | 05:39:00 | ... | 46 |
|
| ... | 05:39:00 | 05:39:00 | ... | 47 |
|
| ... | 05:39:00 | 05:39:00 | ... | 48 |
|
| ... | 05:41:00 | 05:41:00 | ... | 49 |
|
| ... | 05:43:00 | 05:43:00 | ... | 50 |
|
| ... | 05:44:00 | 05:44:00 | ... | 51 |
|
| ... | 05:45:00 | 05:45:00 | ... | 52 |
|
| ... | 05:46:00 | 05:46:00 | ... | 53 |
|
| ... | 05:46:00 | 05:46:00 | ... | 54 |
|
| ... | 05:47:00 | 05:47:00 | ... | 55 |
|
| ... | 05:47:00 | 05:47:00 | ... | 56 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 29/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36236874 | Bankhead Loan | 55.9231989127 | -3.2917543723 | |
| 36236867 | Bankhead Crossway South | 55.9249321174 | -3.2927082608 | |
| 36236869 | Bankhead Medway | 55.9268359811 | -3.2936679227 | |
| 36242432 | Gyle Centre | 55.9379487167 | -3.3142741821 | |
| 36242936 | Wester Hailes Education Centre | 55.9179787097 | -3.2899966164 | |
| 36234895 | Calder Gardens | 55.918796789 | -3.2899597869 | |
| 36234897 | Calder Grove Nursery | 55.9176212602 | -3.2949450313 | |
| 36234898 | Calder Grove | 55.9181324739 | -3.2984503293 | |
| 36247278 | Murrayburn Approach | 55.9175856987 | -3.2863353547 | |
| 36234923 | Calder Place | 55.9197490342 | -3.2908395158 | |
| 36234925 | Cobbinshaw House | 55.9201647766 | -3.2965980479 | |
| 36234926 | Calder Park | 55.9209023951 | -3.2948144197 | |
| 36234927 | Calder Crescent | 55.9194837683 | -3.2989755652 | |
| 36235365 | Longstone Crescent | 55.9252005116 | -3.2633818269 | |
| 36236729 | Canal Centre | 55.9229553823 | -3.3780516939 | |
| 36246345 | North Street | 55.921511849 | -3.3809769713 | |
| 36236734 | Craigpark Avenue | 55.9206508203 | -3.3848349312 | |
| 36236738 | Wilkieston Road | 55.9205353705 | -3.388703385 | |
| 36236737 | Hallcroft Park | 55.9220032109 | -3.3892199699 | |
| 36247348 | Hallcroft Rise | 55.9211871895 | -3.3906630164 | |
| 36237985 | Gogar Roundabout | 55.9387457406 | -3.3254279228 | |
| 36232428 | Gogarburn A8 | 55.9365699445 | -3.3371841367 | |
| 36236597 | Gogarstone Road | 55.936631684 | -3.3521065527 | |
| 36236723 | Airport Junction | 55.93674866 | -3.3578098206 | |
| 36236724 | Ingliston Road | 55.9376162505 | -3.3671095881 | |
| 36236725 | Ingliston Showground | 55.9380908092 | -3.3737222456 | |
| 36236726 | Station Road | 55.9386654308 | -3.3897844325 | |
| 36247398 | Hillwood Road | 55.9378043105 | -3.3912424736 | |
| 36236727 | Queen Anne Drive | 55.9369287066 | -3.3915953006 | |
| 36253528 | Norton House Hotel | 55.9335529769 | -3.3897454211 | |
| 36253529 | Hillend | 55.9288737993 | -3.3855444291 | |
| 36235947 | Haugh Park | 55.9248253316 | -3.2596567298 | |
| 36235945 | Longstone Grove | 55.9230080114 | -3.2616301599 | |
| 36235942 | Longstone Place | 55.9216331054 | -3.2633937696 | |
| 36235938 | Peatville Gardens | 55.9196478505 | -3.2650893647 | |
| 36235935 | Kingsknowe Drive | 55.9168869581 | -3.2644394052 | |
| 36247645 | Kingsknowe Golf Club | 55.9145713359 | -3.2624280638 | |
| 36235374 | Kingsknowe Road South | 55.9130565156 | -3.2629387922 | |
| 36235375 | Hailes Grove | 55.9118839195 | -3.2651244576 | |
| 36235376 | Spylaw Bank Road | 55.9098718752 | -3.2685464226 | |
| 36235378 | Spylaw Park | 55.9083944324 | -3.2706577827 | |
| 36235934 | Viewfield Road | 55.9089911061 | -3.2729169255 | |
| 36237472 | Clovenstone Road | 55.9124702146 | -3.2770946274 | |
| 36247452 | Wester Hailes Park | 55.9142966619 | -3.276866692 | |
| 36245293 | Hailesland Place | 55.9164693201 | -3.2787781736 | |
| 36237459 | Murrayburn Park | 55.9174745358 | -3.2823474605 | |
| 36237479 | Westside Plaza | 55.9163514548 | -3.2857824608 | |
| 36234928 | Calder Drive | 55.9199462158 | -3.2900299745 | |
| 36247457 | Lochside Place | 55.9332397168 | -3.3143228116 | |
| 36247456 | Lochside Crescent | 55.9346935222 | -3.316180953 | |
| 36243767 | Edinburgh Park Station | 55.9278317709 | -3.308281808 | |
| 36247463 | Lochside Court | 55.9316259542 | -3.3114509767 | |
| 36236875 | Bankhead Avenue | 55.9269463658 | -3.2942797828 | |
| 36245346 | Bankhead Crossway North | 55.9262975489 | -3.2987234116 | |
| 36245394 | Thomas Thomson House | 55.9257741446 | -3.3023388804 | |
| 36245978 | Hermiston Gait Retail Park | 55.9272582757 | -3.3072861791 |