Perth - Pitcairngreen circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 18:15:00 18:15:00 ... 1
... 18:16:00 18:16:00 ... 2
... 18:17:00 18:17:00 ... 3
... 18:18:00 18:18:00 ... 4
... 18:19:00 18:19:00 ... 5
... 18:20:00 18:20:00 ... 6
... 18:22:00 18:22:00 ... 7
... 18:22:00 18:22:00 ... 8
... 18:24:00 18:24:00 ... 9
... 18:25:00 18:25:00 ... 10
... 18:25:00 18:25:00 ... 11
... 18:26:00 18:26:00 ... 12
... 18:27:00 18:27:00 ... 13
... 18:27:00 18:27:00 ... 14
... 18:28:00 18:28:00 ... 15
... 18:29:00 18:29:00 ... 16
... 18:29:00 18:29:00 ... 17
... 18:31:00 18:31:00 ... 18
... 18:31:00 18:31:00 ... 19
... 18:33:00 18:33:00 ... 20
... 18:34:00 18:34:00 ... 21
... 18:35:00 18:35:00 ... 22
... 18:36:00 18:36:00 ... 23
... 18:37:00 18:37:00 ... 24
... 18:39:00 18:39:00 ... 25
... 18:42:00 18:42:00 ... 26
... 18:45:00 18:45:00 ... 27
... 18:46:00 18:46:00 ... 28
... 18:46:00 18:46:00 ... 29
... 18:47:00 18:47:00 ... 30
... 18:48:00 18:48:00 ... 31
... 18:50:00 18:50:00 ... 32
... 18:50:00 18:50:00 ... 33
... 18:51:00 18:51:00 ... 34
... 18:51:00 18:51:00 ... 35
... 18:52:00 18:52:00 ... 36
... 18:52:00 18:52:00 ... 37
... 18:53:00 18:53:00 ... 38
start_date end_date monday tuesday wednesday thursday friday saturday sunday
20/11/2017 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
73723838 Scott Street 56.3961306526 -3.4325272092
73725367 Primary School 56.4120622601 -3.493388563
73723983 Scroggiehill 56.4173523378 -3.5172635157
73724756 Hotel 56.425475696 -3.5179437665
73724757 Lumsden Crescent 56.4191974371 -3.5118574938
73725629 Leisure Pool 56.3955335276 -3.4429545814
73723797 Kingswell Terrace 56.4014275588 -3.4613906862
73723279 Mercer Terrace 56.4022371925 -3.4651162675
73725293 Marlee Road 56.4025609261 -3.4696497106
73723268 Campsie Road 56.402777618 -3.4725910622
73725292 Goodlyburn Terrace 56.4002985714 -3.4595974563
73725289 Rannoch Road 56.4002527833 -3.4566142956
73724726 Rannoch Road 56.4016107041 -3.4542193866
73723743 Wellshill Cemetery 56.4004977715 -3.4464317219
73723736 Coach House Court 56.3967988276 -3.4461780097
73724385 Soutar Crescent 56.3980560045 -3.4812552469
73723846 Ferguson Drive 56.4015038647 -3.4844679327
73723837 Trinafour 56.4042426937 -3.4823544793
73723479 Grange Terrace 56.4062093173 -3.4786873877
73753262 Hillcrest Avenue 56.4022391356 -3.4511969784
73725632 Elibank Street 56.3954461452 -3.4404238855
73725647 York Place 56.3953486343 -3.4372123714
73724657 South Methven Street 56.3960468152 -3.4343386223
73723478 Tesco 56.4071833305 -3.4783848371
73725653 Perth Mart 56.4072135012 -3.4878829186
73724732 Lochty Industrial Est 56.4099038514 -3.5157676441
73723984 RN Stores 56.4133782108 -3.5152736724
73724869 Gellyburn Road 56.4210590021 -3.5146712428
73723982 Roman Road 56.4195166582 -3.5144153896
73723979 Bridgeton Store 56.420481659 -3.5170638893
73727686 Pigeon Rock 56.4220229188 -3.5188762362
73723463 Playing Fields 56.4270878376 -3.5176350679
73762689 Hotel 56.4253467901 -3.5181980563
73729494 Mackenzie Drive 56.4153784531 -3.5162933804
73729472 Tweedsmuir Road 56.4029132921 -3.4747839071
73723963 Church Street 56.4016264801 -3.447495383
73729473 Leny Road 56.4006700059 -3.4775489615
73729469 Moulin Crescent 56.3987535573 -3.4777663514
© 2017 Molten Mouse LTD