Melrose - Edinburgh

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 18:30:00 18:30:00 ... 1
... 18:37:00 18:37:00 ... 2
... 18:39:00 18:39:00 ... 3
... 18:41:00 18:41:00 ... 4
... 18:43:00 18:43:00 ... 5
... 18:48:00 18:48:00 ... 6
... 18:53:00 18:53:00 ... 7
... 18:57:00 18:57:00 ... 8
... 18:58:00 18:58:00 ... 9
... 18:59:00 18:59:00 ... 10
... 18:59:00 18:59:00 ... 11
... 19:00:00 19:00:00 ... 12
... 19:01:00 19:01:00 ... 13
... 19:02:00 19:02:00 ... 14
... 19:04:00 19:04:00 ... 15
... 19:06:00 19:06:00 ... 16
... 19:07:00 19:07:00 ... 17
... 19:07:00 19:07:00 ... 18
... 19:08:00 19:08:00 ... 19
... 19:09:00 19:09:00 ... 20
... 19:10:00 19:10:00 ... 21
... 19:11:00 19:11:00 ... 22
... 19:12:00 19:12:00 ... 23
... 19:12:00 19:12:00 ... 24
... 19:14:00 19:14:00 ... 25
... 19:14:00 19:14:00 ... 26
... 19:15:00 19:15:00 ... 27
... 19:16:00 19:16:00 ... 28
... 19:16:00 19:16:00 ... 29
... 19:17:00 19:17:00 ... 30
... 19:18:00 19:18:00 ... 31
... 19:18:00 19:18:00 ... 32
... 19:18:00 19:18:00 ... 33
... 19:23:00 19:23:00 ... 34
... 19:25:00 19:25:00 ... 35
... 19:26:00 19:26:00 ... 36
... 19:29:00 19:29:00 ... 37
... 19:31:00 19:31:00 ... 38
... 19:31:00 19:31:00 ... 39
... 19:33:00 19:33:00 ... 40
... 19:33:00 19:33:00 ... 41
... 19:36:00 19:36:00 ... 42
... 19:38:00 19:38:00 ... 43
... 19:40:00 19:40:00 ... 44
... 19:40:00 19:40:00 ... 45
... 19:40:00 19:40:00 ... 46
... 19:41:00 19:41:00 ... 47
... 19:41:00 19:41:00 ... 48
... 19:41:00 19:41:00 ... 49
... 19:42:00 19:42:00 ... 50
... 19:42:00 19:42:00 ... 51
... 19:43:00 19:43:00 ... 52
... 19:43:00 19:43:00 ... 53
... 19:43:00 19:43:00 ... 54
... 19:46:00 19:46:00 ... 55
... 19:47:00 19:47:00 ... 56
... 19:47:00 19:47:00 ... 57
... 19:49:00 19:49:00 ... 58
... 19:51:00 19:51:00 ... 59
... 19:55:00 19:55:00 ... 60
... 19:55:00 19:55:00 ... 61
... 19:58:00 19:58:00 ... 62
... 19:59:00 19:59:00 ... 63
... 19:59:00 19:59:00 ... 64
... 20:03:00 20:03:00 ... 65
... 20:03:00 20:03:00 ... 66
... 20:04:00 20:04:00 ... 67
... 20:04:00 20:04:00 ... 68
... 20:05:00 20:05:00 ... 69
... 20:05:00 20:05:00 ... 70
... 20:08:00 20:08:00 ... 71
... 20:11:00 20:11:00 ... 72
... 20:13:00 20:13:00 ... 73
... 20:13:00 20:13:00 ... 74
... 20:15:00 20:15:00 ... 75
... 20:16:00 20:16:00 ... 76
... 20:16:00 20:16:00 ... 77
... 20:19:00 20:19:00 ... 78
... 20:20:00 20:20:00 ... 79
... 20:20:00 20:20:00 ... 80
... 20:21:00 20:21:00 ... 81
... 20:22:00 20:22:00 ... 82
... 20:23:00 20:23:00 ... 83
... 20:24:00 20:24:00 ... 84
... 20:25:00 20:25:00 ... 85
... 20:26:00 20:26:00 ... 86
... 20:28:00 20:28:00 ... 87
... 20:28:00 20:28:00 ... 88
... 20:30:00 20:30:00 ... 89
... 20:31:00 20:31:00 ... 90
... 20:33:00 20:33:00 ... 91
... 20:34:00 20:34:00 ... 92
... 20:36:00 20:36:00 ... 93
... 20:36:00 20:36:00 ... 94
... 20:37:00 20:37:00 ... 95
... 20:38:00 20:38:00 ... 96
... 20:39:00 20:39:00 ... 97
... 20:39:00 20:39:00 ... 98
... 20:43:00 20:43:00 ... 99
... 20:44:00 20:44:00 ... 100
... 20:45:00 20:45:00 ... 101
... 20:46:00 20:46:00 ... 102
... 20:46:00 20:46:00 ... 103
... 20:47:00 20:47:00 ... 104
... 20:47:00 20:47:00 ... 105
... 20:48:00 20:48: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