Scotstown - Auchinyell + Gathdee circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 14:33:00 14:33:00 ... 1
... 14:33:00 14:33:00 ... 2
... 14:34:00 14:34:00 ... 3
... 14:35:00 14:35:00 ... 4
... 14:35:00 14:35:00 ... 5
... 14:36:00 14:36:00 ... 6
... 14:36:00 14:36:00 ... 7
... 14:37:00 14:37:00 ... 8
... 14:38:00 14:38:00 ... 9
... 14:39:00 14:39:00 ... 10
... 14:40:00 14:40:00 ... 11
... 14:40:00 14:40:00 ... 12
... 14:41:00 14:41:00 ... 13
... 14:42:00 14:42:00 ... 14
... 14:44:00 14:44:00 ... 15
... 14:44:00 14:44:00 ... 16
... 14:46:00 14:46:00 ... 17
... 14:47:00 14:47:00 ... 18
... 14:47:00 14:47:00 ... 19
... 14:48:00 14:48:00 ... 20
... 14:49:00 14:49:00 ... 21
... 14:49:00 14:49:00 ... 22
... 14:50:00 14:50:00 ... 23
... 14:51:00 14:51:00 ... 24
... 14:52:00 14:52:00 ... 25
... 14:53:00 14:53:00 ... 26
... 14:53:00 14:53:00 ... 27
... 14:55:00 14:55:00 ... 28
... 14:56:00 14:56:00 ... 29
... 14:56:00 14:56:00 ... 30
... 14:57:00 14:57:00 ... 31
... 14:59:00 14:59:00 ... 32
... 15:02:00 15:02:00 ... 33
... 15:06:00 15:06:00 ... 34
... 15:09:00 15:09:00 ... 35
... 15:10:00 15:10:00 ... 36
... 15:14:00 15:14:00 ... 37
... 15:15:00 15:15:00 ... 38
... 15:16:00 15:16:00 ... 39
... 15:17:00 15:17:00 ... 40
... 15:17:00 15:17:00 ... 41
... 15:18:00 15:18:00 ... 42
... 15:19:00 15:19:00 ... 43
... 15:19:00 15:19:00 ... 44
... 15:20:00 15:20:00 ... 45
... 15:21:00 15:21:00 ... 46
... 15:22:00 15:22:00 ... 47
... 15:22:00 15:22:00 ... 48
... 15:23:00 15:23:00 ... 49
... 15:24:00 15:24:00 ... 50
... 15:25:00 15:25:00 ... 51
... 15:26:00 15:26:00 ... 52
... 15:27:00 15:27:00 ... 53
... 15:27:00 15:27:00 ... 54
... 15:29:00 15:29:00 ... 55
... 15:30:00 15:30:00 ... 56
... 15:31:00 15:31:00 ... 57
... 15:33:00 15:33:00 ... 58
... 15:34:00 15:34:00 ... 59
... 15:35:00 15:35:00 ... 60
... 15:36:00 15:36:00 ... 61
... 15:37:00 15:37:00 ... 62
... 15:38:00 15:38:00 ... 63
... 15:39:00 15:39:00 ... 64
... 15:40:00 15:40:00 ... 65
... 15:42:00 15:42:00 ... 66
... 15:42:00 15:42:00 ... 67
... 15:44:00 15:44:00 ... 68
... 15:46:00 15:46:00 ... 69
... 15:47:00 15:47:00 ... 70
... 15:49:00 15:49:00 ... 71
... 15:52:00 15:52:00 ... 72
... 15:53:00 15:53:00 ... 73
... 15:54:00 15:54:00 ... 74
... 15:55:00 15:55:00 ... 75
... 15:57:00 15:57:00 ... 76
... 15:57:00 15:57:00 ... 77
... 15:58:00 15:58:00 ... 78
... 15:59:00 15:59:00 ... 79
... 15:59:00 15:59:00 ... 80
... 16:01:00 16:01:00 ... 81
... 16:02:00 16:02:00 ... 82
... 16:02:00 16:02:00 ... 83
... 16:03:00 16:03:00 ... 84
... 16:04:00 16:04:00 ... 85
... 16:04:00 16:04:00 ... 86
... 16:05:00 16:05:00 ... 87
... 16:06:00 16:06:00 ... 88
... 16:07:00 16:07:00 ... 89
... 16:08:00 16:08:00 ... 90
... 16:08:00 16:08:00 ... 91
... 16:09:00 16:09:00 ... 92
... 16:10:00 16:10:00 ... 93
... 16:11:00 16:11:00 ... 94
... 16:12:00 16:12:00 ... 95
... 16:13:00 16:13:00 ... 96
... 16:14:00 16:14:00 ... 97
... 16:14:00 16:14:00 ... 98
... 16:15:00 16:15:00 ... 99
... 16:16:00 16:16:00 ... 100
... 16:17:00 16:17:00 ... 101
... 16:18:00 16:18:00 ... 102
start_date end_date monday tuesday wednesday thursday friday saturday sunday
16/09/2018 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
23232989 Broomhill Road 57.135766973 -2.115102554
23232957 Balmoral Place 57.1343381265 -2.1156928507
23232837 Abergeldie Road 57.1318218095 -2.1168413471
23232838 Crathie Terrace 57.1301505829 -2.1172490395
23232792 Riverside Terrace 57.128955268 -2.117856426
23232762 Ruthrieston Road 57.1264382518 -2.1197148409
23232743 Bridge Of Dee Court 57.124487538 -2.1211619585
23232695 Bridge Of Dee 57.123012372 -2.1231555115
23232675 Snowsports Centre 57.1212753718 -2.126436173
23232596 Craigievar Road 57.119896748 -2.1305434905
23232593 Inchbrae Road 57.1199878273 -2.1377605146
23232585 Gaitside Drive 57.119390187 -2.142018886
23232573 Garthdee Road 57.1190189916 -2.1445440691
23232574 Auchinyell Road 57.1193207719 -2.147666374
23232624 Morrison Drive 57.1202109068 -2.1469763215
23232653 Talisman Drive 57.1214989897 -2.1439592108
23232683 Gaitside Place 57.1223457125 -2.1419311263
23232679 Ramsay Crescent 57.1235526432 -2.1390785207
23232753 Auchinyell Terrace 57.1243822761 -2.1361747935
23232754 Auchinyell Gardens 57.1255620914 -2.1333547802
23232759 Morningside Gardens 57.1267058422 -2.1306005294
23232793 Ruthrieston Road 57.1281273123 -2.1285242984
23232832 Newlands Crescent 57.1299269818 -2.125507639
23232863 Gray Street 57.1316177433 -2.1235475663
23232953 Salisbury Terrace 57.1334705363 -2.121207883
23236582 Balmoral Place 57.1343978629 -2.1190467204
23234862 Mealmarket Street 57.1506155231 -2.0940592503
23234854 Mealmarket Street 57.1508582004 -2.0938780605
23234957 Jasmine Terrace 57.152708186 -2.0945604383
23234748 Jasmine Terrace 57.152115583 -2.0941952954
23235274 Mary Elmslie Court 57.1555283422 -2.0952288543
23235234 Urquhart Road 57.1542261857 -2.0947296162
23235363 Errol Street 57.157612041 -2.0956970899
23235323 Errol Street 57.1567948925 -2.09529824
23235424 Pittodrie Place 57.1599202229 -2.0962816863
23235359 St Peter Street 57.1580702615 -2.0955825583
23235494 Linksfield Road 57.1617793675 -2.0967163834
23235498 University Road 57.1624980182 -2.0967017312
23235436 Orchard Street 57.1608185332 -2.0962674944
23235632 University Road 57.1636474416 -2.0972172822
23235637 Regent Walk 57.1640248419 -2.0970694709
23235659 School Drive 57.1651293874 -2.0975353332
23235765 St Machar Drive 57.1675104386 -2.0968140629
23235728 School Road 57.166297469 -2.0971581157
23235789 Seaton Drive 57.1683104323 -2.0961547304
23235857 Seaton Place 57.1706377907 -2.0951520461
23235847 Seaton Place 57.1702515233 -2.0951510511
23235925 Lord Hay's Road 57.172669223 -2.0934538994
23235875 Lord Hay's Road 57.1721119825 -2.0938493875
23235945 Beach Esplanade 57.1741346933 -2.0917706988
23235932 Beach Esplanade 57.1735324947 -2.0922322679
23236592 Donmouth Road 57.176731862 -2.0902720604
23235974 Donmouth Road 57.1768398718 -2.0899746129
23236454 Whitestripes Avenue 57.1923779187 -2.1243629812
23236459 Whitestripes Avenue 57.1927459226 -2.12466206
23236468 Lee Crescent 57.1943713362 -2.1251639682
23236469 Lee Crescent 57.1946674747 -2.125462827
23236593 Lee Crescent North 57.1973785132 -2.1272592999
23236428 Newburgh Drive 57.1907485935 -2.1186161189
23236427 Foveran Rise 57.1905863985 -2.1191450597
23236438 Newburgh Drive 57.1913815785 -2.1141176308
23236434 Newburgh Drive 57.1913097302 -2.1141008628
23236452 Glashieburn Avenue 57.1917180526 -2.1095188318
23236453 Glashieburn Avenue 57.1915743402 -2.1095018594
23236398 Lochside Drive 57.1898887624 -2.1057576083
23236425 Lochside Drive 57.1901220248 -2.1061057313
23236378 Braehead Way 57.1883984713 -2.1047110238
23236383 Braehead Way 57.1879404385 -2.1045939134
23236364 Gordon Place 57.1856062457 -2.1029329568
23236363 Gordon Place 57.1852199793 -2.10293188
23236325 Cameron Terrace 57.1831550642 -2.1015034819
23236343 Cameron Road 57.183172869 -2.1017020392
23236283 Fraserfield Gardens 57.1813529176 -2.0971811845
23236284 Fraserfield Gardens 57.1812536804 -2.097726793
23236296 Broadfold Drive 57.1819308447 -2.0932126723
23236287 Broadfold Drive 57.1815709208 -2.0940223042
23236274 Hutcheon Gardens 57.1804234243 -2.0908765672
23236278 Hutcheon Gardens 57.1811600621 -2.0908287561
23236232 Balgownie Road 57.1780522726 -2.0903910692
23236239 Balgownie Crescent 57.178806948 -2.090244053
23236432 Whitestripes Avenue 57.1910043498 -2.1235310627
23237323 Whitestripes Way 57.1908609489 -2.123199667
23234324 Nellfield Place 57.1381212168 -2.1143498531
23234323 Nellfield Place 57.1383999613 -2.1140533116
23234353 Great Western Road 57.1396218301 -2.1138588029
23236486 Lee Crescent North 57.197566683 -2.1277233148
23236484 Lee Crescent 57.1956104489 -2.1256977017
23236492 Ashwood Drive 57.1989618703 -2.1249147384
23236489 Woodcroft Road 57.1988627444 -2.1252288413
23236494 Ashwood Park 57.1990093317 -2.1223331853
23234234 Holburn Place 57.1359639438 -2.1158135827
23234384 Holburn Junction 57.1415269898 -2.1130219532
23234393 Holburn Junction 57.1422913767 -2.1120989377
23234549 Langstane Kirk 57.1442086714 -2.1076430045
23234548 Langstane Kirk 57.1439389253 -2.1079396669
23234598 Music Hall 57.1449115633 -2.1050340547
23234586 Music Hall 57.1445156154 -2.1058591858
23234745 Castle Street 57.1479205381 -2.09416808
23234724 Castle Street 57.1477679266 -2.0940354788
23234672 St Nicholas Kirk 57.1462990072 -2.1000802236
23234643 St Nicholas Kirk 57.1461553321 -2.1000137314
© 2017 Molten Mouse LTD