Ratho - Hermiston Gait or Chesser ASDA
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 06:30:00 | 06:30:00 | ... | 1 |
|
| ... | 06:33:00 | 06:33:00 | ... | 2 |
|
| ... | 06:35:00 | 06:35:00 | ... | 3 |
|
| ... | 06:35:00 | 06:35:00 | ... | 4 |
|
| ... | 06:36:00 | 06:36:00 | ... | 5 |
|
| ... | 06:37:00 | 06:37:00 | ... | 6 |
|
| ... | 06:38:00 | 06:38:00 | ... | 7 |
|
| ... | 06:39:00 | 06:39:00 | ... | 8 |
|
| ... | 06:41:00 | 06:41:00 | ... | 9 |
|
| ... | 06:41:00 | 06:41:00 | ... | 10 |
|
| ... | 06:42:00 | 06:42:00 | ... | 11 |
|
| ... | 06:42:00 | 06:42:00 | ... | 12 |
|
| ... | 06:44:00 | 06:44:00 | ... | 13 |
|
| ... | 06:44:00 | 06:44:00 | ... | 14 |
|
| ... | 06:44:00 | 06:44:00 | ... | 15 |
|
| ... | 06:46:00 | 06:46:00 | ... | 16 |
|
| ... | 06:48:00 | 06:48:00 | ... | 17 |
|
| ... | 06:49:00 | 06:49:00 | ... | 18 |
|
| ... | 06:50:00 | 06:50:00 | ... | 19 |
|
| ... | 06:51:00 | 06:51:00 | ... | 20 |
|
| ... | 06:51:00 | 06:51:00 | ... | 21 |
|
| ... | 06:52:00 | 06:52:00 | ... | 22 |
|
| ... | 06:52:00 | 06:52: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 | |
|---|---|---|---|---|
| 36242432 | Gyle Centre | 55.9379487167 | -3.3142741821 | |
| 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 | |
| 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 | |
| 36245978 | Hermiston Gait Retail Park | 55.9272582757 | -3.3072861791 |