Dalkeith - Temple and Gorebridge circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 10:00:00 10:00:00 ... 1
... 10:02:00 10:02:00 ... 2
... 10:02:00 10:02:00 ... 3
... 10:03:00 10:03:00 ... 4
... 10:04:00 10:04:00 ... 5
... 10:05:00 10:05:00 ... 6
... 10:06:00 10:06:00 ... 7
... 10:10:00 10:10:00 ... 8
... 10:10:00 10:10:00 ... 9
... 10:11:00 10:11:00 ... 10
... 10:12:00 10:12:00 ... 11
... 10:13:00 10:13:00 ... 12
... 10:14:00 10:14:00 ... 13
... 10:15:00 10:15:00 ... 14
... 10:16:00 10:16:00 ... 15
... 10:17:00 10:17:00 ... 16
... 10:18:00 10:18:00 ... 17
... 10:20:00 10:20:00 ... 18
... 10:22:00 10:22:00 ... 19
... 10:24:00 10:24:00 ... 20
... 10:25:00 10:25:00 ... 21
... 10:26:00 10:26:00 ... 22
... 10:27:00 10:27:00 ... 23
... 10:29:00 10:29:00 ... 24
... 10:36:00 10:36:00 ... 25
... 10:36:00 10:36:00 ... 26
... 10:37:00 10:37:00 ... 27
... 10:37:00 10:37:00 ... 28
... 10:38:00 10:38:00 ... 29
... 10:39:00 10:39:00 ... 30
... 10:39:00 10:39:00 ... 31
... 10:40:00 10:40:00 ... 32
... 10:41:00 10:41:00 ... 33
... 10:41:00 10:41:00 ... 34
... 10:42:00 10:42:00 ... 35
... 10:43:00 10:43:00 ... 36
... 10:44:00 10:44:00 ... 37
... 10:45:00 10:45:00 ... 38
... 10:47:00 10:47:00 ... 39
... 10:47:00 10:47:00 ... 40
... 10:48:00 10:48:00 ... 41
... 10:48:00 10:48:00 ... 42
... 10:49:00 10:49:00 ... 43
... 10:50:00 10:50:00 ... 44
... 10:50:00 10:50:00 ... 45
... 10:51:00 10:51:00 ... 46
... 10:52:00 10:52:00 ... 47
... 10:53:00 10:53:00 ... 48
... 10:54:00 10:54:00 ... 49
... 10:56:00 10:56:00 ... 50
... 10:56:00 10:56:00 ... 51
... 10:57:00 10:57:00 ... 52
... 10:58:00 10:58:00 ... 53
... 10:59:00 10:59:00 ... 54
... 10:59:00 10:59:00 ... 55
... 11:00:00 11:00:00 ... 56
... 11:01:00 11:01:00 ... 57
... 11:02:00 11:02:00 ... 58
... 11:03:00 11:03:00 ... 59
... 11:06:00 11:06:00 ... 60
... 11:07:00 11:07:00 ... 61
... 11:08:00 11:08:00 ... 62
... 11:10:00 11:10:00 ... 63
... 11:12:00 11:12:00 ... 64
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
64324569 Main Street 55.8160966726 -3.0916359728
64325782 Ramsay Cottages 55.8585096041 -3.0741331153
64323464 Primrose Gardens 55.8338156938 -3.0876300003
64324568 Main Street 55.8124541665 -3.0879595469
64324573 Upper Dalhousie 55.8566785697 -3.0983332877
64323434 Braidwood bridge 55.8193603077 -3.0893971918
64325739 Coop Car Park 55.8771661714 -3.1082783233
64326847 Dalhousie Grange 55.8673178635 -3.0901962617
64326848 Aikendean Bridge 55.8443015447 -3.0907016884
64326849 Carrington Mill 55.8238602934 -3.0855324834
64326854 Dalhousie Grange 55.8668456383 -3.0907582963
64342458 Lasswade Centre 55.8714568663 -3.113645281
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
64325837 Station Road 55.8886438673 -3.0826720241
64325842 South Melville 55.8888015051 -3.0892477388
64323292 Park Road 55.8763794672 -3.1068333698
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
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
64323274 Dobbies Road 55.8741439482 -3.1066259144
64323287 Hazel Drive 55.8720748373 -3.1098912668
64323289 Hazel Drive 55.8724628429 -3.1097105536
64323275 Dobbies Road 55.8738387349 -3.1075921649
64323278 High Street 55.8755002651 -3.1066804855
64323293 Park Road 55.8770296329 -3.1074752412
64323268 Brixwold Bank 55.8689268301 -3.0921590028
64325835 Bairds Way 55.8704278533 -3.0951416616
64323429 Wolsey Avenue 55.8717036524 -3.0981821211
64323428 Waverley Terrace 55.8727921576 -3.101057659
64329285 Dundas Park 55.8740897395 -3.1046585104
64323276 Douglas Crescent 55.8751627009 -3.105248389
64323284 Maryfield Place 55.8765221258 -3.1029534111
64323426 Waverley Crescent 55.8777514552 -3.1011341158
64323295 Pendreich Avenue 55.8795327243 -3.096868643
64323424 Viewbank Avenue 55.8805041206 -3.0937309653
64323286 Mayshade Garden Centre 55.8817043269 -3.091127078
64323259 Terminus 55.8350419093 -3.0467580123
64323257 Powdermill Brae 55.8371145859 -3.0449934345
64323258 Powdermill Brae 55.8385043275 -3.0464039584
64323684 Gorebridge Inn 55.8420982502 -3.0474906211
64325846 Police Station 55.8430446429 -3.0482027764
64323679 Arniston Engine 55.8477213378 -3.0540145924
64323692 Leisure Centre 55.8447162265 -3.050276018
64323676 Dundas Gardens 55.8501574356 -3.0570354905
64323695 New Hunterfield 55.8490107837 -3.0555828322
64323696 New Hunterfield 55.8519441366 -3.0592883356
64323724 Newtonloan Lodge 55.8537140685 -3.0613971643
64329278 Station Road 55.8560785268 -3.0643691124
64323482 Croft Street 55.8927540228 -3.0730004779
64325838 South Melville 55.8890098163 -3.0890617107
64325839 Station Road 55.888786193 -3.0828358738
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