Straiton Sainsbury's - Dalkeith via Temple

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 09:55:00 09:55:00 ... 1
... 09:57:00 09:57:00 ... 2
... 09:58:00 09:58:00 ... 3
... 10:00:00 10:00:00 ... 4
... 10:00:00 10:00:00 ... 5
... 10:00:00 10:00:00 ... 6
... 10:00:00 10:00:00 ... 7
... 10:00:00 10:00:00 ... 8
... 10:00:00 10:00:00 ... 9
... 10:00:00 10:00:00 ... 10
... 10:01:00 10:01:00 ... 11
... 10:02:00 10:02:00 ... 12
... 10:03:00 10:03:00 ... 13
... 10:04:00 10:04:00 ... 14
... 10:04:00 10:04:00 ... 15
... 10:05:00 10:05:00 ... 16
... 10:06:00 10:06:00 ... 17
... 10:07:00 10:07:00 ... 18
... 10:07:00 10:07:00 ... 19
... 10:08:00 10:08:00 ... 20
... 10:08:00 10:08:00 ... 21
... 10:09:00 10:09:00 ... 22
... 10:10:00 10:10:00 ... 23
... 10:10:00 10:10:00 ... 24
... 10:12:00 10:12:00 ... 25
... 10:15:00 10:15:00 ... 26
... 10:17:00 10:17:00 ... 27
... 10:19:00 10:19:00 ... 28
... 10:20:00 10:20:00 ... 29
... 10:21:00 10:21:00 ... 30
... 10:22:00 10:22:00 ... 31
... 10:29:00 10:29:00 ... 32
... 10:29:00 10:29:00 ... 33
... 10:29:00 10:29:00 ... 34
... 10:30:00 10:30:00 ... 35
... 10:31:00 10:31:00 ... 36
... 10:31:00 10:31:00 ... 37
... 10:31:00 10:31:00 ... 38
... 10:32:00 10:32:00 ... 39
... 10:32:00 10:32:00 ... 40
... 10:33:00 10:33:00 ... 41
... 10:35:00 10:35:00 ... 42
... 10:35:00 10:35:00 ... 43
... 10:36:00 10:36:00 ... 44
... 10:36:00 10:36:00 ... 45
... 10:36:00 10:36:00 ... 46
... 10:37:00 10:37:00 ... 47
... 10:38:00 10:38:00 ... 48
... 10:40:00 10:40:00 ... 49
... 10:41:00 10:41:00 ... 50
... 10:43:00 10:43:00 ... 51
... 10:44:00 10:44:00 ... 52
... 10:44:00 10:44:00 ... 53
... 10:45:00 10:45:00 ... 54
... 10:45:00 10:45:00 ... 55
... 10:46:00 10:46:00 ... 56
... 10:47:00 10:47:00 ... 57
... 10:47:00 10:47:00 ... 58
... 10:47:00 10:47:00 ... 59
... 10:48:00 10:48:00 ... 60
... 10:49:00 10:49:00 ... 61
... 10:50:00 10:50:00 ... 62
... 10:50:00 10:50:00 ... 63
... 10:51:00 10:51:00 ... 64
... 10:53:00 10:53:00 ... 65
... 10:53:00 10:53:00 ... 66
... 10:55:00 10:55:00 ... 67
... 10:56:00 10:56:00 ... 68
... 10:56:00 10:56:00 ... 69
... 10:56:00 10:56:00 ... 70
... 10:58:00 10:58:00 ... 71
... 10:58:00 10:58:00 ... 72
... 10:59:00 10:59:00 ... 73
... 10:59:00 10:59:00 ... 74
... 11:02:00 11:02:00 ... 75
... 11:02:00 11:02:00 ... 76
... 11:03:00 11:03:00 ... 77
... 11:03:00 11:03:00 ... 78
... 11:08:00 11:08:00 ... 79
start_date end_date monday tuesday wednesday thursday friday saturday sunday
03/09/2012 @ 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
64323726 Wilson Road 55.8477273862 -3.0448789515
64325792 Arnprior Road 55.8433747289 -3.0431971141
64325794 Hunter Square 55.8426601143 -3.0469308278
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
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
64326872 Vogrie Crescent south 55.8422824536 -3.043790664
64326873 Bonnybank Road 55.8449052939 -3.0428388532
64326874 McLean Place 55.8459749969 -3.042787646
64327954 Vogrie Road 55.8419736301 -3.04418162
64324748 Sainsburys 55.882717944 -3.1648519377
64323829 Station Road 55.8778877454 -3.1472044808
64323762 Academy Lane 55.8777992949 -3.1451239229
64323792 Hunter Avenue 55.8779774014 -3.1423958531
64324578 Kevock Road 55.8812788974 -3.1283455549
64324582 Lasswade Road 55.8834285999 -3.1231963363
64323749 Laird and Dog 55.8836196371 -3.1150327223
64323747 Elm Row 55.8839594977 -3.1122288109
64323265 Broomieknowe Gardens 55.8807128985 -3.1105534056
64323296 Rockville Terrace 55.8787240012 -3.1079071181
64323292 Park Road 55.8763794672 -3.1068333698
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
64323825 Nivensknowe Park 55.8751749217 -3.1738003868
64323798 New Pentland Road 55.8797210463 -3.1700851957
64329348 Asda Straiton 55.8789063478 -3.1707160583
64324565 Straiton Cottages 55.8842050871 -3.1662713616
64342439 Asda 55.8783230433 -3.169691477
64323823 New Pentland Road 55.8791188987 -3.171042153
64323827 Nivensknowe Road 55.8745549442 -3.1737976608
64323765 Dryden Road 55.8749620145 -3.1687912485
64323789 Herd Terrace 55.8755112497 -3.1639328383
64323797 McNeil Avenue 55.8763356518 -3.1584591318
64323782 George Avenue 55.8768450924 -3.15492589
64323834 Muirfield Gardens 55.8776878078 -3.1493724321
64323278 High Street 55.8755002651 -3.1066804855
64323293 Park Road 55.8770296329 -3.1074752412
64323297 Rockville Terrace 55.8783180321 -3.1080873657
64323267 Broomieknowe Gardens 55.8800983941 -3.1099444089
64323748 Elm Row 55.8833256211 -3.1127702049
64323752 Laird and Dog 55.8834382366 -3.1152193583
64324575 Lasswade Road 55.8831437041 -3.1238915075
64324579 Kevock Road 55.8810790712 -3.1285795399
64323793 Hunter Avenue 55.8777540113 -3.1422614179
64323763 Academy Lane 55.8775406302 -3.1458835446
64323784 George Drive 55.8791430859 -3.1503745277
64323768 Edgefield Road 55.8814580415 -3.1536081843
64323786 Hawthorn Gardens 55.8825272974 -3.1555262749
64323795 Mayshade Road 55.8833830343 -3.1572143045
64323836 Retail Park 55.8858351117 -3.1601810314
64329354 Straiton Mains 55.8854919709 -3.162265144
64329356 Straiton Parkway 55.8858595093 -3.1642585897
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
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
64323679 Arniston Engine 55.8477213378 -3.0540145924
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
© 2017 Molten Mouse LTD