Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 18:45:00 18:45:00 ... 1
... 18:45:00 18:45:00 ... 2
... 18:47:00 18:47:00 ... 3
... 18:48:00 18:48:00 ... 4
... 18:49:00 18:49:00 ... 5
... 18:49:00 18:49:00 ... 6
... 18:49:00 18:49:00 ... 7
... 18:49:00 18:49:00 ... 8
... 18:51:00 18:51:00 ... 9
... 18:53:00 18:53:00 ... 10
... 18:55:00 18:55:00 ... 11
... 18:56:00 18:56:00 ... 12
... 18:56:00 18:56:00 ... 13
... 18:58:00 18:58:00 ... 14
... 18:59:00 18:59:00 ... 15
... 18:59:00 18:59:00 ... 16
... 19:00:00 19:00:00 ... 17
... 19:00:00 19:00:00 ... 18
... 19:02:00 19:02:00 ... 19
... 19:03:00 19:03:00 ... 20
... 19:05:00 19:05:00 ... 21
... 19:07:00 19:07:00 ... 22
... 19:07:00 19:07:00 ... 23
... 19:08:00 19:08:00 ... 24
... 19:10:00 19:10:00 ... 25
... 19:11:00 19:11:00 ... 26
... 19:11:00 19:11:00 ... 27
... 19:12:00 19:12:00 ... 28
... 19:15:00 19:15:00 ... 29
... 19:15:00 19:15:00 ... 30
... 19:15:00 19:15:00 ... 31
... 19:17:00 19:17:00 ... 32
... 19:19:00 19:19:00 ... 33
... 19:20:00 19:20:00 ... 34
... 19:20:00 19:20:00 ... 35
... 19:22:00 19:22:00 ... 36
... 19:22:00 19:22:00 ... 37
... 19:23:00 19:23:00 ... 38
... 19:23:00 19:23:00 ... 39
... 19:24:00 19:24:00 ... 40
... 19:24:00 19:24:00 ... 41
... 19:25:00 19:25:00 ... 42
start_date end_date monday tuesday wednesday thursday friday saturday sunday
04/05/2015 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
58232965 School 55.9113476274 -2.8912841146
58232967 Old Smiddy Inn 55.9120904797 -2.8854619431
58235287 Lempockwells Rd End 55.8954863348 -2.8791189795
58234656 Fletcher Hall 55.9022314447 -2.8435575264
58232947 Byre Court 55.9001779378 -2.8403303653
58232948 Institute 55.9092113983 -2.894690383
58232939 Crossroads 55.8968694429 -2.8626949471
58235286 Market Street 55.9558078514 -2.7783372929
58232976 Victoria Bridge 55.9564519288 -2.7730809645
58232975 Corn Exchange 55.9555756186 -2.7809591934
58232943 Bolton Muir Wood 55.905532226 -2.7972275513
58232973 Rosehall Place 55.9538016026 -2.7900359443
58232985 Parkend 55.9313146146 -2.7882176859
58232945 Goblin Ha' 55.9033682444 -2.7468497472
58235345 Bolton Muir Wood 55.9054066579 -2.7971929847
58234272 Monkmains 55.9509393582 -2.7652044388
58232946 Goblin Ha' 55.9031715653 -2.7466860269
58234747 Golf Course 55.9551641981 -2.7649034349
58235354 Council Houses 55.9202274319 -2.7909528022
58233503 Seggarsdean Park 55.9531374941 -2.7599149519
5823424 Seggarsdean Crescent 55.9513630889 -2.7620740825
5826525 Nisbet Road End 55.9228959322 -2.8644893234
5826735 Whitelodge RE 55.9310147483 -2.8482323874
5826827 Samuelston RE 55.9355596397 -2.8353176647
5827252 Sunnyside 55.9383133745 -2.8280290078
5827389 Blackhouse Bridge 55.9439636088 -2.8120426479
5827525 Letham Mains RE 55.9456203093 -2.8074179646
5827625 Black House 55.9479567795 -2.8018622197
5827825 Clerkington Mill RE 55.9502814284 -2.7967059036
5829487 Upper Bolton Cottages 55.9110481825 -2.7945892261
5829595 Lennoxlove RE 55.942140874 -2.7869326727
5826285 Lempockwells 55.8985064307 -2.8827375776
5827684 West Lodge 55.8984353027 -2.8725489192
5827686 South Lodge 55.9041757716 -2.857355042
5827879 Oak Cottage 55.9039643129 -2.8238420337
5827978 Inglisfield Cottage 55.9024085203 -2.7742124787
5827979 Inglisfield Cottage 55.9021755397 -2.7741118748
5824787 Tweeddale Ave 55.9010463496 -2.7504195599
5825786 Tweeddale Ave 55.9010939984 -2.7499726726
5825384 Briery Bank east 55.9506882398 -2.7680178754
5825279 Briery Bank west 55.9494809516 -2.771420771
© 2017 Molten Mouse LTD