Dumfries - Castle Douglas
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:25:00 | 14:25:00 | ... | 1 |
|
| ... | 14:28:00 | 14:28:00 | ... | 2 |
|
| ... | 14:30:00 | 14:30:00 | ... | 3 |
|
| ... | 14:30:00 | 14:30:00 | ... | 4 |
|
| ... | 14:30:00 | 14:30:00 | ... | 5 |
|
| ... | 14:30:00 | 14:30:00 | ... | 6 |
|
| ... | 14:33:00 | 14:33:00 | ... | 7 |
|
| ... | 14:33:00 | 14:33:00 | ... | 8 |
|
| ... | 14:36:00 | 14:36:00 | ... | 9 |
|
| ... | 14:40:00 | 14:40:00 | ... | 10 |
|
| ... | 14:42:00 | 14:42:00 | ... | 11 |
|
| ... | 14:49:00 | 14:49:00 | ... | 12 |
|
| ... | 14:58:00 | 14:58:00 | ... | 13 |
|
| ... | 15:05:00 | 15:05:00 | ... | 14 |
|
| ... | 15:05:00 | 15:05:00 | ... | 15 |
|
| ... | 15:09:00 | 15:09:00 | ... | 16 |
|
| ... | 15:14:00 | 15:14:00 | ... | 17 |
|
| ... | 15:17:00 | 15:17:00 | ... | 18 |
|
| ... | 15:23:00 | 15:23:00 | ... | 19 |
|
| ... | 15:24:00 | 15:24:00 | ... | 20 |
|
| ... | 15:25:00 | 15:25:00 | ... | 21 |
|
| ... | 15:25:00 | 15:25:00 | ... | 22 |
|
| ... | 15:26:00 | 15:26:00 | ... | 23 |
|
| ... | 15:26:00 | 15:26:00 | ... | 24 |
|
| ... | 15:28:00 | 15:28:00 | ... | 25 |
|
| ... | 15:29:00 | 15:29:00 | ... | 26 |
|
| ... | 15:30:00 | 15:30:00 | ... | 27 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 03/04/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 34232643 | Whitesands | 55.0686992366 | -3.6159573982 | |
| 34234626 | Loreburne Centre | 55.0665163226 | -3.6097775657 | |
| 34238492 | Railway Station | 55.0722541413 | -3.6047140725 | |
| 34236282 | DuPont | 55.0540499435 | -3.6441418597 | |
| 34236483 | Carlingwark Street | 54.9379456596 | -3.9338492489 | |
| 34236234 | Village Hall | 55.0457015356 | -3.7233292467 | |
| 34236249 | Village | 55.0106002783 | -3.8673750758 | |
| 34238494 | Village | 55.0115272688 | -3.8974931034 | |
| 34238496 | Village | 54.9893596347 | -3.9126404637 | |
| 34238629 | Village | 54.9734911229 | -3.927745193 | |
| 34238535 | Dunmuir Road | 54.9489209674 | -3.9281301879 | |
| 34235952 | Royal Bank | 54.9402587048 | -3.9302602492 | |
| 34236389 | Markethill | 54.9431513867 | -3.92638631 | |
| 34235975 | Village | 55.0166751293 | -3.8012751921 | |
| 34236273 | Maxweltown West Church | 55.0678285978 | -3.6206048814 | |
| 34239239 | Ettrick Court | 55.0649760072 | -3.6249212691 | |
| 34239349 | Cassalands | 55.0658573262 | -3.6235319247 | |
| 34239343 | Medical centre | 54.9498571466 | -3.9223659595 | |
| 34236259 | Ernespie Road | 54.9485853226 | -3.9209467109 | |
| 34236263 | Ernespie Road | 54.9484257364 | -3.9213763226 | |
| 34236262 | Ernespie Road | 54.9468037381 | -3.9233444344 | |
| 34236264 | Ernespie Road | 54.9468525945 | -3.9230969346 | |
| 34236247 | Lochview Motel | 55.0235739771 | -3.8458887715 | |
| 34235985 | Drumsleet | 55.0517225445 | -3.6514197735 | |
| 34235982 | Tregallon | 55.0517056573 | -3.6756680875 | |
| 34235978 | Northpark | 55.0486094221 | -3.7127940828 | |
| 34238746 | Primary | 55.0101379655 | -3.8693866569 |