Prestwick and Marchburn circular - Ayr + Dalmilling
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:14:00 | 09:14:00 | ... | 1 |
|
| ... | 09:15:06 | 09:15:06 | ... | 2 |
|
| ... | 09:15:56 | 09:15:56 | ... | 3 |
|
| ... | 09:16:44 | 09:16:44 | ... | 4 |
|
| ... | 09:17:20 | 09:17:20 | ... | 5 |
|
| ... | 09:18:09 | 09:18:09 | ... | 6 |
|
| ... | 09:19:12 | 09:19:12 | ... | 7 |
|
| ... | 09:19:43 | 09:19:43 | ... | 8 |
|
| ... | 09:20:36 | 09:20:36 | ... | 9 |
|
| ... | 09:21:10 | 09:21:10 | ... | 10 |
|
| ... | 09:21:41 | 09:21:41 | ... | 11 |
|
| ... | 09:22:18 | 09:22:18 | ... | 12 |
|
| ... | 09:23:00 | 09:23:00 | ... | 13 |
|
| ... | 09:24:00 | 09:24:00 | ... | 14 |
|
| ... | 09:25:26 | 09:25:26 | ... | 15 |
|
| ... | 09:26:22 | 09:26:22 | ... | 16 |
|
| ... | 09:27:36 | 09:27:36 | ... | 17 |
|
| ... | 09:28:01 | 09:28:01 | ... | 18 |
|
| ... | 09:28:44 | 09:28:44 | ... | 19 |
|
| ... | 09:29:38 | 09:29:38 | ... | 20 |
|
| ... | 09:31:04 | 09:31:04 | ... | 21 |
|
| ... | 09:32:00 | 09:32:00 | ... | 22 |
|
| ... | 09:32:51 | 09:32:51 | ... | 23 |
|
| ... | 09:34:08 | 09:34:08 | ... | 24 |
|
| ... | 09:35:04 | 09:35:04 | ... | 25 |
|
| ... | 09:36:15 | 09:36:15 | ... | 26 |
|
| ... | 09:37:42 | 09:37:42 | ... | 27 |
|
| ... | 09:38:36 | 09:38:36 | ... | 28 |
|
| ... | 09:40:00 | 09:40:00 | ... | 29 |
|
| ... | 09:41:03 | 09:41:03 | ... | 30 |
|
| ... | 09:42:27 | 09:42:27 | ... | 31 |
|
| ... | 09:43:07 | 09:43:07 | ... | 32 |
|
| ... | 09:44:00 | 09:44:00 | ... | 33 |
|
| ... | 09:44:44 | 09:44:44 | ... | 34 |
|
| ... | 09:45:55 | 09:45:55 | ... | 35 |
|
| ... | 09:46:35 | 09:46:35 | ... | 36 |
|
| ... | 09:47:34 | 09:47:34 | ... | 37 |
|
| ... | 09:48:04 | 09:48:04 | ... | 38 |
|
| ... | 09:49:43 | 09:49:43 | ... | 39 |
|
| ... | 09:50:32 | 09:50:32 | ... | 40 |
|
| ... | 09:52:00 | 09:52:00 | ... | 41 |
|
| ... | 09:55:32 | 09:55:32 | ... | 42 |
|
| ... | 09:59:00 | 09:59:00 | ... | 43 |
|
| ... | 10:00:19 | 10:00:19 | ... | 44 |
|
| ... | 10:01:32 | 10:01:32 | ... | 45 |
|
| ... | 10:02:11 | 10:02:11 | ... | 46 |
|
| ... | 10:03:16 | 10:03:16 | ... | 47 |
|
| ... | 10:04:00 | 10:04:00 | ... | 48 |
|
| ... | 10:04:34 | 10:04:34 | ... | 49 |
|
| ... | 10:05:40 | 10:05:40 | ... | 50 |
|
| ... | 10:06:35 | 10:06:35 | ... | 51 |
|
| ... | 10:07:11 | 10:07:11 | ... | 52 |
|
| ... | 10:08:00 | 10:08:00 | ... | 53 |
|
| ... | 10:09:09 | 10:09:09 | ... | 54 |
|
| ... | 10:10:22 | 10:10:22 | ... | 55 |
|
| ... | 10:11:19 | 10:11:19 | ... | 56 |
|
| ... | 10:12:25 | 10:12:25 | ... | 57 |
|
| ... | 10:13:22 | 10:13:22 | ... | 58 |
|
| ... | 10:14:11 | 10:14:11 | ... | 59 |
|
| ... | 10:15:19 | 10:15:19 | ... | 60 |
|
| ... | 10:16:23 | 10:16:23 | ... | 61 |
|
| ... | 10:17:22 | 10:17:22 | ... | 62 |
|
| ... | 10:18:55 | 10:18:55 | ... | 63 |
|
| ... | 10:19:48 | 10:19:48 | ... | 64 |
|
| ... | 10:20:43 | 10:20:43 | ... | 65 |
|
| ... | 10:21:52 | 10:21:52 | ... | 66 |
|
| ... | 10:23:00 | 10:23:00 | ... | 67 |
|
| ... | 10:23:45 | 10:23:45 | ... | 68 |
|
| ... | 10:24:37 | 10:24:37 | ... | 69 |
|
| ... | 10:25:39 | 10:25:39 | ... | 70 |
|
| ... | 10:27:01 | 10:27:01 | ... | 71 |
|
| ... | 10:28:17 | 10:28:17 | ... | 72 |
|
| ... | 10:29:13 | 10:29:13 | ... | 73 |
|
| ... | 10:30:21 | 10:30:21 | ... | 74 |
|
| ... | 10:32:18 | 10:32:18 | ... | 75 |
|
| ... | 10:34:00 | 10:34:00 | ... | 76 |
|
| ... | 10:35:42 | 10:35:42 | ... | 77 |
|
| ... | 10:37:36 | 10:37:36 | ... | 78 |
|
| ... | 10:38:23 | 10:38:23 | ... | 79 |
|
| ... | 10:38:53 | 10:38:53 | ... | 80 |
|
| ... | 10:39:48 | 10:39:48 | ... | 81 |
|
| ... | 10:40:18 | 10:40:18 | ... | 82 |
|
| ... | 10:40:45 | 10:40:45 | ... | 83 |
|
| ... | 10:41:24 | 10:41:24 | ... | 84 |
|
| ... | 10:42:11 | 10:42:11 | ... | 85 |
|
| ... | 10:42:50 | 10:42:50 | ... | 86 |
|
| ... | 10:44:00 | 10:44:00 | ... | 87 |
|
| ... | 10:44:48 | 10:44:48 | ... | 88 |
|
| ... | 10:45:47 | 10:45:47 | ... | 89 |
|
| ... | 10:46:42 | 10:46:42 | ... | 90 |
|
| ... | 10:47:48 | 10:47:48 | ... | 91 |
|
| ... | 10:48:55 | 10:48:55 | ... | 92 |
|
| ... | 10:50:47 | 10:50:47 | ... | 93 |
|
| ... | 10:52:04 | 10:52:04 | ... | 94 |
|
| ... | 10:54:18 | 10:54:18 | ... | 95 |
|
| ... | 10:56:00 | 10:56:00 | ... | 96 |
|
| 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 | |
|---|---|---|---|---|
| 29763769 | Content Avenue | 55.4596274866 | -4.619899728 | |
| 29724678 | Ayr Railway Station | 55.4585434314 | -4.6247633361 | |
| 29724643 | Ayr Railway Station | 55.4589170475 | -4.6241079443 | |
| 29724857 | John Street | 55.4603452637 | -4.6224784987 | |
| 29723786 | Fire Station | 55.4601774281 | -4.6223407961 | |
| 29724365 | Craigie Way | 55.4629088059 | -4.6190416259 | |
| 29723625 | Beech Grove | 55.4619261152 | -4.6086616137 | |
| 29724374 | Craigie Lea | 55.4623328093 | -4.6127701566 | |
| 29724834 | Craigie way | 55.4615034164 | -4.6145662351 | |
| 29723948 | Churchill Crescent | 55.4625224898 | -4.6009173266 | |
| 29724345 | Robertson Crescent | 55.4638714635 | -4.596655404 | |
| 29724535 | Dunlop Terrace | 55.4649900594 | -4.5935013927 | |
| 29724875 | Westwood Avenue | 55.4671907279 | -4.5999274188 | |
| 29723493 | Braehead Avenue | 55.4691522031 | -4.6015281472 | |
| 29724296 | Thorneyflat Street | 55.472674746 | -4.5892905746 | |
| 29724769 | Westwood Avenue | 55.4709143547 | -4.586674947 | |
| 29724659 | Thorneyflat Drive | 55.4701570418 | -4.5893311404 | |
| 29724369 | Dalmilling Drive | 55.4680567335 | -4.5968199116 | |
| 29723898 | Walker Road | 55.4685024264 | -4.6109316015 | |
| 29723678 | Hawkhill Avenue | 55.4680092884 | -4.6133989798 | |
| 29723478 | Craigie Road | 55.4675567793 | -4.6164860704 | |
| 29724726 | Newton Primary School | 55.4667377086 | -4.6249283424 | |
| 29723538 | Craigie Road | 55.4671400972 | -4.6195754703 | |
| 29724848 | Gould Street | 55.4699712114 | -4.6120256257 | |
| 29723629 | Walker Road | 55.4706567618 | -4.6140173142 | |
| 29723589 | St Georges Rd | 55.4735230457 | -4.6182741479 | |
| 29723946 | Cambuslea Road | 55.4753382098 | -4.6174608454 | |
| 29723294 | Ettrick Place | 55.4789414033 | -4.6154207204 | |
| 29724582 | Woodfield Avenue | 55.4822181359 | -4.6189777118 | |
| 29724768 | Woodfield Crescent | 55.4800469806 | -4.6204638571 | |
| 29724852 | Marchfield Road | 55.4836317492 | -4.6180268264 | |
| 29723429 | Bellesleyhill Road | 55.4774192163 | -4.6222835181 | |
| 29723543 | Lansdowne Road | 55.4760873725 | -4.6231920663 | |
| 29724835 | Tig Road | 55.4743355069 | -4.624404962 | |
| 29723846 | Caelaverock Road | 55.5022273003 | -4.6076057687 | |
| 29724625 | Merrick Avenue | 55.5012840479 | -4.6042019806 | |
| 29724789 | Manson Avenue | 55.5001084584 | -4.5986135636 | |
| 29723468 | Underwood Road | 55.4943573964 | -4.6040296044 | |
| 29724842 | Elmbank Street | 55.4718399526 | -4.6263436776 | |
| 29724579 | Police Station | 55.466614457 | -4.6285750849 | |
| 29724284 | Crown Street | 55.467569893 | -4.6301260252 | |
| 29723457 | Waggon Road | 55.4703784954 | -4.6278446436 | |
| 29724368 | Lilybank Road | 55.4856835162 | -4.6174981218 | |
| 29723728 | Bruce Avenue | 55.4881915535 | -4.6174903897 | |
| 29724869 | Kingscroft Road | 55.4906719163 | -4.6158343134 | |
| 29724645 | Brandon Gardens | 55.4926885918 | -4.6148439387 | |
| 29723526 | Grangemuir Road | 55.4949679295 | -4.6137600391 | |
| 29724686 | St. Quivox Road | 55.4969520606 | -4.6126089583 | |
| 29724354 | Kyle Street | 55.4985539217 | -4.611258265 | |
| 29724243 | Station Road | 55.5010118128 | -4.6110726427 | |
| 29724324 | St Ninians Pr School | 55.498193423 | -4.5990574212 | |
| 29723686 | Sanquhar Avenue | 55.4967703375 | -4.596651839 | |
| 29724689 | Raith Avenue | 55.4945110005 | -4.5946822601 | |
| 29723485 | Carnell Crescent | 55.4936970343 | -4.5987294524 | |
| 29724745 | Calvinston Road | 55.4862967246 | -4.6051913548 | |
| 29723285 | Ardfin Road | 55.4842738393 | -4.6060550262 | |
| 29723789 | Mosside Road | 55.4807715215 | -4.6092741889 | |
| 29723472 | Cathcart Street | 55.4638202686 | -4.6326924187 | |
| 29723473 | Killoch Place | 55.4583596952 | -4.6291329683 | |
| 29724738 | Burns Statue Square | 55.4585300909 | -4.6287330177 | |
| 29723835 | Carrick Street | 55.4614826655 | -4.6293725298 | |
| 29723896 | Town Hall | 55.4642952437 | -4.6315058457 | |
| 29723928 | Campbell Court | 55.4618011458 | -4.6060904824 | |
| 29723547 | Harthall | 55.4692137206 | -4.5927028854 | |
| 29723978 | Dalmilling Crescent | 55.4701757071 | -4.5990480055 | |
| 29724343 | West Sanquhar Road | 55.4719778099 | -4.6182349488 | |
| 29723258 | Churchill Crescent | 55.4627762675 | -4.6003961424 | |
| 29723632 | Biggart Hospital | 55.4920596247 | -4.6047170216 | |
| 29724385 | Moor Park Place | 55.4818329944 | -4.6071284233 | |
| 29724234 | Beech Grove | 55.4619628134 | -4.6082052496 | |
| 29723635 | Craigie Lea | 55.4623588597 | -4.612392189 | |
| 29724839 | Robertson Crescent | 55.463712079 | -4.5973885069 | |
| 29723894 | Tweed Street | 55.4778450136 | -4.6162501813 | |
| 29724232 | Heathpark | 55.4816815836 | -4.612120132 | |
| 29723787 | Campbell Court | 55.4618415361 | -4.6054603388 | |
| 29724248 | Heathfield Road | 55.4808496329 | -4.6136161928 | |
| 29725848 | East Park Road | 55.476809912 | -4.6167354831 | |
| 29724896 | Dalmilling Drive | 55.4704940648 | -4.5963314721 | |
| 29724897 | Thornyflat Drive | 55.4719126236 | -4.5925953139 | |
| 29724898 | Thornyflat Road | 55.4734517085 | -4.5916519651 | |
| 29724942 | Fullarton Street | 55.4611605861 | -4.6313918729 | |
| 29724953 | Craigie Road | 55.4626570774 | -4.6173637654 | |
| 29725475 | Parks Garage | 55.4788495023 | -4.6020249335 | |
| 29785927 | Parks Garage | 55.4788509451 | -4.6015343906 | |
| 29786248 | Churchill Crescent | 55.462010024 | -4.603035131 | |
| 29786257 | Craigie Way | 55.4619205983 | -4.6030134159 | |
| 29786246 | Mainholm Road | 55.4698773544 | -4.6012436424 | |
| 29789598 | Asda Superstore | 55.4802053032 | -4.5953243072 | |
| 29725232 | Craigie Way | 55.4617271437 | -4.6146126887 | |
| 29726938 | Outdale Avenue | 55.4949210223 | -4.6007734524 | |
| 29796458 | Dunlop Terrace | 55.4651805705 | -4.5934189773 | |
| 29796598 | Fairview | 55.4890467794 | -4.6039481639 | |
| 29796748 | Dam Park Sports Stadium | 55.4589881809 | -4.6161714572 | |
| 29734638 | Mainholm Crescent | 55.4664326274 | -4.5971086404 | |
| 29767347 | Mainholm Crescent | 55.46636342 | -4.5974047061 |