Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:20:00	15:20:00	...	1
...	15:25:00	15:25:00	...	2
...	15:27:00	15:27:00	...	3
...	15:29:00	15:29:00	...	4
...	15:32:00	15:32:00	...	5
...	15:34:00	15:34:00	...	6
...	15:35:00	15:35:00	...	7
...	15:47:00	15:47:00	...	8
...	15:50:00	15:50:00	...	9
...	15:52:00	15:52:00	...	10
...	15:52:00	15:52:00	...	11
...	15:53:00	15:53:00	...	12
...	15:54:00	15:54:00	...	13
...	15:55:00	15:55:00	...	14
...	15:56:00	15:56:00	...	15
...	15:58:00	15:58:00	...	16
...	15:58:00	15:58:00	...	17
...	15:59:00	15:59:00	...	18
...	16:00:00	16:00:00	...	19
...	16:02:00	16:02: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
73724672	Scott Street	56.3958731886	-3.4322583161
73723983	Scroggiehill	56.4173523378	-3.5172635157
73724757	Lumsden Crescent	56.4191974371	-3.5118574938
73726983	School Bus Park	56.4109365915	-3.4466009328
73725654	Mountview	56.4077472268	-3.5024896864
73724528	Royal Bank of Scotland	56.4025897628	-3.4411636799
73724234	Barrack Street	56.399796989	-3.4371531885
73723825	Water Works	56.4101624142	-3.4474953775
73723932	Duncansby Way	56.4082081827	-3.4494145873
73723782	ASDA	56.405168552	-3.4450208052
73725653	Perth Mart	56.4072135012	-3.4878829186
73725354	Lochty	56.4091798844	-3.5147177971
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
73762689	Hotel	56.4253467901	-3.5181980563
73729494	Mackenzie Drive	56.4153784531	-3.5162933804