Edinburgh - St Andrews
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:40:00 | 07:40:00 | ... | 1 |
|
| ... | 07:40:00 | 07:40:00 | ... | 2 |
|
| ... | 07:41:00 | 07:41:00 | ... | 3 |
|
| ... | 07:42:00 | 07:42:00 | ... | 4 |
|
| ... | 07:43:00 | 07:43:00 | ... | 5 |
|
| ... | 07:44:00 | 07:44:00 | ... | 6 |
|
| ... | 07:44:00 | 07:44:00 | ... | 7 |
|
| ... | 07:44:00 | 07:44:00 | ... | 8 |
|
| ... | 07:45:00 | 07:45:00 | ... | 9 |
|
| ... | 07:46:00 | 07:46:00 | ... | 10 |
|
| ... | 07:51:00 | 07:51:00 | ... | 11 |
|
| ... | 07:51:00 | 07:51:00 | ... | 12 |
|
| ... | 07:53:00 | 07:53:00 | ... | 13 |
|
| ... | 07:54:00 | 07:54:00 | ... | 14 |
|
| ... | 07:55:00 | 07:55:00 | ... | 15 |
|
| ... | 07:55:00 | 07:55:00 | ... | 16 |
|
| ... | 07:56:00 | 07:56:00 | ... | 17 |
|
| ... | 07:58:00 | 07:58:00 | ... | 18 |
|
| ... | 08:02:00 | 08:02:00 | ... | 19 |
|
| ... | 08:03:00 | 08:03:00 | ... | 20 |
|
| ... | 08:04:00 | 08:04:00 | ... | 21 |
|
| ... | 08:05:00 | 08:05:00 | ... | 22 |
|
| ... | 08:06:00 | 08:06:00 | ... | 23 |
|
| ... | 08:07:00 | 08:07:00 | ... | 24 |
|
| ... | 08:07:00 | 08:07:00 | ... | 25 |
|
| ... | 08:09:00 | 08:09:00 | ... | 26 |
|
| ... | 08:11:00 | 08:11:00 | ... | 27 |
|
| ... | 08:13:00 | 08:13:00 | ... | 28 |
|
| ... | 08:16:00 | 08:16:00 | ... | 29 |
|
| ... | 08:17:00 | 08:17:00 | ... | 30 |
|
| ... | 08:20:00 | 08:20:00 | ... | 31 |
|
| ... | 08:22:00 | 08:22:00 | ... | 32 |
|
| ... | 08:23:00 | 08:23:00 | ... | 33 |
|
| ... | 08:23:00 | 08:23:00 | ... | 34 |
|
| ... | 08:25:00 | 08:25:00 | ... | 35 |
|
| ... | 08:26:00 | 08:26:00 | ... | 36 |
|
| ... | 08:29:00 | 08:29:00 | ... | 37 |
|
| ... | 08:30:00 | 08:30:00 | ... | 38 |
|
| ... | 08:32:00 | 08:32:00 | ... | 39 |
|
| ... | 08:33:00 | 08:33:00 | ... | 40 |
|
| ... | 08:34:00 | 08:34:00 | ... | 41 |
|
| ... | 08:34:00 | 08:34:00 | ... | 42 |
|
| ... | 08:35:00 | 08:35:00 | ... | 43 |
|
| ... | 08:36:00 | 08:36:00 | ... | 44 |
|
| ... | 08:36:00 | 08:36:00 | ... | 45 |
|
| ... | 08:36:00 | 08:36:00 | ... | 46 |
|
| ... | 08:39:00 | 08:39:00 | ... | 47 |
|
| ... | 08:40:00 | 08:40:00 | ... | 48 |
|
| ... | 08:41:00 | 08:41:00 | ... | 49 |
|
| ... | 08:42:00 | 08:42:00 | ... | 50 |
|
| ... | 08:42:00 | 08:42:00 | ... | 51 |
|
| ... | 08:42:00 | 08:42:00 | ... | 52 |
|
| ... | 08:43:00 | 08:43:00 | ... | 53 |
|
| ... | 08:43:00 | 08:43:00 | ... | 54 |
|
| ... | 08:43:00 | 08:43:00 | ... | 55 |
|
| ... | 08:45:00 | 08:45:00 | ... | 56 |
|
| ... | 08:50:00 | 08:50:00 | ... | 57 |
|
| ... | 08:53:00 | 08:53:00 | ... | 58 |
|
| ... | 08:54:00 | 08:54:00 | ... | 59 |
|
| ... | 08:58:00 | 08:58:00 | ... | 60 |
|
| ... | 08:59:00 | 08:59:00 | ... | 61 |
|
| ... | 09:03:00 | 09:03:00 | ... | 62 |
|
| ... | 09:05:00 | 09:05:00 | ... | 63 |
|
| ... | 09:09:00 | 09:09:00 | ... | 64 |
|
| ... | 09:09:00 | 09:09:00 | ... | 65 |
|
| ... | 09:10:00 | 09:10:00 | ... | 66 |
|
| ... | 09:11:00 | 09:11:00 | ... | 67 |
|
| ... | 09:12:00 | 09:12:00 | ... | 68 |
|
| ... | 09:13:00 | 09:13:00 | ... | 69 |
|
| ... | 09:14:00 | 09:14:00 | ... | 70 |
|
| ... | 09:14:00 | 09:14:00 | ... | 71 |
|
| ... | 09:16:00 | 09:16:00 | ... | 72 |
|
| ... | 09:17:00 | 09:17:00 | ... | 73 |
|
| ... | 09:19:00 | 09:19:00 | ... | 74 |
|
| ... | 09:20:00 | 09:20:00 | ... | 75 |
|
| ... | 09:25:00 | 09:25:00 | ... | 76 |
|
| ... | 09:26:00 | 09:26:00 | ... | 77 |
|
| ... | 09:34:00 | 09:34:00 | ... | 78 |
|
| ... | 09:41:00 | 09:41:00 | ... | 79 |
|
| ... | 09:43:00 | 09:43:00 | ... | 80 |
|
| ... | 09:45:00 | 09:45:00 | ... | 81 |
|
| ... | 09:45:00 | 09:45:00 | ... | 82 |
|
| ... | 09:47:00 | 09:47:00 | ... | 83 |
|
| ... | 09:50:00 | 09:50:00 | ... | 84 |
|
| ... | 09:51:00 | 09:51:00 | ... | 85 |
|
| ... | 09:55:00 | 09:55:00 | ... | 86 |
|
| ... | 09:56:00 | 09:56:00 | ... | 87 |
|
| ... | 09:59:00 | 09:59:00 | ... | 88 |
|
| ... | 10:08:00 | 10:08:00 | ... | 89 |
|
| ... | 10:11:00 | 10:11:00 | ... | 90 |
|
| ... | 10:14:00 | 10:14:00 | ... | 91 |
|
| ... | 10:16:00 | 10:16:00 | ... | 92 |
|
| ... | 10:19:00 | 10:19:00 | ... | 93 |
|
| ... | 10:21:00 | 10:21:00 | ... | 94 |
|
| ... | 10:24:00 | 10:24:00 | ... | 95 |
|
| ... | 10:26:00 | 10:26:00 | ... | 96 |
|
| ... | 10:32:00 | 10:32:00 | ... | 97 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 13/08/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36237987 | Slip Road | 55.9875092345 | -3.4042804575 | |
| 36238725 | Barnton Junction | 55.9607986881 | -3.3050208971 | |
| 36238726 | Hillpark Steps | 55.9627215926 | -3.2758499743 | |
| 36237643 | Telford Road | 55.9601837948 | -3.2561118499 | |
| 36232728 | Craigleith Drive | 55.9557072539 | -3.2403186827 | |
| 36232696 | Learmonth Terrace | 55.9552435509 | -3.2192584245 | |
| 36246236 | Queensferry Street | 55.9504686291 | -3.2086830099 | |
| 36235972 | Princes Street (west) | 55.9512566262 | -3.2016130961 | |
| 36243246 | Princes Street (Scott Mon.) | 55.9523426463 | -3.1952727578 | |
| 36253232 | Bus Station | 55.9555492402 | -3.1907588826 | |
| 34323654 | West Access Ridge Way | 56.0404829784 | -3.360697023 | |
| 34323743 | East Access Ridge Way | 56.0458559917 | -3.3402084861 | |
| 34323643 | Pentland Rise | 56.0407975102 | -3.3443029245 | |
| 34323595 | Meadowfield | 56.0391116959 | -3.35629884 | |
| 34323286 | Civic Centre | 56.0297222182 | -3.3988965354 | |
| 34323476 | Bannerman Avenue | 56.0344054094 | -3.3963696643 | |
| 34323243 | North Access | 56.0120776034 | -3.4033593826 | |
| 34323659 | Railway Station | 56.0416344622 | -3.3670782577 | |
| 34323249 | Park & Ride | 56.022579057 | -3.4059705638 | |
| 34326974 | Dysart Road End | 56.1322476172 | -3.1194836652 | |
| 34326897 | Hill Street | 56.1304236967 | -3.1214578534 | |
| 34326739 | Porte | 56.1269613712 | -3.1237701797 | |
| 34325959 | The Harbour | 56.1169138091 | -3.1513172612 | |
| 34326357 | Ravenscraig Flats | 56.1203958232 | -3.1440384103 | |
| 34326424 | Ravenscraig Park | 56.1217146917 | -3.1384155638 | |
| 34326467 | Briarcliffe Street | 56.1228521279 | -3.1349103142 | |
| 34326469 | Wishart Place | 56.1231384562 | -3.1321037313 | |
| 34325869 | St Brycedale Road | 56.1117329108 | -3.1634002437 | |
| 34325937 | Oswald's Wynd | 56.1139383815 | -3.157226981 | |
| 34329384 | Letham Glen | 56.2026460466 | -2.9965963861 | |
| 34329498 | Cupar Road | 56.2053959572 | -2.9942980935 | |
| 34329528 | Scoonie Golf Course | 56.2062248798 | -2.9917725425 | |
| 34329353 | Haughgate Avenue | 56.2010414325 | -2.9950235415 | |
| 34329287 | Maitland Street | 56.1992390852 | -2.9945739326 | |
| 34329247 | St Andrews Parish Church | 56.1978644223 | -2.9945705851 | |
| 34328768 | Viewforth Nursery | 56.1949652349 | -2.9942054715 | |
| 34328279 | Memorial Court | 56.1823348074 | -3.0160144001 | |
| 34327934 | Muiredge Roundabout | 56.1735448206 | -3.0401032486 | |
| 34327898 | College Street | 56.1720284902 | -3.032347448 | |
| 34327643 | School Wynd | 56.1607680843 | -3.0654234423 | |
| 34327543 | Post Office | 56.1504933703 | -3.0896710548 | |
| 34327649 | Waggon Road | 56.1967877904 | -2.9954935836 | |
| 34326325 | Flesh Wynd | 56.1199383774 | -3.1458906321 | |
| 34325656 | Esplanade | 56.0982972031 | -3.161789287 | |
| 34328293 | South Grove | 56.1842322702 | -3.0092334331 | |
| 34325846 | Bus Station | 56.1100808347 | -3.1604076731 | |
| 34328693 | Bus Station | 56.1933731177 | -2.9988859538 | |
| 34345467 | West Lodge | 56.0806802431 | -3.279585877 | |
| 34346479 | Bus Station | 56.1101197034 | -3.1610520602 | |
| 34398928 | Silverburn Park | 56.2081808011 | -2.9819891697 | |
| 34346475 | Bus Station | 56.1932969565 | -2.9994157656 | |
| 34343468 | Bridge Street - South | 56.3356435265 | -2.8002393797 | |
| 34343434 | Fire Station | 56.3336147342 | -2.8027523439 | |
| 34343296 | Pipeland Road | 56.3331976404 | -2.7977783325 | |
| 34343427 | Langlands Road | 56.3333834822 | -2.7912157571 | |
| 34343429 | Warrack Street | 56.3335517383 | -2.787369924 | |
| 34343432 | Woodburn Terrace | 56.3336226718 | -2.7846865641 | |
| 34342348 | Toll Road | 56.2264534633 | -2.6915140596 | |
| 34342346 | March Crescent | 56.2249885806 | -2.6915844344 | |
| 34329894 | School Road | 56.2230806487 | -2.693759445 | |
| 34329863 | Fisheries Museum | 56.2217401868 | -2.6972668882 | |
| 34329893 | Harbour | 56.2226983512 | -2.7010095709 | |
| 34342328 | Waid Academy | 56.2240791854 | -2.7046634379 | |
| 34329865 | Crichton Street | 56.221671348 | -2.7062318712 | |
| 34329839 | Craws Nest Hotel | 56.2201197348 | -2.7088963154 | |
| 34329739 | Milton Road | 56.2152114072 | -2.7248648284 | |
| 34329679 | Tollcross | 56.2138711117 | -2.7327559604 | |
| 34329537 | Elm Grove | 56.2080919945 | -2.7613405142 | |
| 34329532 | Station Road | 56.2078538059 | -2.7664460244 | |
| 34328529 | Wadeslea | 56.1911843902 | -2.8160175535 | |
| 34328479 | High Street | 56.1904819352 | -2.8189836183 | |
| 34328624 | Primary School | 56.1930930241 | -2.8222138165 | |
| 34329785 | Durham Wynd | 56.216307994 | -2.9385480622 | |
| 34329792 | Harbour Wynd | 56.2164438283 | -2.9419536499 | |
| 34329784 | Largo Road | 56.2162277272 | -2.9467211733 | |
| 34329743 | Crescent Road | 56.2137570126 | -2.9537223028 | |
| 34329736 | Bowling Green | 56.2133313582 | -2.956484924 | |
| 34329693 | Old Manor Hotel | 56.2125279511 | -2.9604472654 | |
| 34329872 | Simpson Institute | 56.2205493938 | -2.9265570954 | |
| 34329857 | Post Office | 56.2201290672 | -2.9286917115 | |
| 34329834 | Hollybank Cottage | 56.2184166556 | -2.9014792028 | |
| 34343529 | Alexandra Place | 56.3393668944 | -2.8010452625 | |
| 34382376 | Kinkell Braes Caravan Park | 56.3290504588 | -2.7745501125 | |
| 34345734 | Viewforth Place | 56.2141728291 | -2.737921147 | |
| 34398726 | Beley Farm | 56.2867059467 | -2.7468297261 | |
| 34347643 | Cauldcots Farm | 56.2352571032 | -2.7107569056 | |
| 34345873 | Pitkierie Garage | 56.242155592 | -2.7172741611 | |
| 34346497 | Bonerbo Farm | 56.2596346674 | -2.7273511397 | |
| 34348254 | Balmungo Steadings | 56.3225161933 | -2.7677400098 | |
| 34348252 | Ardross Farm | 56.1974893713 | -2.7942977187 | |
| 34347968 | Balchrystie Farm | 56.2158426902 | -2.8720083298 | |
| 34343547 | Bus Station | 56.3407304513 | -2.8027562149 | |
| 34329394 | Road End | 56.2041818901 | -2.8419875679 | |
| 34342654 | Primary School | 56.2891438981 | -2.7477980976 | |
| 34342386 | Smith Cottage | 56.2498873925 | -2.7179513345 | |
| 34342529 | Crossroads | 56.2667447766 | -2.7343962735 | |
| 34329589 | Farm Cottage | 56.2094418215 | -2.8558221846 |