Marchburn and Prestwick circular - Ayr
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 08:00:00 | 08:00:00 | ... | 1 |
|
| ... | 08:01:12 | 08:01:12 | ... | 2 |
|
| ... | 08:01:57 | 08:01:57 | ... | 3 |
|
| ... | 08:02:50 | 08:02:50 | ... | 4 |
|
| ... | 08:03:27 | 08:03:27 | ... | 5 |
|
| ... | 08:04:02 | 08:04:02 | ... | 6 |
|
| ... | 08:04:30 | 08:04:30 | ... | 7 |
|
| ... | 08:04:57 | 08:04:57 | ... | 8 |
|
| ... | 08:05:27 | 08:05:27 | ... | 9 |
|
| ... | 08:06:19 | 08:06:19 | ... | 10 |
|
| ... | 08:06:47 | 08:06:47 | ... | 11 |
|
| ... | 08:07:22 | 08:07:22 | ... | 12 |
|
| ... | 08:07:52 | 08:07:52 | ... | 13 |
|
| ... | 08:08:14 | 08:08:14 | ... | 14 |
|
| ... | 08:09:05 | 08:09:05 | ... | 15 |
|
| ... | 08:09:23 | 08:09:23 | ... | 16 |
|
| ... | 08:09:40 | 08:09:40 | ... | 17 |
|
| ... | 08:10:20 | 08:10:20 | ... | 18 |
|
| ... | 08:11:48 | 08:11:48 | ... | 19 |
|
| ... | 08:13:00 | 08:13:00 | ... | 20 |
|
| ... | 08:14:02 | 08:14:02 | ... | 21 |
|
| ... | 08:15:08 | 08:15:08 | ... | 22 |
|
| ... | 08:15:50 | 08:15:50 | ... | 23 |
|
| ... | 08:16:16 | 08:16:16 | ... | 24 |
|
| ... | 08:16:58 | 08:16:58 | ... | 25 |
|
| ... | 08:17:50 | 08:17:50 | ... | 26 |
|
| ... | 08:18:21 | 08:18:21 | ... | 27 |
|
| ... | 08:19:01 | 08:19:01 | ... | 28 |
|
| ... | 08:19:31 | 08:19:31 | ... | 29 |
|
| ... | 08:20:00 | 08:20:00 | ... | 30 |
|
| ... | 08:20:53 | 08:20:53 | ... | 31 |
|
| ... | 08:21:32 | 08:21:32 | ... | 32 |
|
| ... | 08:22:01 | 08:22:01 | ... | 33 |
|
| ... | 08:22:40 | 08:22:40 | ... | 34 |
|
| ... | 08:23:10 | 08:23:10 | ... | 35 |
|
| ... | 08:23:40 | 08:23:40 | ... | 36 |
|
| ... | 08:24:17 | 08:24:17 | ... | 37 |
|
| ... | 08:24:45 | 08:24:45 | ... | 38 |
|
| ... | 08:25:17 | 08:25:17 | ... | 39 |
|
| ... | 08:26:00 | 08:26:00 | ... | 40 |
|
| ... | 08:26:31 | 08:26:31 | ... | 41 |
|
| ... | 08:26:54 | 08:26:54 | ... | 42 |
|
| ... | 08:27:35 | 08:27:35 | ... | 43 |
|
| ... | 08:28:02 | 08:28:02 | ... | 44 |
|
| ... | 08:28:31 | 08:28:31 | ... | 45 |
|
| ... | 08:29:09 | 08:29:09 | ... | 46 |
|
| ... | 08:29:39 | 08:29:39 | ... | 47 |
|
| ... | 08:30:16 | 08:30:16 | ... | 48 |
|
| ... | 08:30:59 | 08:30:59 | ... | 49 |
|
| ... | 08:31:49 | 08:31:49 | ... | 50 |
|
| ... | 08:32:24 | 08:32:24 | ... | 51 |
|
| ... | 08:32:56 | 08:32:56 | ... | 52 |
|
| ... | 08:33:27 | 08:33:27 | ... | 53 |
|
| ... | 08:34:11 | 08:34:11 | ... | 54 |
|
| ... | 08:34:22 | 08:34:22 | ... | 55 |
|
| ... | 08:35:05 | 08:35:05 | ... | 56 |
|
| ... | 08:36:16 | 08:36:16 | ... | 57 |
|
| ... | 08:36:50 | 08:36:50 | ... | 58 |
|
| ... | 08:37:00 | 08:37:00 | ... | 59 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 15/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 29723698 | Walker Road | 55.4686387544 | -4.6108615027 | |
| 29723289 | Hawkhill Avenue | 55.4681552689 | -4.6132978836 | |
| 29724238 | Hawkhill Avenue | 55.4677352871 | -4.6165453688 | |
| 29724757 | Newton Primary School | 55.4669016503 | -4.6248284859 | |
| 29724584 | Burnett Terrace | 55.4672234288 | -4.619881626 | |
| 29723729 | Walker Road | 55.4698894143 | -4.6120676839 | |
| 29723893 | Wilson Street | 55.4707177649 | -4.6145277162 | |
| 29724293 | Tweed Street | 55.4779600127 | -4.6163369387 | |
| 29723723 | Woodfield Avenue | 55.4821483575 | -4.6188781098 | |
| 29723873 | Pleasantfield Road | 55.484697165 | -4.6173851966 | |
| 29723637 | Kirkholm Avenue | 55.4792286426 | -4.6209001616 | |
| 29723295 | Alderston Avenue | 55.4771302897 | -4.6223434526 | |
| 29724838 | Northfield Avenue | 55.4752876551 | -4.6235978598 | |
| 29723956 | McCalls Avenue | 55.4734722755 | -4.6248381404 | |
| 29724252 | The Cross | 55.5020628733 | -4.6094160787 | |
| 29723432 | Berelands Road | 55.5014578343 | -4.6070164532 | |
| 29723837 | Merrick Avenue | 55.5012450042 | -4.6047694993 | |
| 29723879 | McNeill Avenue | 55.5005764696 | -4.6019699139 | |
| 29723986 | Newdykes Road | 55.5017805792 | -4.6007191286 | |
| 29723657 | Shaw Road | 55.5012075796 | -4.598495967 | |
| 29723745 | Sherwood Road | 55.499380046 | -4.5986289028 | |
| 29724325 | Police Station | 55.4668213926 | -4.6289844206 | |
| 29724742 | Crown Street | 55.467938104 | -4.6297233404 | |
| 29724393 | Waggon Road | 55.4703901868 | -4.6277188318 | |
| 29724624 | Crandleyhill road | 55.4889085911 | -4.6167464095 | |
| 29723423 | Mansfield Road | 55.4911474575 | -4.6154542163 | |
| 29723842 | Meadowbank Lane | 55.4929632788 | -4.6146088249 | |
| 29723937 | Southpark Avenue | 55.4945440283 | -4.6138269468 | |
| 29723643 | St. Quivox Road | 55.4970558606 | -4.612378319 | |
| 29723726 | Gardiner Street | 55.4983115676 | -4.611242217 | |
| 29723743 | Saunterne Road | 55.5002884618 | -4.6108505515 | |
| 29723985 | Calvinston Road | 55.4861045234 | -4.6053527927 | |
| 29723682 | Heathpark | 55.4818477425 | -4.6123368991 | |
| 29723472 | Cathcart Street | 55.4638202686 | -4.6326924187 | |
| 29723549 | Newmarket Street | 55.4630278462 | -4.630250641 | |
| 29723923 | Carrick Street | 55.4617658551 | -4.631669511 | |
| 29724256 | Heathfield Road | 55.4812220415 | -4.6134350946 | |
| 29724247 | St Georges Road | 55.4734747833 | -4.618429196 | |
| 29723292 | Cambuslea Road | 55.4752630201 | -4.6176141157 | |
| 29723525 | Rowallan Crescent | 55.494079254 | -4.6048503979 | |
| 29723262 | Ardfin Road | 55.4844796171 | -4.6061002767 | |
| 29723764 | Mosside Road | 55.4808307711 | -4.6090248609 | |
| 29723246 | Moorefield Road | 55.4920476197 | -4.60485872 | |
| 29725843 | East Park Road | 55.4768248219 | -4.6168789083 | |
| 29724925 | Britannia Place | 55.4719842623 | -4.6187734049 | |
| 29724942 | Fullarton Street | 55.4611605861 | -4.6313918729 | |
| 29725428 | Stewart Road | 55.4803504044 | -4.6142637181 | |
| 29725454 | Moor Park Place | 55.4818575652 | -4.6072408445 | |
| 29725475 | Parks Garage | 55.4788495023 | -4.6020249335 | |
| 29785927 | Parks Garage | 55.4788509451 | -4.6015343906 | |
| 29789598 | Asda Superstore | 55.4802053032 | -4.5953243072 | |
| 29726929 | Sanquhar Avenue | 55.4938806748 | -4.5981240631 | |
| 29726932 | Raith Avenue | 55.494530218 | -4.5950476902 | |
| 29726934 | Sanquhar Avenue | 55.4967659758 | -4.5968573965 | |
| 29726935 | Adamton Road | 55.4980850374 | -4.5990819473 | |
| 29726937 | Outdale Avenue | 55.4950763052 | -4.6006570239 | |
| 29795964 | Waterloo Road | 55.4870260199 | -4.6173497374 | |
| 29796596 | Fairview | 55.4887627996 | -4.6041985463 | |
| 29764842 | Waggon Road | 55.4710054932 | -4.6271110067 |