Riccarton - Queensferry
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:02:00 | 07:02:00 | ... | 1 |
|
| ... | 07:03:00 | 07:03:00 | ... | 2 |
|
| ... | 07:03:00 | 07:03:00 | ... | 3 |
|
| ... | 07:04:00 | 07:04:00 | ... | 4 |
|
| ... | 07:04:00 | 07:04:00 | ... | 5 |
|
| ... | 07:05:00 | 07:05:00 | ... | 6 |
|
| ... | 07:06:00 | 07:06:00 | ... | 7 |
|
| ... | 07:06:00 | 07:06:00 | ... | 8 |
|
| ... | 07:07:00 | 07:07:00 | ... | 9 |
|
| ... | 07:09:00 | 07:09:00 | ... | 10 |
|
| ... | 07:09:00 | 07:09:00 | ... | 11 |
|
| ... | 07:10:00 | 07:10:00 | ... | 12 |
|
| ... | 07:11:00 | 07:11:00 | ... | 13 |
|
| ... | 07:13:00 | 07:13:00 | ... | 14 |
|
| ... | 07:14:00 | 07:14:00 | ... | 15 |
|
| ... | 07:16:00 | 07:16:00 | ... | 16 |
|
| ... | 07:17:00 | 07:17:00 | ... | 17 |
|
| ... | 07:18:00 | 07:18:00 | ... | 18 |
|
| ... | 07:22:00 | 07:22:00 | ... | 19 |
|
| ... | 07:23:00 | 07:23:00 | ... | 20 |
|
| ... | 07:24:00 | 07:24:00 | ... | 21 |
|
| ... | 07:25:00 | 07:25:00 | ... | 22 |
|
| ... | 07:26:00 | 07:26:00 | ... | 23 |
|
| ... | 07:26:00 | 07:26:00 | ... | 24 |
|
| ... | 07:27:00 | 07:27:00 | ... | 25 |
|
| ... | 07:27:00 | 07:27:00 | ... | 26 |
|
| ... | 07:28:00 | 07:28:00 | ... | 27 |
|
| ... | 07:31:00 | 07:31:00 | ... | 28 |
|
| ... | 07:33:00 | 07:33:00 | ... | 29 |
|
| ... | 07:34:00 | 07:34:00 | ... | 30 |
|
| ... | 07:34:00 | 07:34:00 | ... | 31 |
|
| ... | 07:36:00 | 07:36:00 | ... | 32 |
|
| ... | 07:37:00 | 07:37:00 | ... | 33 |
|
| ... | 07:40:00 | 07:40:00 | ... | 34 |
|
| ... | 07:42:00 | 07:42:00 | ... | 35 |
|
| ... | 07:43:00 | 07:43:00 | ... | 36 |
|
| ... | 07:44:00 | 07:44:00 | ... | 37 |
|
| ... | 07:48:00 | 07:48:00 | ... | 38 |
|
| ... | 07:48:00 | 07:48:00 | ... | 39 |
|
| ... | 07:51:00 | 07:51:00 | ... | 40 |
|
| ... | 07:52:00 | 07:52:00 | ... | 41 |
|
| ... | 07:53:00 | 07:53:00 | ... | 42 |
|
| ... | 07:53:00 | 07:53:00 | ... | 43 |
|
| ... | 07:55:00 | 07:55:00 | ... | 44 |
|
| ... | 07:57:00 | 07:57:00 | ... | 45 |
|
| ... | 07:58:00 | 07:58:00 | ... | 46 |
|
| ... | 08:00:00 | 08:00:00 | ... | 47 |
|
| ... | 08:00:00 | 08:00:00 | ... | 48 |
|
| ... | 08:01:00 | 08:01:00 | ... | 49 |
|
| ... | 08:01:00 | 08:01:00 | ... | 50 |
|
| ... | 08:02:00 | 08:02:00 | ... | 51 |
|
| ... | 08:03:00 | 08:03:00 | ... | 52 |
|
| ... | 08:06:00 | 08:06:00 | ... | 53 |
|
| ... | 08:08:00 | 08:08:00 | ... | 54 |
|
| ... | 08:09:00 | 08:09:00 | ... | 55 |
|
| 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 | |
|---|---|---|---|---|
| 36234873 | The Avenue | 55.9101572474 | -3.3175251856 | |
| 36234874 | Heriot Watt Campus | 55.9090094385 | -3.3198218832 | |
| 36245726 | Bankhead Avenue | 55.9270329957 | -3.2945867625 | |
| 36245969 | Hermiston Gait Retail Park | 55.9273570826 | -3.3072895065 | |
| 36247243 | Bankhead Broadway | 55.9280313722 | -3.2996136902 | |
| 36247257 | Lochside Court | 55.9317449404 | -3.3112469087 | |
| 36243626 | Edinburgh Park Station | 55.9277070365 | -3.3081815735 | |
| 36242485 | Gyle Centre | 55.938312384 | -3.3147187563 | |
| 36247694 | Lochside Crescent | 55.9346962579 | -3.3159249174 | |
| 36247426 | Lochside Place | 55.9331772457 | -3.3134402894 | |
| 36253649 | Eilston Road | 55.9610744349 | -3.4033868913 | |
| 36253625 | Eilston Loan | 55.9597997203 | -3.4080021669 | |
| 36253626 | Kirklands Park Street | 55.9595744435 | -3.4127675077 | |
| 36238539 | Stirling Road | 55.9565766567 | -3.4124660779 | |
| 36238568 | Manse Road | 55.9565224859 | -3.4054165081 | |
| 36238567 | Station Road | 55.9562354857 | -3.403003536 | |
| 36238782 | Almondside | 55.9550533897 | -3.4010708043 | |
| 36238489 | Bowling Green Road | 55.9540830222 | -3.4018525742 | |
| 36238628 | Gateside Road | 55.9527598877 | -3.4044153051 | |
| 36238242 | Milrig Cottages | 55.9462442191 | -3.4123620548 | |
| 36246492 | Bridge Street | 55.9400403592 | -3.4079735026 | |
| 36238638 | Newbridge Bowling Club | 55.9388912056 | -3.4078837744 | |
| 36253547 | Parkside | 55.9377317892 | -3.4079057463 | |
| 36232395 | Lochend Road | 55.9391268746 | -3.3982382541 | |
| 36232396 | Station Road | 55.9389339423 | -3.3906745974 | |
| 36232397 | Ingliston Showground | 55.938366758 | -3.3739561504 | |
| 36232398 | Ingliston Road | 55.9378484414 | -3.3664293621 | |
| 36238943 | Airport Junction | 55.9372276546 | -3.3600038285 | |
| 36236598 | Gogarstone Road | 55.9369262869 | -3.3506439867 | |
| 36232429 | Gogarburn A8 | 55.9383878967 | -3.3294501129 | |
| 36238935 | Gogar Roundabout | 55.9390979727 | -3.3260963589 | |
| 36253753 | Scotstoun Terminus | 55.9824521978 | -3.381850348 | |
| 36236948 | Sommerville Gardens | 55.9826397028 | -3.385158804 | |
| 36236945 | Provost Milne Grove | 55.9824184923 | -3.3872505508 | |
| 36236946 | Atheling Grove | 55.9819720466 | -3.3909850537 | |
| 36236942 | Moubray Grove | 55.9825548786 | -3.3942756903 | |
| 36238537 | Lovers Lane | 55.984677642 | -3.3964679088 | |
| 36236936 | Viewforth Place | 55.98677526 | -3.39691222 | |
| 36236952 | The Loan | 55.9891401561 | -3.3975585935 | |
| 36236895 | Queensferry Police Station | 55.9906765211 | -3.3983675108 | |
| 36236897 | Walker Drive | 55.9897351861 | -3.4060764854 | |
| 36253549 | Dundas Castle | 55.9775370122 | -3.3969958073 | |
| 36236924 | Springfield View | 55.989086896 | -3.4109102596 | |
| 36238253 | Springfield Crescent | 55.9882294745 | -3.4151591372 | |
| 36236954 | Echline Corner | 55.9866555666 | -3.4191892161 | |
| 36236957 | Echline Park | 55.9847967865 | -3.4128217265 | |
| 36236959 | Long Crook | 55.984219586 | -3.4098674181 | |
| 36236872 | Bankhead Medway | 55.9261315729 | -3.2931483117 | |
| 36236868 | Bankhead Crossway South | 55.9246485392 | -3.2923307305 | |
| 36236873 | Bankhead Loan | 55.9231829612 | -3.291561803 | |
| 36234864 | Wester Hailes Road | 55.921866566 | -3.2928462368 | |
| 36234867 | Calder View | 55.9208029706 | -3.2982835929 | |
| 36246389 | Hermiston Park & Ride | 55.9171220106 | -3.314081286 | |
| 36246824 | Ferrymuir Retail Park | 55.9838695115 | -3.401167196 | |
| 36253742 | Ferrymuir Retail Park | 55.9824802666 | -3.3992737299 |