Prestwick and Marchburn circular - Ayr + Dalmilling

Details

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
© 2017 Molten Mouse LTD