Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 17:45:00 17:45:00 ... 1
... 17:45:00 17:45:00 ... 2
... 17:47:00 17:47:00 ... 3
... 17:48:00 17:48:00 ... 4
... 17:48:00 17:48:00 ... 5
... 17:48:00 17:48:00 ... 6
... 17:50:00 17:50:00 ... 7
... 17:52:00 17:52:00 ... 8
... 17:55:00 17:55:00 ... 9
... 17:56:00 17:56:00 ... 10
... 17:56:00 17:56:00 ... 11
... 17:58:00 17:58:00 ... 12
... 17:59:00 17:59:00 ... 13
... 17:59:00 17:59:00 ... 14
... 18:00:00 18:00:00 ... 15
... 18:00:00 18:00:00 ... 16
... 18:02:00 18:02:00 ... 17
... 18:03:00 18:03:00 ... 18
... 18:05:00 18:05:00 ... 19
... 18:07:00 18:07:00 ... 20
... 18:07:00 18:07:00 ... 21
... 18:08:00 18:08:00 ... 22
... 18:10:00 18:10:00 ... 23
... 18:11:00 18:11:00 ... 24
... 18:11:00 18:11:00 ... 25
... 18:12:00 18:12:00 ... 26
... 18:15:00 18:15:00 ... 27
... 18:15:00 18:15:00 ... 28
... 18:15:00 18:15:00 ... 29
... 18:18:00 18:18:00 ... 30
... 18:19:00 18:19:00 ... 31
... 18:21:00 18:21:00 ... 32
... 18:21:00 18:21:00 ... 33
... 18:23:00 18:23:00 ... 34
... 18:23:00 18:23:00 ... 35
... 18:24:00 18:24:00 ... 36
... 18:24:00 18:24:00 ... 37
... 18:25:00 18:25:00 ... 38
... 18:25:00 18:25:00 ... 39
... 18:26:00 18:26:00 ... 40
... 18:27:00 18:27:00 ... 41
... 18:28:00 18:28: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
58234273 Lynn Lea Avenue 55.9531501301 -2.7665772718
58235345 Bolton Muir Wood 55.9054066579 -2.7971929847
58232946 Goblin Ha' 55.9031715653 -2.7466860269
58234747 Golf Course 55.9551641981 -2.7649034349
58235352 Dobsons Walk 55.9515009051 -2.7901171893
58235354 Council Houses 55.9202274319 -2.7909528022
5823524 Long Cram 55.9504314784 -2.7929458088
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