Gyle Centre or Broomhouse - The Jewel
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:57:00 | 14:57:00 | ... | 1 |
|
| ... | 14:58:00 | 14:58:00 | ... | 2 |
|
| ... | 14:58:00 | 14:58:00 | ... | 3 |
|
| ... | 14:59:00 | 14:59:00 | ... | 4 |
|
| ... | 15:00:00 | 15:00:00 | ... | 5 |
|
| ... | 15:03:00 | 15:03:00 | ... | 6 |
|
| ... | 15:04:00 | 15:04:00 | ... | 7 |
|
| ... | 15:07:00 | 15:07:00 | ... | 8 |
|
| ... | 15:08:00 | 15:08:00 | ... | 9 |
|
| ... | 15:09:00 | 15:09:00 | ... | 10 |
|
| ... | 15:10:00 | 15:10:00 | ... | 11 |
|
| ... | 15:11:00 | 15:11:00 | ... | 12 |
|
| ... | 15:13:00 | 15:13:00 | ... | 13 |
|
| ... | 15:13:00 | 15:13:00 | ... | 14 |
|
| ... | 15:14:00 | 15:14:00 | ... | 15 |
|
| ... | 15:15:00 | 15:15:00 | ... | 16 |
|
| ... | 15:16:00 | 15:16:00 | ... | 17 |
|
| ... | 15:17:00 | 15:17:00 | ... | 18 |
|
| ... | 15:18:00 | 15:18:00 | ... | 19 |
|
| ... | 15:19:00 | 15:19:00 | ... | 20 |
|
| ... | 15:21:00 | 15:21:00 | ... | 21 |
|
| ... | 15:22:00 | 15:22:00 | ... | 22 |
|
| ... | 15:23:00 | 15:23:00 | ... | 23 |
|
| ... | 15:24:00 | 15:24:00 | ... | 24 |
|
| ... | 15:25:00 | 15:25:00 | ... | 25 |
|
| ... | 15:26:00 | 15:26:00 | ... | 26 |
|
| ... | 15:28:00 | 15:28:00 | ... | 27 |
|
| ... | 15:29:00 | 15:29:00 | ... | 28 |
|
| ... | 15:31:00 | 15:31:00 | ... | 29 |
|
| ... | 15:32:00 | 15:32:00 | ... | 30 |
|
| ... | 15:33:00 | 15:33:00 | ... | 31 |
|
| ... | 15:34:00 | 15:34:00 | ... | 32 |
|
| ... | 15:36:00 | 15:36:00 | ... | 33 |
|
| ... | 15:37:00 | 15:37:00 | ... | 34 |
|
| ... | 15:38:00 | 15:38:00 | ... | 35 |
|
| ... | 15:40:00 | 15:40:00 | ... | 36 |
|
| ... | 15:41:00 | 15:41:00 | ... | 37 |
|
| ... | 15:42:00 | 15:42:00 | ... | 38 |
|
| ... | 15:42:00 | 15:42:00 | ... | 39 |
|
| ... | 15:44:00 | 15:44:00 | ... | 40 |
|
| ... | 15:45:00 | 15:45:00 | ... | 41 |
|
| ... | 15:46:00 | 15:46:00 | ... | 42 |
|
| ... | 15:48:00 | 15:48:00 | ... | 43 |
|
| ... | 15:49:00 | 15:49:00 | ... | 44 |
|
| ... | 15:51:00 | 15:51:00 | ... | 45 |
|
| ... | 15:52:00 | 15:52:00 | ... | 46 |
|
| ... | 15:53:00 | 15:53:00 | ... | 47 |
|
| ... | 15:54:00 | 15:54:00 | ... | 48 |
|
| ... | 15:55:00 | 15:55:00 | ... | 49 |
|
| ... | 15:56:00 | 15:56:00 | ... | 50 |
|
| ... | 15:57:00 | 15:57:00 | ... | 51 |
|
| ... | 15:58:00 | 15:58:00 | ... | 52 |
|
| ... | 15:58:00 | 15:58:00 | ... | 53 |
|
| ... | 15:59:00 | 15:59:00 | ... | 54 |
|
| ... | 15:59:00 | 15:59:00 | ... | 55 |
|
| ... | 16:00:00 | 16:00:00 | ... | 56 |
|
| ... | 16:01:00 | 16:01:00 | ... | 57 |
|
| ... | 16:02:00 | 16:02:00 | ... | 58 |
|
| ... | 16:02:00 | 16:02:00 | ... | 59 |
|
| ... | 16:03:00 | 16:03:00 | ... | 60 |
|
| ... | 16:03:00 | 16:03:00 | ... | 61 |
|
| ... | 16:04:00 | 16:04:00 | ... | 62 |
|
| ... | 16:05:00 | 16:05:00 | ... | 63 |
|
| ... | 16:06:00 | 16:06:00 | ... | 64 |
|
| ... | 16:07:00 | 16:07:00 | ... | 65 |
|
| ... | 16:07:00 | 16:07:00 | ... | 66 |
|
| ... | 16:08:00 | 16:08:00 | ... | 67 |
|
| 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 | |
|---|---|---|---|---|
| 36245969 | Hermiston Gait Retail Park | 55.9273570826 | -3.3072895065 | |
| 36247243 | Bankhead Broadway | 55.9280313722 | -3.2996136902 | |
| 36236827 | Broomhouse Roundabout | 55.9294419585 | -3.28679225 | |
| 36247257 | Lochside Court | 55.9317449404 | -3.3112469087 | |
| 36243626 | Edinburgh Park Station | 55.9277070365 | -3.3081815735 | |
| 36242468 | Gyle Centre | 55.9381556535 | -3.314249172 | |
| 36247694 | Lochside Crescent | 55.9346962579 | -3.3159249174 | |
| 36247426 | Lochside Place | 55.9331772457 | -3.3134402894 | |
| 36236794 | Broomhouse Avenue | 55.9303303336 | -3.2843247409 | |
| 36236796 | Broomhouse Gardens | 55.931094742 | -3.2808126062 | |
| 36236797 | Saughton House | 55.9313741344 | -3.2764040131 | |
| 36235787 | Saughton Road North | 55.932216184 | -3.2731823028 | |
| 36235792 | Saughton Mains Street | 55.9336708261 | -3.2654343726 | |
| 36235793 | Stenhouse Grove | 55.933579182 | -3.2629822456 | |
| 36235794 | Stenhouse Cross | 55.9329691377 | -3.2593767845 | |
| 36235795 | Whitson Grove | 55.9346688242 | -3.2557181117 | |
| 36235796 | Whitson Crescent | 55.9359604432 | -3.2524141491 | |
| 36235873 | Balgreen Primary School | 55.9364921199 | -3.247836836 | |
| 36232687 | Stevenson Grove | 55.9358853645 | -3.2456401897 | |
| 36232689 | Westfield Avenue | 55.9373827717 | -3.2432869104 | |
| 36236258 | Westfield Road | 55.9370490034 | -3.2398503287 | |
| 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 | |
| 36236395 | Torphichen Street | 55.9470573045 | -3.2129322201 | |
| 36238362 | Dewer Place | 55.9466888431 | -3.2111112601 | |
| 36242864 | Morrison Street | 55.945735347 | -3.2084714812 | |
| 36236398 | Bread Street | 55.9458952272 | -3.204073053 | |
| 36236437 | West Port | 55.9464088045 | -3.2002459704 | |
| 36236438 | Grassmarket | 55.9474471514 | -3.1960346485 | |
| 36236453 | Merchant Street | 55.9476945553 | -3.1927595888 | |
| 36236454 | Bristo Place | 55.946185431 | -3.1899270153 | |
| 36253583 | Potterrow | 55.9460331097 | -3.1870881458 | |
| 36238636 | Nicolson Square | 55.9461355796 | -3.1857782605 | |
| 36234758 | Surgeons' Hall | 55.9458042428 | -3.1847273323 | |
| 36234796 | St Partick Square | 55.9430717999 | -3.1829467067 | |
| 36234798 | Bernard Terrace | 55.9413630671 | -3.1812295202 | |
| 36234787 | East Preston Street | 55.9393145473 | -3.1783974938 | |
| 36234824 | Royal Commonwealth Pool | 55.9383865885 | -3.1730062212 | |
| 36234825 | Marchhall Place | 55.936845795 | -3.1706223932 | |
| 36234826 | Priestfield Road | 55.9343066071 | -3.1673923187 | |
| 36236286 | Prestonfield Terrace | 55.9335321252 | -3.1647278339 | |
| 36236289 | Clearburn Crescent | 55.9336561008 | -3.1611139153 | |
| 36236293 | Prestonfield Park | 55.9329955972 | -3.157780712 | |
| 36234543 | Prestonfield Avenue | 55.9324335153 | -3.1544825647 | |
| 36234545 | Kings Haugh | 55.9323868129 | -3.1508316462 | |
| 36234546 | Craigmillar Castle Gardens | 55.9320738388 | -3.1448839295 | |
| 36234594 | Craigmillar Castle | 55.9327464378 | -3.1401817534 | |
| 36234595 | Craigmillar Castle Loan | 55.9330035232 | -3.1376442035 | |
| 36234596 | Harewood Drive | 55.9327340975 | -3.1347070588 | |
| 36234597 | Wauchope Avenue | 55.9322225013 | -3.1317148747 | |
| 36234598 | Wauchope Road | 55.9328806359 | -3.1275562736 | |
| 36234623 | Hay Avenue | 55.9337429052 | -3.123659558 | |
| 36234624 | Hay Drive | 55.9342488916 | -3.1203926881 | |
| 36234625 | Jack Kane Sports Centre | 55.9340442384 | -3.1181937769 | |
| 36234626 | Niddrie Mill Avenue | 55.9339090949 | -3.1152605544 | |
| 36239859 | Niddrie Mill | 55.9342762394 | -3.1144067047 | |
| 36234386 | Niddrie Mill Crescent | 55.9357906129 | -3.1148663999 | |
| 36234389 | The Jewel | 55.9382037253 | -3.1153039363 | |
| 36234365 | Parrotshot | 55.9389849322 | -3.1123806698 | |
| 36234368 | Corbiewynd | 55.9395070956 | -3.1082811828 | |
| 36234372 | Milton Link | 55.939745129 | -3.1057904763 | |
| 36253239 | Asda The Jewel | 55.9387947081 | -3.1045626979 |