Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:49:00	08:49:00	...	1
...	08:49:00	08:49:00	...	2
...	08:51:00	08:51:00	...	3
...	08:51:00	08:51:00	...	4
...	08:53:00	08:53:00	...	5
...	08:54:00	08:54:00	...	6
...	08:55:00	08:55:00	...	7
...	08:56:00	08:56:00	...	8
...	08:57:00	08:57:00	...	9
...	08:58:00	08:58:00	...	10
...	08:59:00	08:59:00	...	11
...	08:59:00	08:59:00	...	12
...	09:00:00	09:00:00	...	13
...	09:02:00	09:02:00	...	14
...	09:03:00	09:03:00	...	15
...	09:03:00	09:03:00	...	16
...	09:06:00	09:06:00	...	17
...	09:09:00	09:09:00	...	18
...	09:10:00	09:10:00	...	19
...	09:11:00	09:11:00	...	20

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
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