Perth - Tulloch and Letham circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 19:00:00 19:00:00 ... 1
... 19:01:00 19:01:00 ... 2
... 19:02:00 19:02:00 ... 3
... 19:03:00 19:03:00 ... 4
... 19:05:00 19:05:00 ... 5
... 19:06:00 19:06:00 ... 6
... 19:06:00 19:06:00 ... 7
... 19:07:00 19:07:00 ... 8
... 19:08:00 19:08:00 ... 9
... 19:09:00 19:09:00 ... 10
... 19:10:00 19:10:00 ... 11
... 19:11:00 19:11:00 ... 12
... 19:11:00 19:11:00 ... 13
... 19:12:00 19:12:00 ... 14
... 19:13:00 19:13:00 ... 15
... 19:14:00 19:14:00 ... 16
... 19:15:00 19:15:00 ... 17
... 19:15:00 19:15:00 ... 18
... 19:16:00 19:16:00 ... 19
... 19:17:00 19:17:00 ... 20
... 19:17:00 19:17:00 ... 21
... 19:18:00 19:18:00 ... 22
... 19:19:00 19:19:00 ... 23
... 19:19:00 19:19:00 ... 24
... 19:21:00 19:21:00 ... 25
... 19:21:00 19:21:00 ... 26
... 19:22:00 19:22:00 ... 27
... 19:23:00 19:23:00 ... 28
... 19:24:00 19:24:00 ... 29
... 19:25:00 19:25:00 ... 30
... 19:26:00 19:26:00 ... 31
... 19:27:00 19:27:00 ... 32
... 19:27:00 19:27:00 ... 33
... 19:28:00 19:28:00 ... 34
... 19:29:00 19:29:00 ... 35
... 19:29:00 19:29:00 ... 36
... 19:30:00 19:30:00 ... 37
... 19:31:00 19:31:00 ... 38
... 19:32:00 19:32:00 ... 39
start_date end_date monday tuesday wednesday thursday friday saturday sunday
13/08/2018 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
73725642 Mill Street 56.3975154466 -3.4339888091
73724763 Royal Infirmary 56.3978425046 -3.4552746528
73725326 Upper Rannoch Roundabout 56.4018581873 -3.4758611739
73724783 Institute 56.4076425564 -3.4692297741
73723838 Scott Street 56.3961306526 -3.4325272092
73726527 Viewfield Place 56.4036419324 -3.4449467386
73723464 Langside Road 56.4069104619 -3.4748899247
73723528 Spens Crescent 56.3964465582 -3.4501826626
73723535 Leisure Pool 56.3956822506 -3.4433004363
73723537 South Street 56.3953599393 -3.4339077601
73725294 McDiarmid Park 56.407423348 -3.4748287366
73724546 Unity Terrace 56.4044449766 -3.4523504768
73724528 Royal Bank of Scotland 56.4025897628 -3.4411636799
73724234 Barrack Street 56.399796989 -3.4371531885
73724363 Fairfield 56.4058715768 -3.4571206796
73724379 Bruce Crescent 56.4071406957 -3.4599890749
73724253 Tulloch Terrace 56.4099539231 -3.4614420468
73725279 Primary School 56.4112720568 -3.4624326524
73724923 Sandeman Court 56.4135503923 -3.4642868556
73723967 Newton Place 56.4128567112 -3.4659621155
73725239 Pullar Terrace 56.4099474807 -3.4688323948
73724696 Primrose Crescent 56.4087556399 -3.4693212976
73723968 Newton House 56.4113052532 -3.4664697233
73723457 Garth Avenue 56.4064288654 -3.4708035933
73723453 Strathtay Road 56.4063907967 -3.4679498782
73725328 Appin Terrace 56.4037561192 -3.4666006616
73725283 Primary School 56.4038580476 -3.4693756144
73725274 Our Ladys Primary School 56.4041673195 -3.4736008356
73724548 Cluny Terrace 56.4038287395 -3.477136616
73724796 Fortingall Place 56.4054042831 -3.4655134749
73723626 Welcome Inn 56.4017671748 -3.4721793447
73723246 Letham Day Centre 56.4014323746 -3.4693469493
73723284 Dunsinane Drive 56.4008414782 -3.465370505
73724849 Letham Road 56.4000799898 -3.4606098931
73723579 Goodlyburn Place 56.3988582621 -3.4575331885
73723534 Rosslyn House 56.3957777174 -3.448213064
73723562 York Place 56.3954844796 -3.4371202834
73723536 Elibank Street 56.3955834977 -3.4402022554
© 2017 Molten Mouse LTD