Riccarton - Queen Margaret University
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:36:00 | 07:36:00 | ... | 1 |
|
| ... | 07:37:00 | 07:37:00 | ... | 2 |
|
| ... | 07:37:00 | 07:37:00 | ... | 3 |
|
| ... | 07:38:00 | 07:38:00 | ... | 4 |
|
| ... | 07:39:00 | 07:39:00 | ... | 5 |
|
| ... | 07:41:00 | 07:41:00 | ... | 6 |
|
| ... | 07:42:00 | 07:42:00 | ... | 7 |
|
| ... | 07:44:00 | 07:44:00 | ... | 8 |
|
| ... | 07:45:00 | 07:45:00 | ... | 9 |
|
| ... | 07:46:00 | 07:46:00 | ... | 10 |
|
| ... | 07:47:00 | 07:47:00 | ... | 11 |
|
| ... | 07:48:00 | 07:48:00 | ... | 12 |
|
| ... | 07:49:00 | 07:49:00 | ... | 13 |
|
| ... | 07:50:00 | 07:50:00 | ... | 14 |
|
| ... | 07:50:00 | 07:50:00 | ... | 15 |
|
| ... | 07:51:00 | 07:51:00 | ... | 16 |
|
| ... | 07:54:00 | 07:54:00 | ... | 17 |
|
| ... | 07:57:00 | 07:57:00 | ... | 18 |
|
| ... | 07:59:00 | 07:59:00 | ... | 19 |
|
| ... | 08:02:00 | 08:02:00 | ... | 20 |
|
| ... | 08:04:00 | 08:04:00 | ... | 21 |
|
| ... | 08:05:00 | 08:05:00 | ... | 22 |
|
| ... | 08:06:00 | 08:06:00 | ... | 23 |
|
| ... | 08:09:00 | 08:09:00 | ... | 24 |
|
| ... | 08:10:00 | 08:10:00 | ... | 25 |
|
| ... | 08:11:00 | 08:11:00 | ... | 26 |
|
| ... | 08:12:00 | 08:12:00 | ... | 27 |
|
| ... | 08:13:00 | 08:13:00 | ... | 28 |
|
| ... | 08:14:00 | 08:14:00 | ... | 29 |
|
| ... | 08:16:00 | 08:16:00 | ... | 30 |
|
| 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 | |
|---|---|---|---|---|
| 36234753 | North Bridge | 55.9517819915 | -3.1882089701 | |
| 36234756 | South Bridge | 55.9490191088 | -3.1867952007 | |
| 36234642 | Goff Avenue | 55.9572290492 | -3.1258135946 | |
| 36234643 | Telferton | 55.957023127 | -3.1276976009 | |
| 36234645 | Parker Road | 55.9565662817 | -3.1314642418 | |
| 36234646 | Moira Terrace | 55.9562745553 | -3.134851233 | |
| 36234647 | Piershill Cemetery | 55.9558437009 | -3.1386985655 | |
| 36234724 | Piershill Square East | 55.9550149327 | -3.1447443026 | |
| 36234725 | Piershill Square West | 55.9550146224 | -3.1476752272 | |
| 36234737 | Meadowbank House | 55.9550784783 | -3.1523858404 | |
| 36234738 | Meadowbank Stadium | 55.95559596 | -3.1566135022 | |
| 36234739 | Wishaw Terrace | 55.9563313797 | -3.1615365176 | |
| 36234742 | Marionville Road | 55.9567029017 | -3.1640622781 | |
| 36234743 | Carlyle Place | 55.9571890591 | -3.1677607757 | |
| 36234745 | Brunton Place | 55.9575401964 | -3.1733613273 | |
| 36234746 | Wellington Street | 55.957635264 | -3.1765836562 | |
| 36234747 | Brunswick Street | 55.9577181974 | -3.1801259774 | |
| 36234748 | Leopold Place | 55.9577895223 | -3.1829952363 | |
| 36253587 | Leith Street | 55.9554548157 | -3.186575728 | |
| 36239432 | National Museum of Scotland | 55.9472537674 | -3.1900238383 | |
| 36236465 | Lauriston Place | 55.9453783816 | -3.1906868556 | |
| 36236464 | Lauriston Building | 55.9448430991 | -3.1949296004 | |
| 36236462 | Chalmers Street | 55.944811537 | -3.1981790494 | |
| 36232563 | Home Street | 55.9428813952 | -3.2035312053 | |
| 36232565 | Leven Street | 55.9413557303 | -3.2033397855 | |
| 36232567 | Whitehouse Loan | 55.9389066915 | -3.20476873 | |
| 36237252 | Bruntsfield Place | 55.9363935874 | -3.2081485396 | |
| 36232568 | Holy Corner | 55.9347847867 | -3.2100193945 | |
| 36239595 | Napier University | 55.933445913 | -3.2118505025 | |
| 36239584 | George Watsons College | 55.9314978511 | -3.2171358417 |