Prestwick and Marchburn circular - Ayr + Dalmilling

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 07:00:00 07:00:00 ... 1
... 07:01:10 07:01:10 ... 2
... 07:02:15 07:02:15 ... 3
... 07:02:50 07:02:50 ... 4
... 07:03:47 07:03:47 ... 5
... 07:04:27 07:04:27 ... 6
... 07:04:57 07:04:57 ... 7
... 07:05:56 07:05:56 ... 8
... 07:06:44 07:06:44 ... 9
... 07:07:16 07:07:16 ... 10
... 07:08:00 07:08:00 ... 11
... 07:09:09 07:09:09 ... 12
... 07:10:22 07:10:22 ... 13
... 07:11:19 07:11:19 ... 14
... 07:12:25 07:12:25 ... 15
... 07:13:22 07:13:22 ... 16
... 07:14:11 07:14:11 ... 17
... 07:15:19 07:15:19 ... 18
... 07:16:23 07:16:23 ... 19
... 07:17:22 07:17:22 ... 20
... 07:18:55 07:18:55 ... 21
... 07:19:48 07:19:48 ... 22
... 07:20:43 07:20:43 ... 23
... 07:21:52 07:21:52 ... 24
... 07:23:00 07:23:00 ... 25
... 07:23:37 07:23:37 ... 26
... 07:24:19 07:24:19 ... 27
... 07:25:10 07:25:10 ... 28
... 07:26:17 07:26:17 ... 29
... 07:27:20 07:27:20 ... 30
... 07:28:05 07:28:05 ... 31
... 07:29:01 07:29:01 ... 32
... 07:30:36 07:30:36 ... 33
... 07:32:00 07:32:00 ... 34
... 07:33:21 07:33:21 ... 35
... 07:34:53 07:34:53 ... 36
... 07:35:31 07:35:31 ... 37
... 07:35:55 07:35:55 ... 38
... 07:36:38 07:36:38 ... 39
... 07:37:03 07:37:03 ... 40
... 07:37:24 07:37:24 ... 41
... 07:37:55 07:37:55 ... 42
... 07:38:33 07:38:33 ... 43
... 07:39:04 07:39:04 ... 44
... 07:40:00 07:40:00 ... 45
... 07:40:40 07:40:40 ... 46
... 07:41:29 07:41:29 ... 47
... 07:42:15 07:42:15 ... 48
... 07:43:10 07:43:10 ... 49
... 07:44:05 07:44:05 ... 50
... 07:45:39 07:45:39 ... 51
... 07:46:43 07:46:43 ... 52
... 07:48:35 07:48:35 ... 53
... 07:50:00 07:50:00 ... 54
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
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
29723896 Town Hall 55.4642952437 -4.6315058457
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
29725475 Parks Garage 55.4788495023 -4.6020249335
29785927 Parks Garage 55.4788509451 -4.6015343906
29789598 Asda Superstore 55.4802053032 -4.5953243072
29726938 Outdale Avenue 55.4949210223 -4.6007734524
29796598 Fairview 55.4890467794 -4.6039481639
© 2017 Molten Mouse LTD