Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:06:00	08:06:00	...	2
...	08:07:00	08:07:00	...	3
...	08:08:00	08:08:00	...	4
...	08:10:00	08:10:00	...	5
...	08:11:00	08:11:00	...	6
...	08:15:00	08:15:00	...	7
...	08:15:00	08:15:00	...	8
...	08:16:00	08:16:00	...	9
...	08:18:00	08:18:00	...	10
...	08:21:00	08:21:00	...	11
...	08:24:00	08:24:00	...	12
...	08:39:00	08:39:00	...	13
...	08:42:00	08:42:00	...	14
...	08:44:00	08:44:00	...	15
...	08:44:00	08:44:00	...	16
...	08:45:00	08:45:00	...	17
...	08:46:00	08:46:00	...	18
...	08:47:00	08:47:00	...	19
...	08:48:00	08:48:00	...	20
...	08:50:00	08:50:00	...	21

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
73724672	Scott Street	56.3958731886	-3.4322583161
73724742	Scroggiehill	56.417310208	-3.517034888
73724756	Hotel	56.425475696	-3.5179437665
73724757	Lumsden Crescent	56.4191974371	-3.5118574938
73726485	St Johns Academy	56.4099874428	-3.4393688245
73726983	School Bus Park	56.4109365915	-3.4466009328
73723523	Mountview	56.407833396	-3.5013099973
73724854	Royal Bank of Scotland	56.4017628345	-3.4396416652
73724848	Retail Park	56.4007906842	-3.4382438678
73723483	Lindsay Place	56.4096235769	-3.4436175888
73725646	Lindsay Place	56.4095212001	-3.4439216483
73724835	Duncansby Way	56.4084347953	-3.4492449297
73724842	ASDA	56.4053867437	-3.4448021993
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