Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:02:00	08:02:00	...	1
...	08:03:00	08:03:00	...	2
...	08:03:00	08:03:00	...	3
...	08:03:00	08:03:00	...	4
...	08:05:00	08:05:00	...	5
...	08:06:00	08:06:00	...	6
...	08:09:00	08:09:00	...	7
...	08:09:00	08:09:00	...	8
...	08:09:00	08:09:00	...	9
...	08:10:00	08:10:00	...	10
...	08:14:00	08:14:00	...	11
...	08:16:00	08:16:00	...	12
...	08:19:00	08:19:00	...	13
...	08:19:00	08:19:00	...	14
...	08:21:00	08:21:00	...	15
...	08:21:00	08:21:00	...	16
...	08:23:00	08:23:00	...	17
...	08:24:00	08:24:00	...	18
...	08:25:00	08:25:00	...	19
...	08:26:00	08:26:00	...	20
...	08:27:00	08:27:00	...	21
...	08:28:00	08:28:00	...	22
...	08:29:00	08:29:00	...	23
...	08:29:00	08:29:00	...	24
...	08:30:00	08:30:00	...	25
...	08:32:00	08:32:00	...	26
...	08:33:00	08:33:00	...	27
...	08:34:00	08:34:00	...	28
...	08:37:00	08:37:00	...	29
...	08:39:00	08:39:00	...	30
...	08:40:00	08:40:00	...	31
...	08:42:00	08:42:00	...	32

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
73724742	Scroggiehill	56.417310208	-3.517034888
73724756	Hotel	56.425475696	-3.5179437665
73724757	Lumsden Crescent	56.4191974371	-3.5118574938
73723537	South Street	56.3953599393	-3.4339077601
73723689	Tesco	56.4073399684	-3.4788122776
73723748	Moulin Crescent	56.3986973544	-3.4779586057
73725327	Mercer Terrace	56.4022492445	-3.4640958679
73723259	Marlee Road	56.402633543	-3.4695876923
73725298	Campsie Road	56.4028198887	-3.4720579485
73723265	Tweedsmuir Road	56.4031664533	-3.4769165015
73723264	Kingswell Place	56.4012278465	-3.4600381224
73723263	Kingswell Terrace	56.4010777563	-3.4575208083
73724728	Rannoch Road	56.4019441479	-3.4541348802
73723586	Hillcrest Avenue	56.4021177578	-3.4508196648
73724723	Church Street	56.4015664473	-3.4472500465
73724769	Wellshill Cemetery	56.4004729059	-3.4462525416
73723583	Long Causeway	56.3979637643	-3.4394982381
73724525	Soutar Crescent	56.3981825136	-3.4811953511
73724943	Ferguson Drive	56.4014159928	-3.4843024728
73724636	Trinafour	56.4038299514	-3.4823060214
73725296	Grange Terrace	56.4061551392	-3.477956022
73723562	York Place	56.3954844796	-3.4371202834
73723985	Lochty Industrial Est	56.409568317	-3.5152842856
73724729	RN Stores	56.4137124844	-3.5151248712
73724869	Gellyburn Road	56.4210590021	-3.5146712428
73723965	Bridgeton Store	56.4204303499	-3.5168510896
73723982	Roman Road	56.4195166582	-3.5144153896
73723976	Pigeon Rock	56.4220518457	-3.518715262
73729495	Mackenzie Drive	56.4157359071	-3.5164534938