Perth - Kinnoull Hill circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:05:00	15:05:00	...	1
...	15:09:00	15:09:00	...	2
...	15:09:00	15:09:00	...	3
...	15:10:00	15:10:00	...	4
...	15:11:00	15:11:00	...	5
...	15:12:00	15:12:00	...	6
...	15:13:00	15:13:00	...	7
...	15:13:00	15:13:00	...	8
...	15:13:00	15:13:00	...	9
...	15:14:00	15:14:00	...	10
...	15:15:00	15:15:00	...	11
...	15:16:00	15:16:00	...	12
...	15:19:00	15:19:00	...	13
...	15:22:00	15:22:00	...	14
...	15:22:00	15:22:00	...	15
...	15:23:00	15:23:00	...	16
...	15:24:00	15:24:00	...	17
...	15:25:00	15:25:00	...	18
...	15:26:00	15:26:00	...	19
...	15:28:00	15:28:00	...	20
...	15:28:00	15:28:00	...	21
...	15:30:00	15:30:00	...	22

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
73723539	South Street	56.3952633806	-3.4305991026
73724568	Bridgend Court	56.4000837493	-3.4231968764
73723542	Corsie Way	56.3969344677	-3.4070557875
73723867	Potterhill Gardens	56.4002195983	-3.419183556
73724298	Memorial Home	56.3972853929	-3.4180536363
73726798	Brands Brae	56.4067327118	-3.4121981677
73723859	Commercial Street	56.3970979227	-3.421870304
73723862	Hatton Way	56.3959084064	-3.4064184822
73723543	Langley Place	56.3980122552	-3.4063016468
73723864	Langley Drive	56.3989278054	-3.4063840192
73723852	Murray Royal Hospital	56.3990842286	-3.4123847779
73724976	Strathmore Street	56.4025920771	-3.4222858444
73724283	Comleybank	56.4051387366	-3.4211654559
73725238	Fitzroy Terrace	56.4067460721	-3.4181138331
73734252	The Hub	56.4011907251	-3.4136132599
73787285	Rohallion	56.4013690529	-3.4113675634
73726728	Farm Road	56.4070388057	-3.4145107684
73727642	High Street	56.396829358	-3.4264777912
73727647	George Street	56.3977934084	-3.427810027
73727645	Kinnoull Street	56.3970401947	-3.4323507512
73727643	Bowerswell Road	56.3975986924	-3.4205117991
73727637	Hatton View	56.3959102256	-3.411003524