Haddington - Pencaitland and Gifford circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 11:35:00 11:35:00 ... 1
... 11:35:00 11:35:00 ... 2
... 11:36:00 11:36:00 ... 3
... 11:37:00 11:37:00 ... 4
... 11:38:00 11:38:00 ... 5
... 11:38:00 11:38:00 ... 6
... 11:38:00 11:38:00 ... 7
... 11:39:00 11:39:00 ... 8
... 11:39:00 11:39:00 ... 9
... 11:40:00 11:40:00 ... 10
... 11:41:00 11:41:00 ... 11
... 11:42:00 11:42:00 ... 12
... 11:43:00 11:43:00 ... 13
... 11:45:00 11:45:00 ... 14
... 11:45:00 11:45:00 ... 15
... 11:46:00 11:46:00 ... 16
... 11:47:00 11:47:00 ... 17
... 11:48:00 11:48:00 ... 18
... 11:50:00 11:50:00 ... 19
... 11:53:00 11:53:00 ... 20
... 11:54:00 11:54:00 ... 21
... 11:55:00 11:55:00 ... 22
... 11:56:00 11:56:00 ... 23
... 11:57:00 11:57:00 ... 24
... 11:59:00 11:59:00 ... 25
... 12:00:00 12:00:00 ... 26
... 12:02:00 12:02:00 ... 27
... 12:03:00 12:03:00 ... 28
... 12:03:00 12:03:00 ... 29
... 12:04:00 12:04:00 ... 30
... 12:04:00 12:04:00 ... 31
... 12:05:00 12:05:00 ... 32
... 12:06:00 12:06:00 ... 33
... 12:07:00 12:07:00 ... 34
... 12:07:00 12:07:00 ... 35
... 12:08:00 12:08:00 ... 36
... 12:08:00 12:08:00 ... 37
... 12:08:00 12:08:00 ... 38
... 12:08:00 12:08:00 ... 39
... 12:09:00 12:09:00 ... 40
... 12:09:00 12:09:00 ... 41
... 12:11:00 12:11:00 ... 42
... 12:12:00 12:12:00 ... 43
... 12:14:00 12:14: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
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
58234827 Rosehall Place 55.953742308 -2.7894742156
58234748 Golf Course 55.9550194608 -2.7650607336
58234749 Monkmains 55.9511369055 -2.7652243502
58232969 Dobsons Walk 55.9519040505 -2.7903015578
58233502 Seggarsdean Park 55.9531176492 -2.76021884
5823423 Seggarsdean Crescent 55.951515519 -2.7621251195
5823523 Long Cram 55.9504294169 -2.793266037
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
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
5824787 Tweeddale Ave 55.9010463496 -2.7504195599
5828384 Gifford Vale 55.9070620477 -2.7466968202
5828379 Slateford Farm RE 55.913654007 -2.7472075088
5826378 Myreside RE 55.9181774773 -2.7435825124
5828485 Beech Hill RE 55.9300155693 -2.7472503634
5828784 Cockles Smiddy 55.9360123659 -2.7510635684
5828482 Monkrigg West Lodge 55.9401828034 -2.7668813782
5825684 Lennoxlove East Port 55.9453264978 -2.7705215739
5824685 Lennoxlove Acredales 55.9487084865 -2.7728145321
© 2017 Molten Mouse LTD