Haddington - Pencaitland and Gifford circular

  1. Molten Mouse
  2. TNDS
  3. Trip
Details
trip_id arrival_time departure_time stop_id stop_sequence
... 07:42:00 07:42:00 ... 1
... 07:42:00 07:42:00 ... 2
... 07:43:00 07:43:00 ... 3
... 07:44:00 07:44:00 ... 4
... 07:44:00 07:44:00 ... 5
... 07:45:00 07:45:00 ... 6
... 07:46:00 07:46:00 ... 7
... 07:48:00 07:48:00 ... 8
... 07:49:00 07:49:00 ... 9
... 07:51:00 07:51:00 ... 10
... 07:52:00 07:52:00 ... 11
... 07:54:00 07:54:00 ... 12
... 07:55:00 07:55:00 ... 13
... 07:55:00 07:55:00 ... 14
... 07:57:00 07:57:00 ... 15
... 07:58:00 07:58:00 ... 16
... 08:00:00 08:00:00 ... 17
... 08:02:00 08:02:00 ... 18
... 08:02:00 08:02:00 ... 19
... 08:03:00 08:03:00 ... 20
... 08:05:00 08:05:00 ... 21
... 08:05:00 08:05:00 ... 22
... 08:06:00 08:06:00 ... 23
... 08:07:00 08:07:00 ... 24
... 08:09:00 08:09:00 ... 25
... 08:10:00 08:10:00 ... 26
... 08:11:00 08:11:00 ... 27
... 08:12:00 08:12:00 ... 28
... 08:15:00 08:15:00 ... 29
... 08:15:00 08:15:00 ... 30
... 08:15:00 08:15:00 ... 31
... 08:18:00 08:18:00 ... 32
... 08:20:00 08:20:00 ... 33
... 08:21:00 08:21:00 ... 34
... 08:22:00 08:22:00 ... 35
... 08:24:00 08:24:00 ... 36
... 08:24:00 08:24:00 ... 37
... 08:25:00 08:25:00 ... 38
... 08:25:00 08:25:00 ... 39
... 08:26:00 08:26:00 ... 40
... 08:26:00 08:26:00 ... 41
... 08:27:00 08:27:00 ... 42
... 08:29:00 08:29:00 ... 43
... 08:30:00 08:30: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
58232938 Glenkinchie Distillery 55.8902209103 -2.8928622356
58232939 Crossroads 55.8968694429 -2.8626949471
58235286 Market Street 55.9558078514 -2.7783372929
58232975 Corn Exchange 55.9555756186 -2.7809591934
58232973 Rosehall Place 55.9538016026 -2.7900359443
58235345 Bolton Muir Wood 55.9054066579 -2.7971929847
58232946 Goblin Ha' 55.9031715653 -2.7466860269
58232982 Maitlandfield House 55.9532737668 -2.7741066049
58235352 Dobsons Walk 55.9515009051 -2.7901171893
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
5827383 Peaston Bank 55.888352386 -2.8903251794
5827287 Station House 55.8889412964 -2.8746061589
5827486 Milton Mill 55.8915116468 -2.869451458
5825283 Westcroft 55.895718968 -2.8640286518
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