Airyhall + Craigiebuckler - Sea Beach circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:50:00 | 09:50:00 | ... | 1 |
|
| ... | 09:50:00 | 09:50:00 | ... | 2 |
|
| ... | 09:51:00 | 09:51:00 | ... | 3 |
|
| ... | 09:52:00 | 09:52:00 | ... | 4 |
|
| ... | 09:53:00 | 09:53:00 | ... | 5 |
|
| ... | 09:54:00 | 09:54:00 | ... | 6 |
|
| ... | 09:55:00 | 09:55:00 | ... | 7 |
|
| ... | 09:56:00 | 09:56:00 | ... | 8 |
|
| ... | 09:57:00 | 09:57:00 | ... | 9 |
|
| ... | 09:57:00 | 09:57:00 | ... | 10 |
|
| ... | 09:58:00 | 09:58:00 | ... | 11 |
|
| ... | 09:59:00 | 09:59:00 | ... | 12 |
|
| ... | 10:00:00 | 10:00:00 | ... | 13 |
|
| ... | 10:01:00 | 10:01:00 | ... | 14 |
|
| ... | 10:02:00 | 10:02:00 | ... | 15 |
|
| ... | 10:02:00 | 10:02:00 | ... | 16 |
|
| ... | 10:03:00 | 10:03:00 | ... | 17 |
|
| ... | 10:04:00 | 10:04:00 | ... | 18 |
|
| ... | 10:05:00 | 10:05:00 | ... | 19 |
|
| ... | 10:08:00 | 10:08:00 | ... | 20 |
|
| ... | 10:09:00 | 10:09:00 | ... | 21 |
|
| ... | 10:12:00 | 10:12:00 | ... | 22 |
|
| ... | 10:14:00 | 10:14:00 | ... | 23 |
|
| ... | 10:16:00 | 10:16:00 | ... | 24 |
|
| ... | 10:18:00 | 10:18:00 | ... | 25 |
|
| ... | 10:18:00 | 10:18:00 | ... | 26 |
|
| ... | 10:20:00 | 10:20:00 | ... | 27 |
|
| ... | 10:20:00 | 10:20:00 | ... | 28 |
|
| ... | 10:21:00 | 10:21:00 | ... | 29 |
|
| ... | 10:22:00 | 10:22:00 | ... | 30 |
|
| ... | 10:22:00 | 10:22:00 | ... | 31 |
|
| ... | 10:23:00 | 10:23:00 | ... | 32 |
|
| ... | 10:26:00 | 10:26:00 | ... | 33 |
|
| ... | 10:26:00 | 10:26:00 | ... | 34 |
|
| ... | 10:28:00 | 10:28:00 | ... | 35 |
|
| ... | 10:30:00 | 10:30:00 | ... | 36 |
|
| ... | 10:31:00 | 10:31:00 | ... | 37 |
|
| ... | 10:32:00 | 10:32:00 | ... | 38 |
|
| ... | 10:35:00 | 10:35:00 | ... | 39 |
|
| ... | 10:38:00 | 10:38:00 | ... | 40 |
|
| ... | 10:40:00 | 10:40:00 | ... | 41 |
|
| ... | 10:41:00 | 10:41:00 | ... | 42 |
|
| ... | 10:44:00 | 10:44:00 | ... | 43 |
|
| ... | 10:46:00 | 10:46:00 | ... | 44 |
|
| ... | 10:50:00 | 10:50:00 | ... | 45 |
|
| ... | 10:51:00 | 10:51:00 | ... | 46 |
|
| ... | 10:51:00 | 10:51:00 | ... | 47 |
|
| ... | 10:52:00 | 10:52:00 | ... | 48 |
|
| ... | 10:53:00 | 10:53:00 | ... | 49 |
|
| ... | 10:54:00 | 10:54:00 | ... | 50 |
|
| ... | 10:54:00 | 10:54:00 | ... | 51 |
|
| ... | 10:55:00 | 10:55:00 | ... | 52 |
|
| ... | 10:55:00 | 10:55:00 | ... | 53 |
|
| ... | 10:56:00 | 10:56:00 | ... | 54 |
|
| ... | 10:58:00 | 10:58:00 | ... | 55 |
|
| ... | 10:58:00 | 10:58:00 | ... | 56 |
|
| ... | 11:00:00 | 11:00:00 | ... | 57 |
|
| ... | 11:01:00 | 11:01:00 | ... | 58 |
|
| ... | 11:02:00 | 11:02:00 | ... | 59 |
|
| ... | 11:03:00 | 11:03:00 | ... | 60 |
|
| ... | 11:03:00 | 11:03:00 | ... | 61 |
|
| ... | 11:04:00 | 11:04:00 | ... | 62 |
|
| ... | 11:05:00 | 11:05:00 | ... | 63 |
|
| ... | 11:06:00 | 11:06:00 | ... | 64 |
|
| ... | 11:08:00 | 11:08:00 | ... | 65 |
|
| ... | 11:08:00 | 11:08:00 | ... | 66 |
|
| ... | 11:09:00 | 11:09:00 | ... | 67 |
|
| ... | 11:10:00 | 11:10:00 | ... | 68 |
|
| ... | 11:11:00 | 11:11:00 | ... | 69 |
|
| ... | 11:12:00 | 11:12:00 | ... | 70 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 16/09/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 23234375 | Union Grove | 57.1410644233 | -2.1178289005 | |
| 23234378 | Union Grove | 57.1415065478 | -2.1157317894 | |
| 23234365 | Granton Place | 57.1405948866 | -2.1203720037 | |
| 23234369 | Albyn Grove | 57.1410004483 | -2.1189853451 | |
| 23234354 | Claremount Place | 57.1397203312 | -2.1236572314 | |
| 23234362 | Claremount Place | 57.1400626442 | -2.1226835106 | |
| 23234327 | Brighton Place | 57.1388266641 | -2.1279831614 | |
| 23234347 | St Swithin Street | 57.1394760482 | -2.1254078393 | |
| 23234295 | Forest Avenue | 57.1381495353 | -2.1312687536 | |
| 23234325 | Union Grove Lane | 57.1385462688 | -2.1298492293 | |
| 23234282 | Burns Road | 57.1374904284 | -2.1344221156 | |
| 23234292 | Burns Road | 57.1377608201 | -2.13358047 | |
| 23234267 | Cromwell Gardens | 57.1367860366 | -2.1378395442 | |
| 23234274 | Cromwell Gardens | 57.1370653076 | -2.1371136249 | |
| 23232982 | Mayfield Gardens | 57.1359310797 | -2.1392571921 | |
| 23232983 | Mayfield Gardens | 57.135543834 | -2.1401313549 | |
| 23232965 | Seafield Drive West | 57.1344712674 | -2.1432992589 | |
| 23232956 | Seafield Drive West | 57.13464219 | -2.1430851511 | |
| 23232898 | Viewfield Crescent | 57.1329479766 | -2.1477372347 | |
| 23232934 | Viewfield Avenue | 57.1333259239 | -2.147177058 | |
| 23232962 | Springfield Gardens | 57.1336729485 | -2.1499703666 | |
| 23232945 | Springfield Gardens | 57.1341307249 | -2.1502695897 | |
| 23234272 | Springfield Place | 57.1367052405 | -2.1532539345 | |
| 23234285 | Springfield Place | 57.1363465868 | -2.1527072411 | |
| 23234279 | Church | 57.1373036943 | -2.1560155708 | |
| 23234286 | Church | 57.137484114 | -2.1554050174 | |
| 23234263 | Craigiebuckler Place | 57.1366977585 | -2.1592512593 | |
| 23234269 | Craigiebuckler Place | 57.1368691482 | -2.158690258 | |
| 23234247 | Burnieboozle Crescent | 57.1360914819 | -2.1626850973 | |
| 23232797 | Braeside Place | 57.1294233157 | -2.1505147827 | |
| 23232784 | Airyhall Terrace | 57.1286091193 | -2.1552025964 | |
| 23232829 | Airyhall Crescent | 57.1299340888 | -2.15880921 | |
| 23232856 | Countesswells Terrace | 57.131044984 | -2.1611596893 | |
| 23232847 | Countesswells Terrace | 57.1307312794 | -2.1606131977 | |
| 23232897 | Pinewood Place | 57.1326771071 | -2.1633143725 | |
| 23232878 | Pinewood Place | 57.1325248696 | -2.1629502659 | |
| 23232923 | Pinewood Avenue | 57.1338078627 | -2.1641618973 | |
| 23235249 | Urquhart Road | 57.1545666051 | -2.0834242499 | |
| 23235254 | Beach Ballroom | 57.1549281068 | -2.0800860569 | |
| 23234989 | Beach Boulevard | 57.1541562426 | -2.0790265018 | |
| 23234954 | Constitution Street | 57.1534882704 | -2.0839838049 | |
| 23234674 | Wellington Street | 57.1463046538 | -2.0797203236 | |
| 23234632 | Halls Quay | 57.1450853005 | -2.0759664366 | |
| 23234563 | York Street | 57.143829268 | -2.0733033616 | |
| 23234937 | Beach Boulevard | 57.1519919231 | -2.0780962796 | |
| 23234829 | Beach Esplanade | 57.1501061197 | -2.0770841098 | |
| 23234864 | Cotton Street | 57.1509477344 | -2.0814823068 | |
| 23234394 | Holburn Junction | 57.141922361 | -2.1128909694 | |
| 23234396 | Holburn Junction | 57.1423902637 | -2.1120166165 | |
| 23234575 | Langstane Kirk | 57.144118571 | -2.1079567161 | |
| 23234568 | Langstane Kirk | 57.1440921053 | -2.1073947914 | |
| 23234594 | Music Hall | 57.1448394216 | -2.1053643549 | |
| 23234634 | Music Hall | 57.1453445316 | -2.1028869719 | |
| 23234739 | Castle Street | 57.1478305339 | -2.0943992229 | |
| 23234729 | St Andrew's Cathedral | 57.1490529405 | -2.0934437707 | |
| 23234654 | St Nicholas Kirk | 57.1462449637 | -2.100261862 | |
| 23236856 | St Nicholas Kirk | 57.1465607337 | -2.098544012 | |
| 23234723 | Adelphi | 57.1473349828 | -2.0963480688 | |
| 23236853 | Adelphi | 57.1472633856 | -2.0960008292 | |
| 23234843 | Hanover Street | 57.1501611252 | -2.0889510581 | |
| 23234798 | Wales Street | 57.1499093542 | -2.0892975299 | |
| 23234896 | Bannermill Place | 57.1510888495 | -2.0853997628 | |
| 23234895 | Bannermill Place | 57.1514672194 | -2.0837974012 | |
| 23237452 | Springbank Cemetery | 57.1310700612 | -2.1481262016 | |
| 23232854 | Library | 57.1320124929 | -2.1487907536 | |
| 23232862 | Macaulay Drive | 57.1321071562 | -2.1522437293 | |
| 23232873 | Macaulay Drive | 57.1314300881 | -2.1549666292 | |
| 23237526 | Airyhall Avenue | 57.1305723837 | -2.1584154931 | |
| 23236949 | Beach Retail Park | 57.1493756672 | -2.0815449493 |