Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:54:00	18:54:00	...	1
...	18:55:00	18:55:00	...	2
...	18:56:00	18:56:00	...	3
...	18:59:00	18:59:00	...	4
...	18:59:00	18:59:00	...	5
...	18:59:00	18:59:00	...	6
...	19:00:00	19:00:00	...	7
...	19:01:00	19:01:00	...	8
...	19:02:00	19:02:00	...	9
...	19:04:00	19:04:00	...	10
...	19:04:00	19:04:00	...	11
...	19:06:00	19:06:00	...	12
...	19:06:00	19:06:00	...	13
...	19:08:00	19:08:00	...	14
...	19:08:00	19:08:00	...	15
...	19:09:00	19:09:00	...	16
...	19:09:00	19:09:00	...	17
...	19:10:00	19:10:00	...	18
...	19:11:00	19:11:00	...	19
...	19:12:00	19:12:00	...	20
...	19:13:00	19:13:00	...	21
...	19:14:00	19:14:00	...	22
...	19:15:00	19:15:00	...	23
...	19:17:00	19:17:00	...	24
...	19:18:00	19:18:00	...	25
...	19:18:00	19:18:00	...	26
...	19:19:00	19:19:00	...	27
...	19:21:00	19:21:00	...	28

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
73745845	Castle Brae	56.4074937372	-3.4892389936
73723838	Scott Street	56.3961306526	-3.4325272092
73724742	Scroggiehill	56.417310208	-3.517034888
73724756	Hotel	56.425475696	-3.5179437665
73723535	Leisure Pool	56.3956822506	-3.4433004363
73723537	South Street	56.3953599393	-3.4339077601
73723523	Mountview	56.407833396	-3.5013099973
73723689	Tesco	56.4073399684	-3.4788122776
73723579	Goodlyburn Place	56.3988582621	-3.4575331885
73723569	Hawarden Terrace	56.3982547165	-3.453070649
73723567	Spens crescent	56.3982209711	-3.4498126762
73724758	Coach House Court	56.3970867937	-3.4461403243
73723576	Fairies Road	56.3989619529	-3.4624627913
73723595	Cargill Place	56.3989425861	-3.4671446481
73723594	Firbank Road	56.3988956217	-3.4703509871
73723493	Mavisbank Gardens	56.3982746788	-3.4742156454
73723487	Newhouse Road	56.3979235251	-3.4772967216
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
73723536	Elibank Street	56.3955834977	-3.4402022554
73723985	Lochty Industrial Est	56.409568317	-3.5152842856
73724729	RN Stores	56.4137124844	-3.5151248712
73723965	Bridgeton Store	56.4204303499	-3.5168510896
73723976	Pigeon Rock	56.4220518457	-3.518715262
73729495	Mackenzie Drive	56.4157359071	-3.5164534938