Straiton Sainsbury's - Loanhead circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 09:05:00 09:05:00 ... 1
... 09:07:00 09:07:00 ... 2
... 09:07:00 09:07:00 ... 3
... 09:08:00 09:08:00 ... 4
... 09:09:00 09:09:00 ... 5
... 09:09:00 09:09:00 ... 6
... 09:11:00 09:11:00 ... 7
... 09:12:00 09:12:00 ... 8
... 09:14:00 09:14:00 ... 9
... 09:15:00 09:15:00 ... 10
... 09:15:00 09:15:00 ... 11
... 09:16:00 09:16:00 ... 12
... 09:18:00 09:18:00 ... 13
... 09:18:00 09:18:00 ... 14
... 09:19:00 09:19:00 ... 15
... 09:19:00 09:19:00 ... 16
... 09:20:00 09:20:00 ... 17
... 09:21:00 09:21:00 ... 18
... 09:23:00 09:23:00 ... 19
... 09:25:00 09:25:00 ... 20
... 09:25:00 09:25:00 ... 21
... 09:26:00 09:26:00 ... 22
... 09:27:00 09:27:00 ... 23
... 09:29:00 09:29:00 ... 24
... 09:31:00 09:31:00 ... 25
... 09:32:00 09:32:00 ... 26
... 09:34:00 09:34:00 ... 27
... 09:36:00 09:36:00 ... 28
... 09:38:00 09:38:00 ... 29
... 09:38:00 09:38:00 ... 30
... 09:39:00 09:39:00 ... 31
... 09:40:00 09:40:00 ... 32
... 09:42:00 09:42:00 ... 33
... 09:42:00 09:42:00 ... 34
... 09:43:00 09:43:00 ... 35
... 09:44:00 09:44:00 ... 36
... 09:45:00 09:45:00 ... 37
... 09:49:00 09:49:00 ... 38
... 09:50:00 09:50:00 ... 39
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
64326928 South Melville Farm 55.887855297 -3.0966397764
64326929 High Street 55.8774128351 -3.1470626003
64326932 Polton Road 55.8768735972 -3.1480376955
64326935 Polton Road 55.8764516919 -3.147993275
64326936 Burghlee Terrace 55.8762807803 -3.1499382303
64326937 Burghlee Crescent 55.8756331256 -3.1509739832
64326938 Burghlee Terrace 55.8757490207 -3.1520323166
64326943 Park Crescent 55.876111745 -3.1564705023
64326945 Park Avenue 55.8754297568 -3.1573293052
64326946 Dryden Terrace 55.8759788994 -3.1629398713
64326947 Dalum Loan 55.8774690907 -3.1640393809
64326948 Gaynor Avenue 55.8784397126 -3.1621183199
64327939 Mayburn Avenue 55.8801147645 -3.1550389749
64327953 Mavisbank 55.8756688247 -3.1481140191
64324748 Sainsburys 55.882717944 -3.1648519377
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
64323832 Muirfield Gardens 55.8773374944 -3.1503211221
64323769 George Avenue 55.8767328107 -3.1544430419
64329348 Asda Straiton 55.8789063478 -3.1707160583
64324565 Straiton Cottages 55.8842050871 -3.1662713616
64342439 Asda 55.8783230433 -3.169691477
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
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
64323562 South Street 55.8934750899 -3.0696463834
64323524 Jarnac Court 55.8940129229 -3.0708285079
© 2017 Molten Mouse LTD