Clerwood - Eastfield or Seton Sands or Tranent

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 22:47:00 22:47:00 ... 1
... 22:48:00 22:48:00 ... 2
... 22:49:00 22:49:00 ... 3
... 22:50:00 22:50:00 ... 4
... 22:51:00 22:51:00 ... 5
... 22:52:00 22:52:00 ... 6
... 22:52:00 22:52:00 ... 7
... 22:53:00 22:53:00 ... 8
... 22:53:00 22:53:00 ... 9
... 22:54:00 22:54:00 ... 10
... 22:55:00 22:55:00 ... 11
... 22:56:00 22:56:00 ... 12
... 22:56:00 22:56:00 ... 13
... 22:57:00 22:57:00 ... 14
... 22:58:00 22:58:00 ... 15
... 22:59:00 22:59:00 ... 16
... 22:59:00 22:59:00 ... 17
... 23:00:00 23:00:00 ... 18
... 23:01:00 23:01:00 ... 19
... 23:01:00 23:01:00 ... 20
... 23:02:00 23:02:00 ... 21
... 23:03:00 23:03:00 ... 22
... 23:04:00 23:04:00 ... 23
... 23:04:00 23:04:00 ... 24
... 23:05:00 23:05:00 ... 25
... 23:06:00 23:06:00 ... 26
... 23:08:00 23:08:00 ... 27
... 23:10:00 23:10:00 ... 28
... 23:13:00 23:13:00 ... 29
... 23:16:00 23:16:00 ... 30
... 23:18:00 23:18:00 ... 31
... 23:19:00 23:19:00 ... 32
... 23:21:00 23:21:00 ... 33
... 23:22:00 23:22:00 ... 34
... 23:22:00 23:22:00 ... 35
... 23:23:00 23:23:00 ... 36
... 23:24:00 23:24:00 ... 37
... 23:25:00 23:25:00 ... 38
... 23:26:00 23:26:00 ... 39
... 23:27:00 23:27:00 ... 40
... 23:28:00 23:28:00 ... 41
... 23:29:00 23:29:00 ... 42
... 23:30:00 23:30:00 ... 43
... 23:31:00 23:31:00 ... 44
... 23:31:00 23:31:00 ... 45
... 23:32:00 23:32:00 ... 46
... 23:32:00 23:32:00 ... 47
... 23:33:00 23:33:00 ... 48
... 23:34:00 23:34:00 ... 49
... 23:35:00 23:35:00 ... 50
... 23:36:00 23:36:00 ... 51
... 23:36:00 23:36:00 ... 52
... 23:37:00 23:37:00 ... 53
... 23:37:00 23:37:00 ... 54
... 23:38:00 23:38:00 ... 55
... 23:39:00 23:39:00 ... 56
... 23:40:00 23:40:00 ... 57
... 23:40:00 23:40:00 ... 58
... 23:41:00 23:41:00 ... 59
... 23:42:00 23:42:00 ... 60
... 23:43:00 23:43:00 ... 61
... 23:43:00 23:43:00 ... 62
... 23:44:00 23:44:00 ... 63
... 23:45:00 23:45:00 ... 64
... 23:45:00 23:45:00 ... 65
... 23:46:00 23:46:00 ... 66
... 23:47:00 23:47:00 ... 67
... 23:48:00 23:48:00 ... 68
... 23:48:00 23:48:00 ... 69
... 23:49:00 23:49:00 ... 70
... 23:50:00 23:50:00 ... 71
... 23:50:00 23:50:00 ... 72
... 23:51:00 23:51:00 ... 73
... 23:51:00 23:51:00 ... 74
... 23:52:00 23:52:00 ... 75
... 23:52:00 23:52:00 ... 76
... 23:53:00 23:53:00 ... 77
... 23:54:00 23:54:00 ... 78
... 23:54:00 23:54:00 ... 79
... 23:55:00 23:55:00 ... 80
... 23:55:00 23:55:00 ... 81
... 23:56:00 23:56:00 ... 82
... 23:56:00 23:56:00 ... 83
... 23:57:00 23:57:00 ... 84
... 23:58:00 23:58:00 ... 85
... 23:58:00 23:58:00 ... 86
... 23:59:00 23:59:00 ... 87
... 00:00:00 00:00:00 ... 88
... 00:01:00 00:01:00 ... 89
... 00:01:00 00:01:00 ... 90
... 00:03:00 00:03:00 ... 91
... 00:04:00 00:04:00 ... 92
... 00:04:00 00:04:00 ... 93
... 00:05:00 00:05:00 ... 94
... 00:05:00 00:05:00 ... 95
... 00:06:00 00:06:00 ... 96
... 00:06:00 00:06:00 ... 97
... 00:07:00 00:07:00 ... 98
... 00:07:00 00:07:00 ... 99
... 00:08:00 00:08:00 ... 100
... 00:08:00 00:08:00 ... 101
... 00:09:00 00:09:00 ... 102
... 00:10:00 00:10:00 ... 103
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
58232529 Bankton Terrace 55.9559132918 -2.9630347677
58232524 Hawthorn Road Shops 55.957358345 -2.9689647848
58232346 Bowling Club 55.9552447665 -2.9973720689
58232354 Ox Walk 55.957514188 -2.9911678844
58232534 Johnny Cope Stone 55.9568149176 -2.959181186
58232526 Gardiner Crescent 55.9558900401 -2.967150314
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
58232497 Health Centre 55.9556815493 -2.9753613068
58232523 Polwarth Terrace 55.9567445038 -2.9716081697
58232367 Post Office 55.9593347404 -2.9837502642
58232748 St Joseph's 55.955500782 -2.9513649695
58232368 McLeod Crescent 55.9581337334 -2.9822462293
58232372 Castle Park 55.9550413385 -2.979044835
58232876 Police Station 55.9435516342 -2.9500472319
58232742 Fire Station 55.9472310694 -2.9552773409
58232746 Fowler Street 55.9487610383 -2.9561156744
58232737 Fa'side Lodge 55.9455231602 -2.9542105318
58234846 Toll House Grove 55.9371154776 -2.9504019198
58232878 Ross Crescent 55.9413573481 -2.9479602294
58232895 Miner's Cottages 55.9380144347 -2.9433321111
58232894 Carlaverock Avenue 55.9391783969 -2.9450413647
58232745 A1 Roundabout 55.9507262721 -2.9552833548
58235364 Toll House Grove 55.9369117419 -2.9523499292
58234837 Winton Court 55.9361927349 -2.9430317022
58234839 Winton Close 55.9356043129 -2.9459468013
© 2017 Molten Mouse LTD