Dalkeith - Gorebridge and Bonnyrigg circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 11:20:00 11:20:00 ... 1
... 11:22:00 11:22:00 ... 2
... 11:22:00 11:22:00 ... 3
... 11:23:00 11:23:00 ... 4
... 11:24:00 11:24:00 ... 5
... 11:25:00 11:25:00 ... 6
... 11:25:00 11:25:00 ... 7
... 11:26:00 11:26:00 ... 8
... 11:27:00 11:27:00 ... 9
... 11:28:00 11:28:00 ... 10
... 11:29:00 11:29:00 ... 11
... 11:30:00 11:30:00 ... 12
... 11:31:00 11:31:00 ... 13
... 11:32:00 11:32:00 ... 14
... 11:32:00 11:32:00 ... 15
... 11:33:00 11:33:00 ... 16
... 11:35:00 11:35:00 ... 17
... 11:35:00 11:35:00 ... 18
... 11:36:00 11:36:00 ... 19
... 11:36:00 11:36:00 ... 20
... 11:37:00 11:37:00 ... 21
... 11:38:00 11:38:00 ... 22
... 11:39:00 11:39:00 ... 23
... 11:40:00 11:40:00 ... 24
... 11:42:00 11:42:00 ... 25
... 11:42:00 11:42:00 ... 26
... 11:43:00 11:43:00 ... 27
... 11:44:00 11:44:00 ... 28
... 11:45:00 11:45:00 ... 29
... 11:46:00 11:46:00 ... 30
... 11:49:00 11:49:00 ... 31
... 11:49:00 11:49:00 ... 32
... 11:50:00 11:50:00 ... 33
... 11:50:00 11:50:00 ... 34
... 11:51:00 11:51:00 ... 35
... 11:51:00 11:51:00 ... 36
... 11:51:00 11:51:00 ... 37
... 11:52:00 11:52:00 ... 38
... 11:53:00 11:53:00 ... 39
... 11:54:00 11:54:00 ... 40
... 11:55:00 11:55:00 ... 41
... 11:56:00 11:56:00 ... 42
... 11:58:00 11:58:00 ... 43
... 11:58:00 11:58:00 ... 44
... 11:59:00 11:59:00 ... 45
... 11:59:00 11:59:00 ... 46
... 12:00:00 12:00:00 ... 47
... 12:01:00 12:01:00 ... 48
... 12:02:00 12:02:00 ... 49
... 12:03:00 12:03:00 ... 50
... 12:07:00 12:07:00 ... 51
... 12:09:00 12:09:00 ... 52
... 12:10:00 12:10:00 ... 53
... 12:11:00 12:11:00 ... 54
... 12:13:00 12:13:00 ... 55
start_date end_date monday tuesday wednesday thursday friday saturday sunday
01/05/2014 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
64326839 Ramsay Cottages 55.8585722843 -3.0731283457
64326879 The Crescent 55.8579296202 -3.0560164127
64325786 Barleyknowe Terrace 55.8507801997 -3.0535702958
64323726 Wilson Road 55.8477273862 -3.0448789515
64325792 Arnprior Road 55.8433747289 -3.0431971141
64325794 Hunter Square 55.8426601143 -3.0469308278
64325739 Coop Car Park 55.8771661714 -3.1082783233
64326847 Dalhousie Grange 55.8673178635 -3.0901962617
64326872 Vogrie Crescent south 55.8422824536 -3.043790664
64326873 Bonnybank Road 55.8449052939 -3.0428388532
64326874 McLean Place 55.8459749969 -3.042787646
64326875 Burnside Road 55.8489148828 -3.0478816425
64326876 Barleyknowe Crescent 55.8500149387 -3.0495404574
64326878 Barleyknowe Road 55.8521249069 -3.051833629
64326893 Dalhousie Road 55.8842100852 -3.0800546371
64327954 Vogrie Road 55.8419736301 -3.04418162
64325845 St Andrew Street 55.893656422 -3.0694594864
64323525 Kings Park 55.89159357 -3.0741836666
64323489 Glenesk Crescent 55.8903804002 -3.0772840377
64323486 Eskbank Toll 55.8887212171 -3.0800040849
64323678 Arniston Engine 55.8482314748 -3.0542520085
64323292 Park Road 55.8763794672 -3.1068333698
64323649 Station Road 55.8875469396 -3.0817301554
64323652 Westfield Park 55.885180628 -3.0851495163
64323647 Muirpark 55.8829873062 -3.0883015411
64324572 Tesco 55.882592893 -3.0851412461
64323285 Mayshade Garden Centre 55.8814258471 -3.0911192643
64323294 Pendreich Avenue 55.8797902138 -3.0951974866
64323425 Waverley Crescent 55.8776095826 -3.1009223064
64323283 Maryfield Place 55.8757248721 -3.103682018
64323264 Bonnyrigg Toll 55.8746609339 -3.1050902859
64323427 Waverley Terrace 55.8732005232 -3.101612614
64323432 Wolsey Avenue 55.8722108465 -3.0987398215
64325836 Bairds Way 55.8705463413 -3.0949532233
64323269 Brixwold Bank 55.8694353289 -3.0925727945
64324239 Station Road 55.856155228 -3.0638120787
64323723 Newtonloan Lodge 55.8540827991 -3.0613592951
64323694 New Hunterfield 55.8521260035 -3.059037708
64323675 Dundas Gardens 55.850961684 -3.0575524902
64323693 Leisure Centre 55.844994848 -3.0502675621
64323697 Newbyres Crescent 55.844990498 -3.0476163313
64323682 Gore Avenue 55.8459936172 -3.045886512
64323698 Newbyres Crescent 55.8447585612 -3.047418446
64323725 Police Station 55.8432252633 -3.0480958491
64323278 High Street 55.8755002651 -3.1066804855
64323293 Park Road 55.8770296329 -3.1074752412
64323736 St Andrews Primary School 55.8534203539 -3.0537535664
64323732 Gowkshill Farm 55.8558833332 -3.0557372467
64323983 McGahey Court 55.8603421523 -3.0638466383
64323985 Mining Museum 55.861631052 -3.0654636368
64323948 Kings Gate 55.8753291605 -3.0814542808
64323482 Croft Street 55.8927540228 -3.0730004779
64323492 Glenesk Crescent 55.8896547622 -3.0790866708
64323562 South Street 55.8934750899 -3.0696463834
64323524 Jarnac Court 55.8940129229 -3.0708285079
© 2017 Molten Mouse LTD