Queensferry - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:10:00 | 15:10:00 | ... | 1 |
|
| ... | 15:11:00 | 15:11:00 | ... | 2 |
|
| ... | 15:11:00 | 15:11:00 | ... | 3 |
|
| ... | 15:12:00 | 15:12:00 | ... | 4 |
|
| ... | 15:12:00 | 15:12:00 | ... | 5 |
|
| ... | 15:13:00 | 15:13:00 | ... | 6 |
|
| ... | 15:14:00 | 15:14:00 | ... | 7 |
|
| ... | 15:16:00 | 15:16:00 | ... | 8 |
|
| ... | 15:17:00 | 15:17:00 | ... | 9 |
|
| ... | 15:19:00 | 15:19:00 | ... | 10 |
|
| ... | 15:20:00 | 15:20:00 | ... | 11 |
|
| ... | 15:21:00 | 15:21:00 | ... | 12 |
|
| ... | 15:22:00 | 15:22:00 | ... | 13 |
|
| ... | 15:23:00 | 15:23:00 | ... | 14 |
|
| ... | 15:23:00 | 15:23:00 | ... | 15 |
|
| ... | 15:25:00 | 15:25:00 | ... | 16 |
|
| ... | 15:26:00 | 15:26:00 | ... | 17 |
|
| ... | 15:27:00 | 15:27:00 | ... | 18 |
|
| ... | 15:28:00 | 15:28:00 | ... | 19 |
|
| ... | 15:29:00 | 15:29:00 | ... | 20 |
|
| ... | 15:30:00 | 15:30:00 | ... | 21 |
|
| ... | 15:31:00 | 15:31:00 | ... | 22 |
|
| ... | 15:33:00 | 15:33:00 | ... | 23 |
|
| ... | 15:35:00 | 15:35:00 | ... | 24 |
|
| ... | 15:36:00 | 15:36:00 | ... | 25 |
|
| ... | 15:36:00 | 15:36:00 | ... | 26 |
|
| ... | 15:37:00 | 15:37:00 | ... | 27 |
|
| ... | 15:38:00 | 15:38:00 | ... | 28 |
|
| ... | 15:38:00 | 15:38:00 | ... | 29 |
|
| ... | 15:39:00 | 15:39:00 | ... | 30 |
|
| ... | 15:40:00 | 15:40:00 | ... | 31 |
|
| ... | 15:40:00 | 15:40:00 | ... | 32 |
|
| ... | 15:41:00 | 15:41:00 | ... | 33 |
|
| ... | 15:43:00 | 15:43:00 | ... | 34 |
|
| ... | 15:44:00 | 15:44:00 | ... | 35 |
|
| ... | 15:44:00 | 15:44:00 | ... | 36 |
|
| ... | 15:45:00 | 15:45:00 | ... | 37 |
|
| ... | 15:46:00 | 15:46:00 | ... | 38 |
|
| ... | 15:47:00 | 15:47:00 | ... | 39 |
|
| ... | 15:47:00 | 15:47:00 | ... | 40 |
|
| ... | 15:48:00 | 15:48:00 | ... | 41 |
|
| ... | 15:49:00 | 15:49:00 | ... | 42 |
|
| ... | 15:50:00 | 15:50:00 | ... | 43 |
|
| ... | 15:52:00 | 15:52:00 | ... | 44 |
|
| ... | 15:53:00 | 15:53:00 | ... | 45 |
|
| ... | 15:53:00 | 15:53:00 | ... | 46 |
|
| ... | 15:55:00 | 15:55:00 | ... | 47 |
|
| ... | 15:56:00 | 15:56:00 | ... | 48 |
|
| ... | 15:57:00 | 15:57:00 | ... | 49 |
|
| ... | 15:58:00 | 15:58:00 | ... | 50 |
|
| ... | 16:01:00 | 16:01:00 | ... | 51 |
|
| ... | 16:06:00 | 16:06:00 | ... | 52 |
|
| ... | 16:08:00 | 16:08:00 | ... | 53 |
|
| ... | 16:10:00 | 16:10:00 | ... | 54 |
|
| 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 | |
|---|---|---|---|---|
| 36253752 | Scotstoun Terminus | 55.9823990238 | -3.3817843397 | |
| 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 | |
| 36236962 | Long Crook | 55.984042512 | -3.4096365721 | |
| 36236958 | Echline Park | 55.9846248436 | -3.4129276574 | |
| 36236956 | Echline Corner | 55.9867070597 | -3.4193994898 | |
| 36238252 | Springfield Crescent | 55.9885427695 | -3.4144812724 | |
| 36236923 | Springfield View | 55.9896034533 | -3.4097427882 | |
| 36236898 | Walker Drive | 55.989973835 | -3.4056362795 | |
| 36236896 | Queensferry Police Station | 55.9909455076 | -3.3992108603 | |
| 36238276 | Burgess Road | 55.98716503 | -3.3958202143 | |
| 36236932 | Queen Margaret Drive | 55.9875503178 | -3.3903518212 | |
| 36236928 | Ashburnham Road | 55.9873243215 | -3.3872819883 | |
| 36236926 | Railway Station | 55.9868859331 | -3.3823130913 | |
| 36246349 | Bankhead Cottages | 55.9864253748 | -3.3760932178 | |
| 36237964 | Village Hall | 55.9824488389 | -3.3733073558 | |
| 36239353 | Easter Dalmeny | 55.9843895006 | -3.3611783315 | |
| 36237969 | Barnbougle Gate Lodge | 55.9802944641 | -3.3478763218 | |
| 36238973 | Burnshot Flyover | 55.9717133444 | -3.3279973059 | |
| 36232465 | Cramond Brig | 55.9656014378 | -3.3181113472 | |
| 36232467 | Braehead Avenue | 55.9622087351 | -3.3135426066 | |
| 36238732 | Cammo Crescent | 55.9611148384 | -3.309100342 | |
| 36238725 | Barnton Junction | 55.9607986881 | -3.3050208971 | |
| 36238729 | Drum Brae North | 55.9603728696 | -3.299400057 | |
| 36238728 | Parkgrove Road | 55.9606907221 | -3.2948133395 | |
| 36238734 | Parkgrove Street | 55.9612346423 | -3.290073884 | |
| 36238727 | Clermiston Drive | 55.9619837066 | -3.2837391785 | |
| 36238726 | Hillpark Steps | 55.9627215926 | -3.2758499743 | |
| 36238525 | Marchfield Park Lane | 55.9624399797 | -3.2700577112 | |
| 36238526 | Marchfield Park | 55.9621144719 | -3.266763105 | |
| 36238524 | Blackhall Library | 55.9616409335 | -3.2629991798 | |
| 36237643 | Telford Road | 55.9601837948 | -3.2561118499 | |
| 36237639 | Columba Avenue | 55.9591055182 | -3.2534659904 | |
| 36237638 | St Columba's Church | 55.9580538065 | -3.2508531716 | |
| 36238693 | Maidencraig Crescent | 55.9570732506 | -3.2483068548 | |
| 36232732 | Craigleith Road | 55.9564478043 | -3.2435137022 | |
| 36232728 | Craigleith Drive | 55.9557072539 | -3.2403186827 | |
| 36232725 | Orchard Road | 55.9547048613 | -3.2327590558 | |
| 36232724 | Queensferry Terrace | 55.9547678016 | -3.2291574312 | |
| 36232698 | Stewart's Melville | 55.9549155253 | -3.2260549772 | |
| 36232696 | Learmonth Terrace | 55.9552435509 | -3.2192584245 | |
| 36232364 | Dean Bridge | 55.9544915128 | -3.2153428999 | |
| 36232367 | Drumsheugh Place | 55.9516348705 | -3.2116180283 | |
| 36246236 | Queensferry Street | 55.9504686291 | -3.2086830099 | |
| 36235969 | Princes Street (west) | 55.9509524581 | -3.2033172215 | |
| 36232378 | George Street (Assembly Rooms) | 55.9534058809 | -3.1986687766 | |
| 36232379 | George Street (The Dome) | 55.9539400292 | -3.195482147 | |
| 36232385 | St Andrew Square | 55.9549075878 | -3.1929974481 | |
| 36238232 | Army Scotland HQ | 55.9680808138 | -3.3215282003 | |
| 36236953 | The Loan | 55.9901105773 | -3.3975615506 | |
| 36253739 | Ferrymuir Retail Park | 55.9823292091 | -3.3991240225 | |
| 36243837 | Ferrymuir Retail Park | 55.9838039051 | -3.4014052508 |