Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 10:15:00 10:15:00 ... 1
... 10:15:00 10:15:00 ... 2
... 10:17:00 10:17:00 ... 3
... 10:18:00 10:18:00 ... 4
... 10:19:00 10:19:00 ... 5
... 10:19:00 10:19:00 ... 6
... 10:19:00 10:19:00 ... 7
... 10:19:00 10:19:00 ... 8
... 10:19:00 10:19:00 ... 9
... 10:20:00 10:20:00 ... 10
... 10:20:00 10:20:00 ... 11
... 10:22:00 10:22:00 ... 12
... 10:22:00 10:22:00 ... 13
... 10:24:00 10:24:00 ... 14
... 10:24:00 10:24:00 ... 15
... 10:25:00 10:25:00 ... 16
... 10:26:00 10:26:00 ... 17
... 10:26:00 10:26:00 ... 18
... 10:28:00 10:28:00 ... 19
... 10:29:00 10:29:00 ... 20
... 10:31:00 10:31:00 ... 21
... 10:33:00 10:33:00 ... 22
... 10:33:00 10:33:00 ... 23
... 10:34:00 10:34:00 ... 24
... 10:36:00 10:36:00 ... 25
... 10:37:00 10:37:00 ... 26
... 10:37:00 10:37:00 ... 27
... 10:38:00 10:38:00 ... 28
... 10:41:00 10:41:00 ... 29
... 10:41:00 10:41:00 ... 30
... 10:41:00 10:41:00 ... 31
... 10:44:00 10:44:00 ... 32
... 10:45:00 10:45:00 ... 33
... 10:47:00 10:47:00 ... 34
... 10:47:00 10:47:00 ... 35
... 10:49:00 10:49:00 ... 36
... 10:49:00 10:49:00 ... 37
... 10:50:00 10:50:00 ... 38
... 10:50:00 10:50:00 ... 39
... 10:51:00 10:51:00 ... 40
... 10:51:00 10:51:00 ... 41
... 10:52:00 10:52:00 ... 42
... 10:53:00 10:53:00 ... 43
... 10:54:00 10:54:00 ... 44
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
58232973 Rosehall Place 55.9538016026 -2.7900359443
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
58235352 Dobsons Walk 55.9515009051 -2.7901171893
58233503 Seggarsdean Park 55.9531374941 -2.7599149519
5823424 Seggarsdean Crescent 55.9513630889 -2.7620740825
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
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
5827979 Inglisfield Cottage 55.9021755397 -2.7741118748
5825786 Tweeddale Ave 55.9010939984 -2.7499726726
5827983 Gifford Vale 55.9069379197 -2.7464225104
5828687 Slateford Farm RE 55.9134850572 -2.7469162905
5828484 Myreside RE 55.9180526667 -2.7434201215
5828785 Beech Hill RE 55.9300711237 -2.746979347
5827286 Cockles Smiddy 55.9360407816 -2.7508240055
5828387 Monkrigg West Lodge 55.940014599 -2.7664778241
5823486 Lennoxlove East Port 55.9452120091 -2.7701510392
5825683 Lennoxlove Acredales 55.9487461294 -2.7725430647
5825384 Briery Bank east 55.9506882398 -2.7680178754
5825279 Briery Bank west 55.9494809516 -2.771420771
© 2017 Molten Mouse LTD