Prestwick and Marchburn circular - Ayr + Dalmilling
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:16:00 | 15:16:00 | ... | 1 |
|
| ... | 15:16:53 | 15:16:53 | ... | 2 |
|
| ... | 15:18:02 | 15:18:02 | ... | 3 |
|
| ... | 15:18:36 | 15:18:36 | ... | 4 |
|
| ... | 15:19:20 | 15:19:20 | ... | 5 |
|
| ... | 15:19:56 | 15:19:56 | ... | 6 |
|
| ... | 15:20:56 | 15:20:56 | ... | 7 |
|
| ... | 15:21:29 | 15:21:29 | ... | 8 |
|
| ... | 15:22:18 | 15:22:18 | ... | 9 |
|
| ... | 15:22:43 | 15:22:43 | ... | 10 |
|
| ... | 15:24:06 | 15:24:06 | ... | 11 |
|
| ... | 15:24:46 | 15:24:46 | ... | 12 |
|
| ... | 15:26:00 | 15:26:00 | ... | 13 |
|
| ... | 15:28:01 | 15:28:01 | ... | 14 |
|
| ... | 15:30:00 | 15:30:00 | ... | 15 |
|
| ... | 15:31:10 | 15:31:10 | ... | 16 |
|
| ... | 15:32:15 | 15:32:15 | ... | 17 |
|
| ... | 15:32:50 | 15:32:50 | ... | 18 |
|
| ... | 15:33:47 | 15:33:47 | ... | 19 |
|
| ... | 15:34:27 | 15:34:27 | ... | 20 |
|
| ... | 15:34:57 | 15:34:57 | ... | 21 |
|
| ... | 15:35:56 | 15:35:56 | ... | 22 |
|
| ... | 15:36:44 | 15:36:44 | ... | 23 |
|
| ... | 15:37:16 | 15:37:16 | ... | 24 |
|
| ... | 15:38:00 | 15:38:00 | ... | 25 |
|
| ... | 15:39:09 | 15:39:09 | ... | 26 |
|
| ... | 15:40:22 | 15:40:22 | ... | 27 |
|
| ... | 15:41:19 | 15:41:19 | ... | 28 |
|
| ... | 15:42:25 | 15:42:25 | ... | 29 |
|
| ... | 15:43:22 | 15:43:22 | ... | 30 |
|
| ... | 15:44:11 | 15:44:11 | ... | 31 |
|
| ... | 15:45:19 | 15:45:19 | ... | 32 |
|
| ... | 15:46:23 | 15:46:23 | ... | 33 |
|
| ... | 15:47:22 | 15:47:22 | ... | 34 |
|
| ... | 15:48:55 | 15:48:55 | ... | 35 |
|
| ... | 15:49:48 | 15:49:48 | ... | 36 |
|
| ... | 15:50:43 | 15:50:43 | ... | 37 |
|
| ... | 15:51:52 | 15:51:52 | ... | 38 |
|
| ... | 15:53:00 | 15:53:00 | ... | 39 |
|
| ... | 15:53:37 | 15:53:37 | ... | 40 |
|
| ... | 15:54:19 | 15:54:19 | ... | 41 |
|
| ... | 15:55:10 | 15:55:10 | ... | 42 |
|
| ... | 15:56:17 | 15:56:17 | ... | 43 |
|
| ... | 15:57:20 | 15:57:20 | ... | 44 |
|
| ... | 15:58:05 | 15:58:05 | ... | 45 |
|
| ... | 15:59:01 | 15:59:01 | ... | 46 |
|
| ... | 16:00:36 | 16:00:36 | ... | 47 |
|
| ... | 16:02:00 | 16:02:00 | ... | 48 |
|
| ... | 16:03:11 | 16:03:11 | ... | 49 |
|
| ... | 16:04:31 | 16:04:31 | ... | 50 |
|
| ... | 16:05:04 | 16:05:04 | ... | 51 |
|
| ... | 16:05:25 | 16:05:25 | ... | 52 |
|
| ... | 16:06:04 | 16:06:04 | ... | 53 |
|
| ... | 16:06:25 | 16:06:25 | ... | 54 |
|
| ... | 16:06:44 | 16:06:44 | ... | 55 |
|
| ... | 16:07:11 | 16:07:11 | ... | 56 |
|
| ... | 16:07:44 | 16:07:44 | ... | 57 |
|
| ... | 16:08:11 | 16:08:11 | ... | 58 |
|
| ... | 16:09:00 | 16:09:00 | ... | 59 |
|
| ... | 16:09:40 | 16:09:40 | ... | 60 |
|
| ... | 16:10:29 | 16:10:29 | ... | 61 |
|
| ... | 16:11:15 | 16:11:15 | ... | 62 |
|
| ... | 16:12:10 | 16:12:10 | ... | 63 |
|
| ... | 16:13:05 | 16:13:05 | ... | 64 |
|
| ... | 16:14:39 | 16:14:39 | ... | 65 |
|
| ... | 16:15:43 | 16:15:43 | ... | 66 |
|
| ... | 16:17:35 | 16:17:35 | ... | 67 |
|
| ... | 16:19:00 | 16:19:00 | ... | 68 |
|
| 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 | |
|---|---|---|---|---|
| 29724643 | Ayr Railway Station | 55.4589170475 | -4.6241079443 | |
| 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 | |
| 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 | |
| 29723835 | Carrick Street | 55.4614826655 | -4.6293725298 | |
| 29723896 | Town Hall | 55.4642952437 | -4.6315058457 | |
| 29723928 | Campbell Court | 55.4618011458 | -4.6060904824 | |
| 29724343 | West Sanquhar Road | 55.4719778099 | -4.6182349488 | |
| 29723632 | Biggart Hospital | 55.4920596247 | -4.6047170216 | |
| 29724385 | Moor Park Place | 55.4818329944 | -4.6071284233 | |
| 29723894 | Tweed Street | 55.4778450136 | -4.6162501813 | |
| 29724232 | Heathpark | 55.4816815836 | -4.612120132 | |
| 29724248 | Heathfield Road | 55.4808496329 | -4.6136161928 | |
| 29725848 | East Park Road | 55.476809912 | -4.6167354831 | |
| 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 | |
| 29786257 | Craigie Way | 55.4619205983 | -4.6030134159 | |
| 29789598 | Asda Superstore | 55.4802053032 | -4.5953243072 | |
| 29726938 | Outdale Avenue | 55.4949210223 | -4.6007734524 | |
| 29796598 | Fairview | 55.4890467794 | -4.6039481639 |