Ratho - Hermiston Gait or Chesser ASDA
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:57:00 | 16:57:00 | ... | 1 |
|
| ... | 16:58:00 | 16:58:00 | ... | 2 |
|
| ... | 16:58:00 | 16:58:00 | ... | 3 |
|
| ... | 16:59:00 | 16:59:00 | ... | 4 |
|
| ... | 17:00:00 | 17:00:00 | ... | 5 |
|
| ... | 17:02:00 | 17:02:00 | ... | 6 |
|
| ... | 17:04:00 | 17:04:00 | ... | 7 |
|
| ... | 17:06:00 | 17:06:00 | ... | 8 |
|
| ... | 17:06:00 | 17:06:00 | ... | 9 |
|
| ... | 17:08:00 | 17:08:00 | ... | 10 |
|
| ... | 17:09:00 | 17:09:00 | ... | 11 |
|
| ... | 17:11:00 | 17:11:00 | ... | 12 |
|
| ... | 17:11:00 | 17:11:00 | ... | 13 |
|
| ... | 17:12:00 | 17:12:00 | ... | 14 |
|
| ... | 17:13:00 | 17:13:00 | ... | 15 |
|
| ... | 17:15:00 | 17:15:00 | ... | 16 |
|
| ... | 17:15:00 | 17:15:00 | ... | 17 |
|
| ... | 17:17:00 | 17:17:00 | ... | 18 |
|
| ... | 17:18:00 | 17:18:00 | ... | 19 |
|
| ... | 17:19:00 | 17:19:00 | ... | 20 |
|
| ... | 17:19:00 | 17:19:00 | ... | 21 |
|
| ... | 17:21:00 | 17:21:00 | ... | 22 |
|
| ... | 17:23:00 | 17:23:00 | ... | 23 |
|
| 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 | |
|---|---|---|---|---|
| 36245969 | Hermiston Gait Retail Park | 55.9273570826 | -3.3072895065 | |
| 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 | |
| 36232395 | Lochend Road | 55.9391268746 | -3.3982382541 | |
| 36247236 | Hillwood Road | 55.9376760302 | -3.3914620066 | |
| 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 | |
| 36236736 | Wilkieston Road | 55.9206914563 | -3.3892050427 | |
| 36236735 | Craigpark Avenue | 55.9207934556 | -3.384936033 | |
| 36246327 | North Street | 55.9214782638 | -3.381567878 | |
| 36253532 | Hillend | 55.9288037229 | -3.3861821585 | |
| 36253534 | Norton House Hotel | 55.9338771887 | -3.390477385 | |
| 36236728 | Queen Anne Drive | 55.9370508399 | -3.3919198641 | |
| 36236732 | Canal Centre | 55.9230592299 | -3.3784074541 | |
| 36236737 | Hallcroft Park | 55.9220032109 | -3.3892199699 |