Clerwood - Eastfield or Seton Sands or Tranent

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 18:22:00 18:22:00 ... 1
... 18:23:00 18:23:00 ... 2
... 18:24:00 18:24:00 ... 3
... 18:25:00 18:25:00 ... 4
... 18:27:00 18:27:00 ... 5
... 18:27:00 18:27:00 ... 6
... 18:28:00 18:28:00 ... 7
... 18:29:00 18:29:00 ... 8
... 18:29:00 18:29:00 ... 9
... 18:30:00 18:30:00 ... 10
... 18:31:00 18:31:00 ... 11
... 18:32:00 18:32:00 ... 12
... 18:32:00 18:32:00 ... 13
... 18:33:00 18:33:00 ... 14
... 18:34:00 18:34:00 ... 15
... 18:35:00 18:35:00 ... 16
... 18:36:00 18:36:00 ... 17
... 18:37:00 18:37:00 ... 18
... 18:38:00 18:38:00 ... 19
... 18:38:00 18:38:00 ... 20
... 18:39:00 18:39:00 ... 21
... 18:40:00 18:40:00 ... 22
... 18:41:00 18:41:00 ... 23
... 18:42:00 18:42:00 ... 24
... 18:43:00 18:43:00 ... 25
... 18:44:00 18:44:00 ... 26
... 18:46:00 18:46:00 ... 27
... 18:49:00 18:49:00 ... 28
... 18:52:00 18:52:00 ... 29
... 18:55:00 18:55:00 ... 30
... 18:58:00 18:58:00 ... 31
... 18:59:00 18:59:00 ... 32
... 19:01:00 19:01:00 ... 33
... 19:02:00 19:02:00 ... 34
... 19:02:00 19:02:00 ... 35
... 19:03:00 19:03:00 ... 36
... 19:04:00 19:04:00 ... 37
... 19:05:00 19:05:00 ... 38
... 19:06:00 19:06:00 ... 39
... 19:07:00 19:07:00 ... 40
... 19:08:00 19:08:00 ... 41
... 19:10:00 19:10:00 ... 42
... 19:11:00 19:11:00 ... 43
... 19:12:00 19:12:00 ... 44
... 19:13:00 19:13:00 ... 45
... 19:14:00 19:14:00 ... 46
... 19:15:00 19:15:00 ... 47
... 19:16:00 19:16:00 ... 48
... 19:17:00 19:17:00 ... 49
... 19:18:00 19:18:00 ... 50
... 19:19:00 19:19:00 ... 51
... 19:20:00 19:20:00 ... 52
... 19:20:00 19:20:00 ... 53
... 19:21:00 19:21:00 ... 54
... 19:22:00 19:22:00 ... 55
... 19:22:00 19:22:00 ... 56
... 19:23:00 19:23:00 ... 57
... 19:24:00 19:24:00 ... 58
... 19:25:00 19:25:00 ... 59
... 19:26:00 19:26:00 ... 60
... 19:27:00 19:27:00 ... 61
... 19:28:00 19:28:00 ... 62
... 19:30:00 19:30:00 ... 63
... 19:31:00 19:31:00 ... 64
... 19:31:00 19:31:00 ... 65
... 19:32:00 19:32:00 ... 66
... 19:33:00 19:33:00 ... 67
... 19:34:00 19:34:00 ... 68
... 19:35:00 19:35:00 ... 69
... 19:36:00 19:36:00 ... 70
... 19:36:00 19:36:00 ... 71
... 19:37:00 19:37:00 ... 72
... 19:38:00 19:38:00 ... 73
... 19:38:00 19:38:00 ... 74
... 19:39:00 19:39:00 ... 75
... 19:40:00 19:40:00 ... 76
... 19:41:00 19:41:00 ... 77
... 19:42:00 19:42:00 ... 78
... 19:42:00 19:42:00 ... 79
... 19:43:00 19:43:00 ... 80
... 19:43:00 19:43:00 ... 81
... 19:44:00 19:44:00 ... 82
... 19:44:00 19:44:00 ... 83
... 19:45:00 19:45:00 ... 84
... 19:45:00 19:45:00 ... 85
... 19:46:00 19:46:00 ... 86
... 19:47:00 19:47:00 ... 87
... 19:47:00 19:47:00 ... 88
... 19:47:00 19:47:00 ... 89
... 19:48:00 19:48:00 ... 90
... 19:48:00 19:48:00 ... 91
... 19:49:00 19:49:00 ... 92
... 19:49:00 19:49:00 ... 93
... 19:50:00 19:50:00 ... 94
... 19:50:00 19:50:00 ... 95
... 19:51:00 19:51:00 ... 96
start_date end_date monday tuesday wednesday thursday friday saturday sunday
29/07/2018 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
36238285 Clerwood Terminus 55.9499289172 -3.2790483553
36238286 Rannoch Road 55.953663637 -3.2784988652
36237636 Clermiston Crescent 55.9562677335 -3.281259534
36237632 Drum Brae Hub 55.9555817274 -3.2867305516
36237626 Drum Brae Drive 55.9545022545 -3.2937098032
36237624 Drum Brae North 55.9537864296 -3.2968410472
36237578 Duart Crescent 55.9525736315 -3.2968165082
36237598 Drum Brae Park 55.94968628 -3.2953907946
36237597 Drum Brae Gardens 55.9487035954 -3.2948455363
36237594 Templeland Road 55.9452807054 -3.2939306683
36243478 Drum Brae South 55.942912871 -3.2918022427
36236589 St Ninians Road 55.943196509 -3.2870242574
36236587 Glebe Road 55.9429349914 -3.2836692094
36238768 Station Road 55.9425133567 -3.2792842098
36236586 Belgrave Road 55.9418820675 -3.2734354281
36235925 Edinburgh Zoo 55.942331536 -3.2673179413
36236583 Pinkhill 55.9425322475 -3.2652750713
36236584 Balgreen Road 55.9439968539 -3.2573810167
36238343 Belmont Crescent 55.9444730761 -3.2547384729
36236585 Western Corner 55.9449865529 -3.2501916253
36239658 Murrayfield Road 55.9453584824 -3.2445192572
36232652 Ormidale Terrace 55.9457421197 -3.2403363126
36232653 Roseburn Gardens 55.9457942288 -3.2351499535
36232654 Wester Coates 55.9457947425 -3.2288090552
36232656 Magdala Crescent 55.9460248263 -3.222843684
36232657 Haymarket Station 55.9459542015 -3.2181818345
36232637 West Maitland Street 55.9469130734 -3.2157139433
36236572 Shandwick Place 55.9496334176 -3.2095537641
36235972 Princes Street (west) 55.9512566262 -3.2016130961
36232496 South St David Street 55.9530753958 -3.1938379456
36232497 Dublin Street 55.9560849593 -3.1920406419
36232498 York Place 55.9566384478 -3.1886941293
36232576 Leopold Place 55.9579589659 -3.1831285445
36232579 Brunswick Street 55.957854841 -3.1789929096
36232582 Wellington Street 55.9577975668 -3.176524512
36232583 Brunton Place 55.9576869714 -3.1730454249
36234256 Carlyle Place 55.9573425267 -3.1676853122
36234258 Marionville Road 55.9568411239 -3.1636980405
36234259 Wishaw Terrace 55.9561768444 -3.1598181187
36234262 Meadowbank Stadium 55.955800312 -3.1568598429
36234263 Meadowbank House 55.9551431531 -3.1512346033
36234264 Piershill Square West 55.9551936846 -3.1477445909
36234265 Piershill Square East 55.9552123129 -3.145743128
36234267 Piersfield Terrace 55.9554634307 -3.1419226727
36234269 Piershill Cemetery 55.9561970335 -3.1374116042
36234272 Moira Terrace 55.9565040011 -3.1333523855
36234273 Parker Road 55.9568546016 -3.1303995317
36234274 Goff Avenue 55.9573917674 -3.1257062001
36234278 King's Road 55.9564694748 -3.1204259863
36234279 Bridge Street 55.9549318774 -3.117578772
36234283 Portobello Town Hall 55.9531606537 -3.1147250701
36234284 Windsor Place 55.9521808826 -3.111782217
36234285 Bellfield Lane 55.9517126873 -3.1098950882
36234286 Pitville Street 55.950802296 -3.1062177956
36234287 Brunstane Road North 55.9499960086 -3.1029439835
36234289 Morton Street 55.9493198061 -3.1001864318
36234292 Coillesdene Drive 55.9488807886 -3.0950016515
36234293 Seaview Terrace 55.9487159744 -3.0912979212
36234294 Joppa Pans 55.9485946102 -3.0867307263
36234295 Coillesdene Avenue 55.9478206634 -3.0827858741
58232783 Health Centre 55.9428905409 -3.0555418713
58232768 Maitland Park Road 55.9451312157 -3.0718067637
58232782 Brunton Theatre 55.9440253423 -3.0583747267
58232679 Loretto RC Primary School 55.9422668774 -3.0475516348
58232649 Windsor Park Place 55.9429955012 -3.0293349426
58234692 Pinkie Mains 55.9421659743 -3.032899287
58232653 Ashgrove South End 55.9414092885 -3.036337345
58232864 Police Station 55.9423500722 -3.0525491921
58232327 Westpans 55.9479183234 -3.0197457635
58234728 Park Lane 55.9409755612 -3.0408886169
58232767 Edinburgh Road 55.9457232977 -3.0750095198
58232675 King Street 55.9403806603 -3.0464120444
58232323 Hope Place 55.945187669 -3.0250539257
58232325 Ravenshaugh Crescent 55.9463030598 -3.0227456183
58232769 Ship Inn 55.9440642848 -3.0642839739
58232383 Links 55.965907865 -2.9718057954
58232384 Power Station 55.968793669 -2.9670396913
58232427 Links View 55.9722049157 -2.9419209971
58232387 East Lorimer Place 55.969436029 -2.9630342864
58232424 Fishers Road 55.9721677916 -2.950267941
58232426 Castle Terrace 55.9722987682 -2.9449195393
58232398 Post Office 55.9717718095 -2.9526776416
58232396 Cope Lane 55.9713117787 -2.9552299169
58232394 Inglis Avenue 55.9709494937 -2.9567591237
58232392 School Lane 55.9700776375 -2.960262418
58232346 Bowling Club 55.9552447665 -2.9973720689
58232354 Ox Walk 55.957514188 -2.9911678844
58232365 Lidl 55.9627489474 -2.9769968256
58235365 Preston Links 55.9639981948 -2.9746894747
58232359 Ayres Wynd 55.9598715711 -2.9840361861
58232357 Cemetery 55.9586596281 -2.9872729426
58232352 Inchview North 55.9564468268 -2.9942798017
58232343 Morrison's Haven 55.9531891457 -3.0059673012
58232329 Mining Museum 55.9496539725 -3.0141225924
58232362 Harlawhill 55.9612337251 -2.9811073763
58232452 Road End 55.9721586568 -2.9314570382
© 2017 Molten Mouse LTD