Prestwick and Marchburn circular - Ayr + Dalmilling
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:05:00 | 12:05:00 | ... | 1 |
|
| ... | 12:06:14 | 12:06:14 | ... | 2 |
|
| ... | 12:07:10 | 12:07:10 | ... | 3 |
|
| ... | 12:08:04 | 12:08:04 | ... | 4 |
|
| ... | 12:09:40 | 12:09:40 | ... | 5 |
|
| ... | 12:10:37 | 12:10:37 | ... | 6 |
|
| ... | 12:11:12 | 12:11:12 | ... | 7 |
|
| ... | 12:12:11 | 12:12:11 | ... | 8 |
|
| ... | 12:12:50 | 12:12:50 | ... | 9 |
|
| ... | 12:13:24 | 12:13:24 | ... | 10 |
|
| ... | 12:14:05 | 12:14:05 | ... | 11 |
|
| ... | 12:14:53 | 12:14:53 | ... | 12 |
|
| ... | 12:16:00 | 12:16:00 | ... | 13 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 17/09/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 29724678 | Ayr Railway Station | 55.4585434314 | -4.6247633361 | |
| 29724857 | John Street | 55.4603452637 | -4.6224784987 | |
| 29723469 | Lymburn Place | 55.4631772002 | -4.6178412245 | |
| 29724738 | Burns Statue Square | 55.4585300909 | -4.6287330177 | |
| 29723258 | Churchill Crescent | 55.4627762675 | -4.6003961424 | |
| 29724234 | Beech Grove | 55.4619628134 | -4.6082052496 | |
| 29723635 | Craigie Lea | 55.4623588597 | -4.612392189 | |
| 29724839 | Robertson Crescent | 55.463712079 | -4.5973885069 | |
| 29723787 | Campbell Court | 55.4618415361 | -4.6054603388 | |
| 29724942 | Fullarton Street | 55.4611605861 | -4.6313918729 | |
| 29786248 | Churchill Crescent | 55.462010024 | -4.603035131 | |
| 29725232 | Craigie Way | 55.4617271437 | -4.6146126887 | |
| 29796458 | Dunlop Terrace | 55.4651805705 | -4.5934189773 |