Perth - Pitcairngreen circular

Details

trip_id arrival_time departure_time stop_id stop_sequence
... 15:15:00 15:15:00 ... 1
... 15:16:00 15:16:00 ... 2
... 15:17:00 15:17:00 ... 3
... 15:18:00 15:18:00 ... 4
... 15:19:00 15:19:00 ... 5
... 15:20:00 15:20:00 ... 6
... 15:22:00 15:22:00 ... 7
... 15:22:00 15:22:00 ... 8
... 15:24:00 15:24:00 ... 9
... 15:25:00 15:25:00 ... 10
... 15:25:00 15:25:00 ... 11
... 15:26:00 15:26:00 ... 12
... 15:27:00 15:27:00 ... 13
... 15:27:00 15:27:00 ... 14
... 15:28:00 15:28:00 ... 15
... 15:29:00 15:29:00 ... 16
... 15:29:00 15:29:00 ... 17
... 15:31:00 15:31:00 ... 18
... 15:31:00 15:31:00 ... 19
... 15:33:00 15:33:00 ... 20
... 15:34:00 15:34:00 ... 21
... 15:35:00 15:35:00 ... 22
... 15:36:00 15:36:00 ... 23
... 15:37:00 15:37:00 ... 24
... 15:38:00 15:38:00 ... 25
... 15:41:00 15:41:00 ... 26
... 15:44:00 15:44:00 ... 27
... 15:46:00 15:46:00 ... 28
... 15:49:00 15:49:00 ... 29
... 15:49:00 15:49:00 ... 30
... 15:51:00 15:51:00 ... 31
... 15:51:00 15:51:00 ... 32
... 15:53:00 15:53:00 ... 33
... 15:54:00 15:54:00 ... 34
... 15:55:00 15:55:00 ... 35
... 15:56:00 15:56:00 ... 36
... 15:57:00 15:57:00 ... 37
... 15:58:00 15:58:00 ... 38
... 15:59:00 15:59:00 ... 39
... 15:59:00 15:59:00 ... 40
... 16:00:00 16:00:00 ... 41
... 16:02:00 16:02:00 ... 42
... 16:03:00 16:03:00 ... 43
... 16:03:00 16:03:00 ... 44
... 16:06:00 16:06:00 ... 45
... 16:09:00 16:09:00 ... 46
... 16:10:00 16:10:00 ... 47
... 16:11:00 16:11:00 ... 48
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
73798934 Whitehouse 56.40779066 -3.4884564706
73723838 Scott Street 56.3961306526 -3.4325272092
73723474 Primary School 56.4124640685 -3.494344406
73725629 Leisure Pool 56.3955335276 -3.4429545814
73723537 South Street 56.3953599393 -3.4339077601
73725654 Mountview 56.4077472268 -3.5024896864
73723689 Tesco 56.4073399684 -3.4788122776
73723748 Moulin Crescent 56.3986973544 -3.4779586057
73723797 Kingswell Terrace 56.4014275588 -3.4613906862
73725327 Mercer Terrace 56.4022492445 -3.4640958679
73723279 Mercer Terrace 56.4022371925 -3.4651162675
73723259 Marlee Road 56.402633543 -3.4695876923
73725293 Marlee Road 56.4025609261 -3.4696497106
73725298 Campsie Road 56.4028198887 -3.4720579485
73723268 Campsie Road 56.402777618 -3.4725910622
73723265 Tweedsmuir Road 56.4031664533 -3.4769165015
73723264 Kingswell Place 56.4012278465 -3.4600381224
73723263 Kingswell Terrace 56.4010777563 -3.4575208083
73725292 Goodlyburn Terrace 56.4002985714 -3.4595974563
73725289 Rannoch Road 56.4002527833 -3.4566142956
73724728 Rannoch Road 56.4019441479 -3.4541348802
73724726 Rannoch Road 56.4016107041 -3.4542193866
73723586 Hillcrest Avenue 56.4021177578 -3.4508196648
73724723 Church Street 56.4015664473 -3.4472500465
73724769 Wellshill Cemetery 56.4004729059 -3.4462525416
73723743 Wellshill Cemetery 56.4004977715 -3.4464317219
73723583 Long Causeway 56.3979637643 -3.4394982381
73723736 Coach House Court 56.3967988276 -3.4461780097
73724385 Soutar Crescent 56.3980560045 -3.4812552469
73724525 Soutar Crescent 56.3981825136 -3.4811953511
73724943 Ferguson Drive 56.4014159928 -3.4843024728
73723846 Ferguson Drive 56.4015038647 -3.4844679327
73724636 Trinafour 56.4038299514 -3.4823060214
73723837 Trinafour 56.4042426937 -3.4823544793
73723479 Grange Terrace 56.4062093173 -3.4786873877
73725296 Grange Terrace 56.4061551392 -3.477956022
73753262 Hillcrest Avenue 56.4022391356 -3.4511969784
73725632 Elibank Street 56.3954461452 -3.4404238855
73723562 York Place 56.3954844796 -3.4371202834
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
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