Melrose - Edinburgh

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 19:30:00 19:30:00 ... 1
... 19:35:00 19:35:00 ... 2
... 19:37:00 19:37:00 ... 3
... 19:38:00 19:38:00 ... 4
... 19:40:00 19:40:00 ... 5
... 19:44:00 19:44:00 ... 6
... 19:49:00 19:49:00 ... 7
... 19:54:00 19:54:00 ... 8
... 19:55:00 19:55:00 ... 9
... 19:56:00 19:56:00 ... 10
... 19:57:00 19:57:00 ... 11
... 19:58:00 19:58:00 ... 12
... 19:59:00 19:59:00 ... 13
... 19:59:00 19:59:00 ... 14
... 20:00:00 20:00:00 ... 15
... 20:00:00 20:00:00 ... 16
... 20:01:00 20:01:00 ... 17
... 20:01:00 20:01:00 ... 18
... 20:02:00 20:02:00 ... 19
... 20:03:00 20:03:00 ... 20
... 20:05:00 20:05:00 ... 21
... 20:06:00 20:06:00 ... 22
... 20:07:00 20:07:00 ... 23
... 20:07:00 20:07:00 ... 24
... 20:08:00 20:08:00 ... 25
... 20:09:00 20:09:00 ... 26
... 20:10:00 20:10:00 ... 27
... 20:10:00 20:10:00 ... 28
... 20:11:00 20:11:00 ... 29
... 20:11:00 20:11:00 ... 30
... 20:12:00 20:12:00 ... 31
... 20:12:00 20:12:00 ... 32
... 20:12:00 20:12:00 ... 33
... 20:16:00 20:16:00 ... 34
... 20:17:00 20:17:00 ... 35
... 20:19:00 20:19:00 ... 36
... 20:22:00 20:22:00 ... 37
... 20:25:00 20:25:00 ... 38
... 20:25:00 20:25:00 ... 39
... 20:27:00 20:27:00 ... 40
... 20:27:00 20:27:00 ... 41
... 20:30:00 20:30:00 ... 42
... 20:32:00 20:32:00 ... 43
... 20:35:00 20:35:00 ... 44
... 20:35:00 20:35:00 ... 45
... 20:35:00 20:35:00 ... 46
... 20:35:00 20:35:00 ... 47
... 20:36:00 20:36:00 ... 48
... 20:36:00 20:36:00 ... 49
... 20:37:00 20:37:00 ... 50
... 20:37:00 20:37:00 ... 51
... 20:38:00 20:38:00 ... 52
... 20:38:00 20:38:00 ... 53
... 20:38:00 20:38:00 ... 54
... 20:41:00 20:41:00 ... 55
... 20:42:00 20:42:00 ... 56
... 20:42:00 20:42:00 ... 57
... 20:44:00 20:44:00 ... 58
... 20:46:00 20:46:00 ... 59
... 20:50:00 20:50:00 ... 60
... 20:50:00 20:50:00 ... 61
... 20:53:00 20:53:00 ... 62
... 20:54:00 20:54:00 ... 63
... 20:54:00 20:54:00 ... 64
... 20:58:00 20:58:00 ... 65
... 20:58:00 20:58:00 ... 66
... 20:59:00 20:59:00 ... 67
... 20:59:00 20:59:00 ... 68
... 21:00:00 21:00:00 ... 69
... 21:00:00 21:00:00 ... 70
... 21:02:00 21:02:00 ... 71
... 21:05:00 21:05:00 ... 72
... 21:07:00 21:07:00 ... 73
... 21:08:00 21:08:00 ... 74
... 21:09:00 21:09:00 ... 75
... 21:10:00 21:10:00 ... 76
... 21:10:00 21:10:00 ... 77
... 21:13:00 21:13:00 ... 78
... 21:14:00 21:14:00 ... 79
... 21:14:00 21:14:00 ... 80
... 21:15:00 21:15:00 ... 81
... 21:15:00 21:15:00 ... 82
... 21:16:00 21:16:00 ... 83
... 21:17:00 21:17:00 ... 84
... 21:18:00 21:18:00 ... 85
... 21:19:00 21:19:00 ... 86
... 21:21:00 21:21:00 ... 87
... 21:21:00 21:21:00 ... 88
... 21:23:00 21:23:00 ... 89
... 21:24:00 21:24:00 ... 90
... 21:26:00 21:26:00 ... 91
... 21:27:00 21:27:00 ... 92
... 21:29:00 21:29:00 ... 93
... 21:29:00 21:29:00 ... 94
... 21:30:00 21:30:00 ... 95
... 21:31:00 21:31:00 ... 96
... 21:32:00 21:32:00 ... 97
... 21:32:00 21:32:00 ... 98
... 21:36:00 21:36:00 ... 99
... 21:37:00 21:37:00 ... 100
... 21:38:00 21:38:00 ... 101
... 21:39:00 21:39:00 ... 102
... 21:39:00 21:39:00 ... 103
... 21:40:00 21:40:00 ... 104
... 21:40:00 21:40:00 ... 105
... 21:41:00 21:41:00 ... 106
start_date end_date monday tuesday wednesday thursday friday saturday sunday
02/07/2018 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
36234754 North Bridge 55.9512188531 -3.187903456
36234757 South Bridge 55.9485179212 -3.1865877051
36234759 Surgeons' Hall 55.945376453 -3.184362001
36234797 St Patrick Square 55.9426353289 -3.1825491347
36234837 Salisbury Place 55.9371032788 -3.177545918
36234842 East Savile Road 55.9306785086 -3.1709645881
36237845 Lady Road 55.9259042095 -3.1665474946
36237858 Liberton Cemetery 55.9130834318 -3.1635386084
36237867 Mortonhall Crematorium 55.9041839192 -3.1658472999
36237869 Balmwell Terrace 55.9010321463 -3.1637215235
36243734 Bus Station 55.9553965367 -3.1916831382
64323825 Nivensknowe Park 55.8751749217 -3.1738003868
64329348 Asda Straiton 55.8789063478 -3.1707160583
64323248 Seafield Road 55.8711730129 -3.1769718365
64323246 Roslin Road 55.8698422745 -3.1780023059
64323239 Moorfoot View 55.867063074 -3.1801553443
64323243 Ploverhall Cottages 55.8629640327 -3.1831308018
64323728 Bush Access 55.858559961 -3.1860484149
64323942 Milton Cottages 55.8526217945 -3.190563842
64323938 Golf Club 55.8496890556 -3.1992432187
64324298 Glencorse Barracks 55.8461417416 -3.2036378855
64324369 Samoa Terrace 55.8433505103 -3.2069692384
64324272 Beeslack High School 55.8403934627 -3.2134408603
64324346 Mauricewood Road 55.8388423967 -3.2167299295
64324357 Queensway 55.8357794284 -3.2202428284
64324283 Cuiken Avenue 55.8334213744 -3.2224361644
64324265 Angle Park 55.8312327577 -3.2238522646
64324376 Wilson Street 55.8291385439 -3.2230042284
64324373 Town Centre 55.8279932339 -3.2216113449
64324324 Lambs Pend 55.8261698665 -3.2215382208
64324354 Pomathorn Road 55.8228902086 -3.2206213698
64323758 Wellington School 55.7973466214 -3.2221509098
64323756 Leadburn Inn 55.7876031467 -3.2215427537
64324564 Loanhead Road 55.8875913462 -3.1635590015
64324565 Straiton Cottages 55.8842050871 -3.1662713616
72725894 Horsbrugh Terrace 55.6205707301 -3.0595808508
72726383 Tweedbank Loch 55.6015327865 -2.7687502305
72726368 Cotgreen Road 55.6040427287 -2.7654027133
72726385 Neidpath Court 55.6066709112 -2.7661364558
72726369 Jura Drive 55.6061368161 -2.7609990939
72726373 Tweedbank Ind Est 55.6045357982 -2.7554445439
72725728 Post Office 55.6519699247 -3.187787674
72726767 Garage 55.6250807455 -3.0258601436
72726789 High Cottages 55.6248407968 -3.0223124408
72726768 Post Office 55.6236934621 -3.0165656269
72726765 Village Hall 55.6242415223 -3.0122285289
72725456 Bridge Street 55.6191188851 -2.8117591252
72725745 Thornielee Rd End 55.6167146763 -2.9336791068
72726946 Cardrona Shop 55.6402829388 -3.1136371265
72726764 Holylee Lodge 55.626951002 -2.9693702463
72725345 Station Road 55.7105028236 -3.2072301209
72727264 Winkston Farm 55.6739809253 -3.2020819128
72725354 Shiplaw Rd End 55.7278628673 -3.205457048
72725352 Portmore Estate 55.7239391318 -3.2051450767
72725375 Fala Toll 55.7473452745 -3.2044169749
72725397 Road End 55.7757372791 -3.2156712872
72725934 Velvet Hall Cotts 55.6252919287 -3.0889136757
72727249 Glentress Hotel 55.6443871172 -3.1393348563
72726982 Sawmill 55.6450546222 -3.144851928
72726898 Gasworks 55.6461903128 -3.1531159564
72726787 Scottish Water 55.6261038215 -3.0064957274
72727239 Firholm 55.6514717698 -3.1835453278
72725493 Abbey Car Park 55.5985897341 -2.7191946653
72725623 Wright's Chiropractor 55.5986702789 -2.7223066263
72725748 Caddonfoot Jct 55.6177444597 -2.8769563331
72726398 High Tweed Mill 55.6234190018 -2.8231386729
72768289 Bridges Rd End 55.6526499796 -3.1852972621
72798757 The Nest Kennels 55.6088384522 -2.9031245353
72798938 Cringletie House 55.6883245991 -3.2119071547
72798426 Glenormiston Lodge 55.6283674758 -3.094700767
72798429 Lodge 55.6299390326 -2.8460987095
72728487 Tweedbank Station 55.6053230786 -2.7574596235
72728488 Transport Interchange 55.6174679453 -2.8059455764
72724362 Meigle Row 55.6196524467 -2.8740137762
72724347 Hotel 55.6186567423 -2.8762939445
72798586 The Nest Roundabout 55.6077476207 -2.8987183052
72724567 Wood Street 55.6276371976 -2.8371553488
72724563 Wood Street Church 55.6265194513 -2.8337170488
72724537 Wood Street 55.6256639293 -2.8313485106
72723854 Galafoot Bridge 55.6029716021 -2.7785394354
72724235 St Peter's School 55.611261931 -2.8013732413
72724384 Annie's Cafe 55.6220125125 -2.8198221545
72724364 B and Q 55.6203371349 -2.8150394428
72724395 Woodlea 55.6246509355 -2.8283415325
72724286 Market Street Fountain 55.614787791 -2.8063192465
72723957 Fire Station 55.6087740329 -2.7970682567
72723878 Archies Walk 55.6054100673 -2.7892541624
72724353 Unionist Club 55.6178569559 -3.066843326
72724372 Post Office 55.6188955599 -3.064172187
72723736 Borders General Hospital 55.596048777 -2.7414914217
72723795 Gibson Park 55.5991446792 -2.7241403983
72724689 Hydro Rd End 55.6504081775 -3.1764097288
72724737 March Street 55.65533901 -3.1887797439
72724732 East Station Car Park 55.6537858603 -3.1867778422
72724529 former Mill 55.6237777952 -3.0183146571
72724654 Horsbrugh Ford Cotts 55.6422365187 -3.1171879472
72726923 Dalatho Crescent 55.6580017287 -3.1912605466
72726927 Dalatho Street 55.6596224472 -3.1918502211
72726926 Crossburn Garage 55.6615292356 -3.1925917095
72725353 Horseshoe Inn 55.7121907965 -3.2064545235
72725383 Weirhill Place 55.5997627586 -2.7275004161
72725436 Holy Trinity Church 55.5993542378 -2.7312223318
72725429 Ormiston Terrace 55.5989382366 -2.7346742421
72725839 Darnick Vale 55.5987278195 -2.7397804089
© 2017 Molten Mouse LTD