Perth - Letham and Tulloch circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 14:15:00 14:15:00 ... 1
... 14:15:00 14:15:00 ... 2
... 14:17:00 14:17:00 ... 3
... 14:17:00 14:17:00 ... 4
... 14:18:00 14:18:00 ... 5
... 14:19:00 14:19:00 ... 6
... 14:21:00 14:21:00 ... 7
... 14:23:00 14:23:00 ... 8
... 14:23:00 14:23:00 ... 9
... 14:24:00 14:24:00 ... 10
... 14:25:00 14:25:00 ... 11
... 14:26:00 14:26:00 ... 12
... 14:27:00 14:27:00 ... 13
... 14:28:00 14:28:00 ... 14
... 14:29:00 14:29:00 ... 15
... 14:29:00 14:29:00 ... 16
... 14:30:00 14:30:00 ... 17
... 14:31:00 14:31:00 ... 18
... 14:32:00 14:32:00 ... 19
... 14:33:00 14:33:00 ... 20
... 14:33:00 14:33:00 ... 21
... 14:33:00 14:33:00 ... 22
... 14:34:00 14:34:00 ... 23
... 14:35:00 14:35:00 ... 24
... 14:36:00 14:36:00 ... 25
... 14:37:00 14:37:00 ... 26
... 14:37:00 14:37:00 ... 27
... 14:38:00 14:38:00 ... 28
... 14:39:00 14:39:00 ... 29
... 14:40:00 14:40:00 ... 30
... 14:41:00 14:41:00 ... 31
... 14:42:00 14:42:00 ... 32
... 14:43:00 14:43:00 ... 33
... 14:44:00 14:44:00 ... 34
... 14:45:00 14:45:00 ... 35
... 14:47:00 14:47:00 ... 36
... 14:48:00 14:48:00 ... 37
... 14:49:00 14:49:00 ... 38
... 14:51:00 14:51:00 ... 39
... 14:52:00 14:52: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