Melrose - Edinburgh

Details

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