Riccarton - Restalrig
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 21:33:00 | 21:33:00 | ... | 1 |
|
| ... | 21:34:00 | 21:34:00 | ... | 2 |
|
| ... | 21:36:00 | 21:36:00 | ... | 3 |
|
| ... | 21:38:00 | 21:38:00 | ... | 4 |
|
| ... | 21:39:00 | 21:39:00 | ... | 5 |
|
| ... | 21:40:00 | 21:40:00 | ... | 6 |
|
| ... | 21:41:00 | 21:41:00 | ... | 7 |
|
| ... | 21:42:00 | 21:42:00 | ... | 8 |
|
| ... | 21:43:00 | 21:43:00 | ... | 9 |
|
| ... | 21:44:00 | 21:44:00 | ... | 10 |
|
| ... | 21:44:00 | 21:44:00 | ... | 11 |
|
| ... | 21:45:00 | 21:45:00 | ... | 12 |
|
| ... | 21:46:00 | 21:46:00 | ... | 13 |
|
| ... | 21:46:00 | 21:46:00 | ... | 14 |
|
| ... | 21:47:00 | 21:47:00 | ... | 15 |
|
| ... | 21:48:00 | 21:48:00 | ... | 16 |
|
| ... | 21:50:00 | 21:50:00 | ... | 17 |
|
| ... | 21:51:00 | 21:51:00 | ... | 18 |
|
| ... | 21:51:00 | 21:51:00 | ... | 19 |
|
| ... | 21:52:00 | 21:52:00 | ... | 20 |
|
| ... | 21:53:00 | 21:53:00 | ... | 21 |
|
| ... | 21:54:00 | 21:54:00 | ... | 22 |
|
| ... | 21:55:00 | 21:55:00 | ... | 23 |
|
| ... | 21:56:00 | 21:56:00 | ... | 24 |
|
| ... | 21:58:00 | 21:58:00 | ... | 25 |
|
| ... | 22:01:00 | 22:01:00 | ... | 26 |
|
| ... | 22:05:00 | 22:05:00 | ... | 27 |
|
| ... | 22:07:00 | 22:07:00 | ... | 28 |
|
| ... | 22:09:00 | 22:09:00 | ... | 29 |
|
| ... | 22:11:00 | 22:11:00 | ... | 30 |
|
| ... | 22:12:00 | 22:12:00 | ... | 31 |
|
| ... | 22:13:00 | 22:13:00 | ... | 32 |
|
| ... | 22:13:00 | 22:13:00 | ... | 33 |
|
| ... | 22:14:00 | 22:14:00 | ... | 34 |
|
| ... | 22:15:00 | 22:15:00 | ... | 35 |
|
| ... | 22:16:00 | 22:16:00 | ... | 36 |
|
| ... | 22:16:00 | 22:16:00 | ... | 37 |
|
| ... | 22:17:00 | 22:17:00 | ... | 38 |
|
| ... | 22:18:00 | 22:18:00 | ... | 39 |
|
| ... | 22:19:00 | 22:19:00 | ... | 40 |
|
| ... | 22:19:00 | 22:19:00 | ... | 41 |
|
| ... | 22:20:00 | 22:20:00 | ... | 42 |
|
| ... | 22:21:00 | 22:21:00 | ... | 43 |
|
| ... | 22:21:00 | 22:21:00 | ... | 44 |
|
| ... | 22:22:00 | 22:22:00 | ... | 45 |
|
| ... | 22:23:00 | 22:23:00 | ... | 46 |
|
| ... | 22:24:00 | 22:24:00 | ... | 47 |
|
| ... | 22:24:00 | 22:24:00 | ... | 48 |
|
| ... | 22:25:00 | 22:25:00 | ... | 49 |
|
| 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 | |
|---|---|---|---|---|
| 36234874 | Heriot Watt Campus | 55.9090094385 | -3.3198218832 | |
| 36234875 | The Avenue | 55.9102648654 | -3.3175448337 | |
| 36246365 | Hermiston Park & Ride | 55.9173201361 | -3.3140399876 | |
| 36234893 | Burtons Biscuits Factory | 55.9215270265 | -3.296083448 | |
| 36236876 | Napier University (Sighthill) | 55.9227043498 | -3.290073604 | |
| 36236878 | Sighthill Green | 55.9233467101 | -3.2853579771 | |
| 36236879 | Broomhouse Road | 55.9243426984 | -3.2794535867 | |
| 36236892 | Sighthill Post Office | 55.9251136283 | -3.2761661685 | |
| 36232589 | Saughton Mains | 55.9268600981 | -3.2688934311 | |
| 36239469 | Saughton Mains Avenue | 55.9285941865 | -3.2654129224 | |
| 36232595 | HMP Edinburgh | 55.9296994265 | -3.2610313406 | |
| 36232593 | Stenhouse Mill Lane | 55.9298423922 | -3.2575947184 | |
| 36232596 | Chesser Avenue | 55.9318913948 | -3.2505061016 | |
| 36232597 | Saughton Park | 55.9328123172 | -3.2474143901 | |
| 36232624 | Balgreen Road | 55.9342530247 | -3.2444512526 | |
| 36232625 | Gorgie Park Road | 55.9364691183 | -3.2403280676 | |
| 36232626 | Stewart Terrace | 55.9372387124 | -3.2352778466 | |
| 36232627 | Tynecastle | 55.9383263612 | -3.230749811 | |
| 36232628 | Gorgie City Farm | 55.9389168725 | -3.2283030673 | |
| 36232629 | Murieston Crescent | 55.9397606033 | -3.225688141 | |
| 36232632 | Dalry Primary School | 55.9415197211 | -3.223182011 | |
| 36232634 | Caledonian Village | 55.9435019846 | -3.2199141277 | |
| 36232635 | Haymarket Station | 55.9455403998 | -3.2173201899 | |
| 36232637 | West Maitland Street | 55.9469130734 | -3.2157139433 | |
| 36236572 | Shandwick Place | 55.9496334176 | -3.2095537641 | |
| 36235973 | Princes Street (west) | 55.951361837 | -3.2009597554 | |
| 36235974 | Princes Street (Waverley Steps) | 55.9531880012 | -3.19055826 | |
| 36238543 | Leith Street | 55.9554593258 | -3.1870403387 | |
| 36235979 | Elm Row | 55.9588662918 | -3.1840852566 | |
| 36235629 | Shrubhill | 55.9619679952 | -3.1801592221 | |
| 36235634 | Pilrig Street | 55.9641764086 | -3.1775511309 | |
| 36237349 | Balfour Street | 55.9664692496 | -3.1755060332 | |
| 36237348 | Stead's Place | 55.9680636656 | -3.1741444966 | |
| 36237378 | Foot of the Walk | 55.9696859297 | -3.1726875589 | |
| 36235643 | Duke Street | 55.9699406398 | -3.16952286 | |
| 36232898 | Vanburgh Place | 55.9691821765 | -3.1661193465 | |
| 36232923 | Somerset Place | 55.9694854746 | -3.1635008557 | |
| 36232924 | Gladstone Place | 55.9695486581 | -3.1596574559 | |
| 36232925 | Ryehill Terrace | 55.9674574073 | -3.1574961127 | |
| 36232926 | Restalrig Circus | 55.9651357144 | -3.154991712 | |
| 36232927 | Restalrig Square | 55.9635900751 | -3.1540485653 | |
| 36238742 | Loganlea Drive | 55.9573318849 | -3.1468148254 | |
| 36238743 | Restalrig Avenue | 55.9571466549 | -3.1435418976 | |
| 36232928 | Sleigh Gardens | 55.9623381738 | -3.1514802862 | |
| 36232929 | Findlay Avenue | 55.9624817066 | -3.1486171261 | |
| 36232932 | Restalrig Drive | 55.962626662 | -3.1455937962 | |
| 36232934 | Loaning Road | 55.9612675302 | -3.1429426028 | |
| 36234232 | Craigentinny Road | 55.9600263251 | -3.1421051093 | |
| 36238546 | Loganlea Place | 55.9583129624 | -3.1466356157 |