Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 13:00:00 13:00:00 ... 1
... 13:00:00 13:00:00 ... 2
... 13:02:00 13:02:00 ... 3
... 13:03:00 13:03:00 ... 4
... 13:04:00 13:04:00 ... 5
... 13:04:00 13:04:00 ... 6
... 13:04:00 13:04:00 ... 7
... 13:04:00 13:04:00 ... 8
... 13:04:00 13:04:00 ... 9
... 13:05:00 13:05:00 ... 10
... 13:05:00 13:05:00 ... 11
... 13:07:00 13:07:00 ... 12
... 13:07:00 13:07:00 ... 13
... 13:09:00 13:09:00 ... 14
... 13:09:00 13:09:00 ... 15
... 13:10:00 13:10:00 ... 16
... 13:11:00 13:11:00 ... 17
... 13:11:00 13:11:00 ... 18
... 13:13:00 13:13:00 ... 19
... 13:14:00 13:14:00 ... 20
... 13:16:00 13:16:00 ... 21
... 13:18:00 13:18:00 ... 22
... 13:18:00 13:18:00 ... 23
... 13:19:00 13:19:00 ... 24
... 13:21:00 13:21:00 ... 25
... 13:22:00 13:22:00 ... 26
... 13:22:00 13:22:00 ... 27
... 13:23:00 13:23:00 ... 28
... 13:26:00 13:26:00 ... 29
... 13:26:00 13:26:00 ... 30
... 13:26:00 13:26:00 ... 31
... 13:29:00 13:29:00 ... 32
... 13:30:00 13:30:00 ... 33
... 13:32:00 13:32:00 ... 34
... 13:32:00 13:32:00 ... 35
... 13:34:00 13:34:00 ... 36
... 13:34:00 13:34:00 ... 37
... 13:35:00 13:35:00 ... 38
... 13:35:00 13:35:00 ... 39
... 13:36:00 13:36:00 ... 40
... 13:36:00 13:36:00 ... 41
... 13:37:00 13:37:00 ... 42
... 13:38:00 13:38:00 ... 43
... 13:39:00 13:39: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