Perth - Tulloch and Letham circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 11:00:00 11:00:00 ... 1
... 11:01:00 11:01:00 ... 2
... 11:02:00 11:02:00 ... 3
... 11:03:00 11:03:00 ... 4
... 11:05:00 11:05:00 ... 5
... 11:06:00 11:06:00 ... 6
... 11:07:00 11:07:00 ... 7
... 11:08:00 11:08:00 ... 8
... 11:09:00 11:09:00 ... 9
... 11:10:00 11:10:00 ... 10
... 11:11:00 11:11:00 ... 11
... 11:12:00 11:12:00 ... 12
... 11:12:00 11:12:00 ... 13
... 11:13:00 11:13:00 ... 14
... 11:14:00 11:14:00 ... 15
... 11:15:00 11:15:00 ... 16
... 11:16:00 11:16:00 ... 17
... 11:16:00 11:16:00 ... 18
... 11:17:00 11:17:00 ... 19
... 11:18:00 11:18:00 ... 20
... 11:18:00 11:18:00 ... 21
... 11:19:00 11:19:00 ... 22
... 11:20:00 11:20:00 ... 23
... 11:20:00 11:20:00 ... 24
... 11:22:00 11:22:00 ... 25
... 11:22:00 11:22:00 ... 26
... 11:23:00 11:23:00 ... 27
... 11:24:00 11:24:00 ... 28
... 11:25:00 11:25:00 ... 29
... 11:26:00 11:26:00 ... 30
... 11:27:00 11:27:00 ... 31
... 11:29:00 11:29:00 ... 32
... 11:30:00 11:30:00 ... 33
... 11:31:00 11:31:00 ... 34
... 11:32:00 11:32:00 ... 35
... 11:33:00 11:33:00 ... 36
... 11:34:00 11:34:00 ... 37
... 11:35:00 11:35:00 ... 38
... 11:37:00 11:37: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