Dumfries - Sandyhills
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 17:56:00 | 17:56:00 | ... | 1 |
|
| ... | 17:57:00 | 17:57:00 | ... | 2 |
|
| ... | 18:00:00 | 18:00:00 | ... | 3 |
|
| ... | 18:01:00 | 18:01:00 | ... | 4 |
|
| ... | 18:02:00 | 18:02:00 | ... | 5 |
|
| ... | 18:03:00 | 18:03:00 | ... | 6 |
|
| ... | 18:04:00 | 18:04:00 | ... | 7 |
|
| ... | 18:04:00 | 18:04:00 | ... | 8 |
|
| ... | 18:08:00 | 18:08:00 | ... | 9 |
|
| ... | 18:12:00 | 18:12:00 | ... | 10 |
|
| ... | 18:14:00 | 18:14:00 | ... | 11 |
|
| ... | 18:19:00 | 18:19:00 | ... | 12 |
|
| ... | 18:22:00 | 18:22:00 | ... | 13 |
|
| ... | 18:24:00 | 18:24:00 | ... | 14 |
|
| ... | 18:24:00 | 18:24:00 | ... | 15 |
|
| ... | 18:25:00 | 18:25:00 | ... | 16 |
|
| ... | 18:35:00 | 18:35:00 | ... | 17 |
|
| ... | 18:36:00 | 18:36:00 | ... | 18 |
|
| ... | 18:39:00 | 18:39:00 | ... | 19 |
|
| ... | 18:41:00 | 18:41:00 | ... | 20 |
|
| ... | 18:44:00 | 18:44:00 | ... | 21 |
|
| ... | 18:45:00 | 18:45:00 | ... | 22 |
|
| ... | 18:48:00 | 18:48:00 | ... | 23 |
|
| ... | 18:48:00 | 18:48:00 | ... | 24 |
|
| ... | 18:48:00 | 18:48:00 | ... | 25 |
|
| ... | 18:49:00 | 18:49:00 | ... | 26 |
|
| ... | 18:50:00 | 18:50:00 | ... | 27 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 01/04/2013 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 34232643 | Whitesands | 55.0686992366 | -3.6159573982 | |
| 34235679 | Troqueer Primary | 55.0611323385 | -3.6172808965 | |
| 34235752 | Post Office | 54.9797771257 | -3.6221337467 | |
| 34235753 | Kindar Drive | 54.9777310712 | -3.616504111 | |
| 34235758 | Village | 54.9165188469 | -3.5960129932 | |
| 34235759 | Village | 54.9165923479 | -3.5958910875 | |
| 34235762 | Village | 54.9228261477 | -3.5720292359 | |
| 34235768 | Holiday Village | 54.8752090523 | -3.5996789528 | |
| 34238464 | Southwick | 54.8978830406 | -3.6731716607 | |
| 34238294 | Village | 54.8801261852 | -3.7313275175 | |
| 34235678 | Pleasance Avenue | 55.062751985 | -3.6130713695 | |
| 34235692 | New Abbey Rd | 55.0606541549 | -3.6214736118 | |
| 34235687 | New Abbey Rd | 55.0598896032 | -3.6215209858 | |
| 34235737 | Cargenholm | 55.0445282797 | -3.6162672316 | |
| 34235739 | Village | 55.0380832363 | -3.6197321724 | |
| 34238674 | Mabie Forest | 55.0198946265 | -3.633045146 | |
| 34235745 | Whinnyhill | 55.008140082 | -3.624248175 | |
| 34235756 | Drumburn | 54.9428860524 | -3.5941069699 | |
| 34235785 | Road End | 54.9052834496 | -3.6110723542 | |
| 34235783 | Prestonmill | 54.9035312707 | -3.6151043582 | |
| 34235769 | Torrorie Farm | 54.8983685509 | -3.6255022274 | |
| 34235765 | Loaningfoot | 54.8856278486 | -3.6164769306 | |
| 34235767 | Loaningfoot | 54.8856113348 | -3.6163671392 | |
| 34238462 | Mainsriddle | 54.8944652757 | -3.6424042314 | |
| 34238467 | Southwick | 54.896700312 | -3.6768184938 | |
| 34238296 | Laggan | 54.8816628033 | -3.7167867477 | |
| 34235748 | Shambellie | 54.9892595939 | -3.622750745 |