Dalkeith - The Jewel ASDA
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:00:00 | 16:00:00 | ... | 1 |
|
| ... | 16:08:00 | 16:08:00 | ... | 2 |
|
| ... | 16:09:00 | 16:09:00 | ... | 3 |
|
| ... | 16:10:00 | 16:10:00 | ... | 4 |
|
| ... | 16:11:00 | 16:11:00 | ... | 5 |
|
| ... | 16:12:00 | 16:12:00 | ... | 6 |
|
| ... | 16:14:00 | 16:14:00 | ... | 7 |
|
| ... | 16:14:00 | 16:14:00 | ... | 8 |
|
| ... | 16:15:00 | 16:15:00 | ... | 9 |
|
| ... | 16:16:00 | 16:16:00 | ... | 10 |
|
| ... | 16:17:00 | 16:17:00 | ... | 11 |
|
| ... | 16:18:00 | 16:18:00 | ... | 12 |
|
| ... | 16:19:00 | 16:19:00 | ... | 13 |
|
| ... | 16:20:00 | 16:20:00 | ... | 14 |
|
| ... | 16:21:00 | 16:21:00 | ... | 15 |
|
| ... | 16:23:00 | 16:23:00 | ... | 16 |
|
| ... | 16:25:00 | 16:25:00 | ... | 17 |
|
| ... | 16:26:00 | 16:26:00 | ... | 18 |
|
| ... | 16:27:00 | 16:27:00 | ... | 19 |
|
| ... | 16:28:00 | 16:28:00 | ... | 20 |
|
| ... | 16:30:00 | 16:30:00 | ... | 21 |
|
| ... | 16:31:00 | 16:31:00 | ... | 22 |
|
| ... | 16:32:00 | 16:32:00 | ... | 23 |
|
| ... | 16:34:00 | 16:34:00 | ... | 24 |
|
| ... | 16:35:00 | 16:35:00 | ... | 25 |
|
| ... | 16:37:00 | 16:37:00 | ... | 26 |
|
| ... | 16:38:00 | 16:38:00 | ... | 27 |
|
| ... | 16:40:00 | 16:40:00 | ... | 28 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 01/05/2014 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36234384 | Asda The Jewel | 55.9388507593 | -3.1043241543 | |
| 58232794 | Main Road | 55.9224138483 | -3.0669069331 | |
| 64325797 | Kaimes View | 55.9111101244 | -3.1046232196 | |
| 64325798 | Forth View Crescent | 55.9138117368 | -3.1089557759 | |
| 64325825 | Woolmet Crescent | 55.9149011426 | -3.1087148915 | |
| 64325768 | Access Road | 55.9135205728 | -3.0932846109 | |
| 64326923 | The Circle | 55.9149067544 | -3.1110829653 | |
| 64326924 | Arthur View Terrace | 55.9137889512 | -3.1114829604 | |
| 64326925 | Campview Crescent | 55.9122694626 | -3.1056000902 | |
| 64326926 | Campview Avenue | 55.9096121123 | -3.106340317 | |
| 64326927 | Campview Terrace | 55.910669314 | -3.1076822356 | |
| 64329252 | Campend | 55.902713185 | -3.0960834153 | |
| 64342457 | Forth View | 55.9124438806 | -3.1071888959 | |
| 64323957 | Millerhill Road | 55.9149267156 | -3.0958200981 | |
| 64325845 | St Andrew Street | 55.893656422 | -3.0694594864 | |
| 64323587 | Old Dalkeith Road | 55.9105769975 | -3.1099512667 | |
| 64323584 | Edmonstone Road | 55.9144168594 | -3.1076131207 | |
| 64323482 | Croft Street | 55.8927540228 | -3.0730004779 | |
| 64325838 | South Melville | 55.8890098163 | -3.0890617107 | |
| 64325839 | Station Road | 55.888786193 | -3.0828358738 | |
| 64323492 | Glenesk Crescent | 55.8896547622 | -3.0790866708 | |
| 64323932 | Newton Cottages | 55.9185327855 | -3.0730406259 | |
| 64323928 | Easter Millerhill | 55.9135460611 | -3.0822621473 | |
| 64323936 | Wester Millerhill | 55.9111083336 | -3.0876654753 | |
| 64323962 | Newton Church Road | 55.9132104856 | -3.0948117564 | |
| 64323586 | Newton Church Road | 55.9125432639 | -3.1051279307 | |
| 64323595 | Smithy Green Avenue | 55.9111583047 | -3.110255839 | |
| 64323963 | Newton Church Road | 55.9141086596 | -3.094853073 |