Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 06:55:00 06:55:00 ... 1
... 06:55:00 06:55:00 ... 2
... 06:55:00 06:55:00 ... 3
... 06:56:00 06:56:00 ... 4
... 06:56:00 06:56:00 ... 5
... 06:57:00 06:57:00 ... 6
... 06:57:00 06:57:00 ... 7
... 06:58:00 06:58:00 ... 8
... 06:58:00 06:58:00 ... 9
... 06:59:00 06:59:00 ... 10
... 07:01:00 07:01:00 ... 11
... 07:02:00 07:02:00 ... 12
... 07:03:00 07:03:00 ... 13
... 07:03:00 07:03:00 ... 14
... 07:04:00 07:04:00 ... 15
... 07:05:00 07:05:00 ... 16
... 07:07:00 07:07:00 ... 17
... 07:10:00 07:10:00 ... 18
... 07:12:00 07:12:00 ... 19
... 07:14:00 07:14:00 ... 20
... 07:15:00 07:15:00 ... 21
... 07:16:00 07:16:00 ... 22
... 07:19:00 07:19:00 ... 23
... 07:21:00 07:21:00 ... 24
... 07:24:00 07:24:00 ... 25
... 07:25:00 07:25:00 ... 26
... 07:25:00 07:25:00 ... 27
... 07:25:00 07:25:00 ... 28
... 07:26:00 07:26:00 ... 29
... 07:28:00 07:28:00 ... 30
... 07:28:00 07:28:00 ... 31
... 07:30:00 07:30:00 ... 32
... 07:31:00 07:31:00 ... 33
... 07:33:00 07:33:00 ... 34
... 07:35:00 07:35:00 ... 35
... 07:36:00 07:36:00 ... 36
... 07:36:00 07:36:00 ... 37
... 07:37:00 07:37:00 ... 38
... 07:37:00 07:37:00 ... 39
... 07:38:00 07:38:00 ... 40
... 07:39:00 07:39:00 ... 41
... 07:40:00 07:40: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
58232964 School 55.911176242 -2.891376167
58232968 Old Smiddy Inn 55.9117403442 -2.8854219659
58235343 Lempockwells Rd End 55.8956670378 -2.8789791471
58234723 Fletcher Hall 55.9023676266 -2.8433525637
58232942 Byre Court 55.900179793 -2.8400585265
58232937 Institute 55.90836712 -2.8934072283
58235329 Crossroads 55.8970125115 -2.8627940726
58232943 Bolton Muir Wood 55.905532226 -2.7972275513
58232945 Goblin Ha' 55.9033682444 -2.7468497472
58232986 High Street 55.9553027438 -2.7772220846
58232987 Police Station 55.9552695991 -2.7824584872
58232978 Victoria Bridge 55.9562818372 -2.7729814779
58235345 Bolton Muir Wood 55.9054066579 -2.7971929847
58234827 Rosehall Place 55.953742308 -2.7894742156
58235356 Parkend 55.931268056 -2.7884728301
58232946 Goblin Ha' 55.9031715653 -2.7466860269
58234748 Golf Course 55.9550194608 -2.7650607336
58234749 Monkmains 55.9511369055 -2.7652243502
58232983 Council Houses 55.9202253762 -2.7912727815
58233502 Seggarsdean Park 55.9531176492 -2.76021884
5823423 Seggarsdean Crescent 55.951515519 -2.7621251195
5823565 Briery Bank west 55.9496056237 -2.7715993952
5823658 Briery Bank east 55.9508040327 -2.7681803047
5826725 Nisbet Road End 55.9230615697 -2.8639329297
5826825 Whitelodge RE 55.9308625749 -2.8481490342
5826925 Samuelston RE 55.9353800719 -2.8352977922
5827325 Sunnyside 55.9383804561 -2.827406104
5827425 Blackhouse Bridge 55.9438573852 -2.811800262
5827578 Letham Mains RE 55.945477302 -2.8073029076
5827639 Black House 55.9478319431 -2.8017155269
5827925 Clerkington Mill RE 55.9501657768 -2.7965273805
5829438 Upper Bolton Cottages 55.9111185055 -2.7948306243
5829523 Lennoxlove RE 55.9423567947 -2.7868890218
5827283 Lempockwells 55.8984198026 -2.8822878277
5827683 West Lodge 55.8985407277 -2.8728871236
5827478 South Lodge 55.9042912246 -2.8575495248
5826784 Oak Cottage 55.9041262369 -2.8238134782
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
© 2017 Molten Mouse LTD