Perth - Letham and Tulloch circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 22:10:00 22:10:00 ... 1
... 22:10:00 22:10:00 ... 2
... 22:11:00 22:11:00 ... 3
... 22:12:00 22:12:00 ... 4
... 22:13:00 22:13:00 ... 5
... 22:14:00 22:14:00 ... 6
... 22:15:00 22:15:00 ... 7
... 22:17:00 22:17:00 ... 8
... 22:17:00 22:17:00 ... 9
... 22:18:00 22:18:00 ... 10
... 22:19:00 22:19:00 ... 11
... 22:20:00 22:20:00 ... 12
... 22:21:00 22:21:00 ... 13
... 22:22:00 22:22:00 ... 14
... 22:22:00 22:22:00 ... 15
... 22:23:00 22:23:00 ... 16
... 22:23:00 22:23:00 ... 17
... 22:24:00 22:24:00 ... 18
... 22:25:00 22:25:00 ... 19
... 22:25:00 22:25:00 ... 20
... 22:26:00 22:26:00 ... 21
... 22:26:00 22:26:00 ... 22
... 22:27:00 22:27:00 ... 23
... 22:27:00 22:27:00 ... 24
... 22:28:00 22:28:00 ... 25
... 22:29:00 22:29:00 ... 26
... 22:29:00 22:29:00 ... 27
... 22:30:00 22:30:00 ... 28
... 22:31:00 22:31:00 ... 29
... 22:32:00 22:32:00 ... 30
... 22:32:00 22:32:00 ... 31
... 22:33:00 22:33:00 ... 32
... 22:34:00 22:34:00 ... 33
... 22:35:00 22:35:00 ... 34
... 22:36:00 22:36:00 ... 35
... 22:37:00 22:37:00 ... 36
... 22:39:00 22:39:00 ... 37
... 22:39:00 22:39:00 ... 38
... 22:41:00 22:41:00 ... 39
... 22:42:00 22:42:00 ... 40
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
73725273 Mill Street 56.3975122623 -3.4342641246
73723734 Royal Infirmary 56.3974807857 -3.4554714765
73723232 Upper Rannoch Roundabout 56.401779976 -3.4763928787
73723972 Institute 56.4080291286 -3.4692122605
73724574 Kinnoull Street 56.3984758906 -3.4325180955
73723672 Crematorium 56.4075375281 -3.4712677368
73723658 Viewfield Place 56.4037357077 -3.444609993
73723473 Langside Road 56.4067714284 -3.476002768
73723856 Western Avenue 56.3971858208 -3.4515069335
73725629 Leisure Pool 56.3955335276 -3.4429545814
73723682 McDiarmid Park 56.4075050659 -3.4755125685
73723674 Unity Terrace 56.4044709048 -3.4516708512
73724854 Royal Bank of Scotland 56.4017628345 -3.4396416652
73724848 Retail Park 56.4007906842 -3.4382438678
73724865 Fairfield 56.4054723311 -3.4559224169
73724953 Bruce Crescent 56.4069098335 -3.4589916587
73724247 Tulloch Terrace 56.4099309882 -3.4611008115
73723436 Primary School 56.4119009281 -3.4624405741
73724389 Sandeman Court 56.4136679122 -3.4642265348
73724239 Newton Place 56.4133538834 -3.4672293244
73724343 Pullar Terrace 56.4100183703 -3.468916164
73723459 Garth Avenue 56.4063711359 -3.4711254848
73725297 Milton Road 56.4066062657 -3.4725120723
73725324 Strathtay Road 56.4062306378 -3.4685757401
73725325 Fortingall Place 56.4056066374 -3.465877777
73723274 Primary School 56.4038313655 -3.4678351249
73723256 Our Ladys Primary School 56.4041256116 -3.4718166745
73723252 Struan Road 56.4043868892 -3.4755377304
73723768 Cluny Terrace 56.403718265 -3.4773592034
73725265 Welcome Inn 56.4016817292 -3.4725649404
73725269 Day Centre 56.401209801 -3.4684147589
73725295 Dunsinane Drive 56.4007264457 -3.4652202524
73724392 Letham Road 56.4000412033 -3.4608514557
73725323 Goodlyburn Place 56.3986730836 -3.4572344631
73725632 Elibank Street 56.3954461452 -3.4404238855
73725647 York Place 56.3953486343 -3.4372123714
73724657 South Methven Street 56.3960468152 -3.4343386223
73724734 Newton House 56.4115840514 -3.466448034
73726796 Rosslyn House 56.3956544332 -3.4464586397
© 2017 Molten Mouse LTD