Perth - Kinnoull Hill circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:55:00	07:55:00	...	1
...	07:56:00	07:56:00	...	2
...	07:58:00	07:58:00	...	3
...	08:03:00	08:03:00	...	4
...	08:03:00	08:03:00	...	5
...	08:04:00	08:04:00	...	6
...	08:05:00	08:05:00	...	7
...	08:06:00	08:06:00	...	8
...	08:07:00	08:07:00	...	9
...	08:07:00	08:07:00	...	10
...	08:07:00	08:07:00	...	11
...	08:08:00	08:08:00	...	12
...	08:09:00	08:09:00	...	13
...	08:10:00	08:10:00	...	14
...	08:13:00	08:13:00	...	15
...	08:18:00	08:18:00	...	16
...	08:18:00	08:18:00	...	17
...	08:19:00	08:19:00	...	18
...	08:20:00	08:20:00	...	19
...	08:22:00	08:22:00	...	20
...	08:23:00	08:23:00	...	21
...	08:26:00	08:26:00	...	22
...	08:26:00	08:26:00	...	23
...	08:28:00	08:28:00	...	24
...	08:28:00	08:28:00	...	25
...	08:30:00	08:30:00	...	26
...	08:31:00	08:31:00	...	27
...	08:32:00	08:32:00	...	28
...	08:33:00	08:33:00	...	29
...	08:34:00	08:34:00	...	30
...	08:37:00	08:37:00	...	31
...	08:40:00	08:40:00	...	32

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
73724672	Scott Street	56.3958731886	-3.4322583161
73724568	Bridgend Court	56.4000837493	-3.4231968764
73724623	Lovat Hotel	56.3936291859	-3.4506101525
73723654	Perth Academy	56.3922776155	-3.4593552991
73723542	Corsie Way	56.3969344677	-3.4070557875
73723867	Potterhill Gardens	56.4002195983	-3.419183556
73724298	Memorial Home	56.3972853929	-3.4180536363
73725629	Leisure Pool	56.3955335276	-3.4429545814
73726798	Brands Brae	56.4067327118	-3.4121981677
73725276	Muirend Avenue	56.3930897694	-3.4659150843
73725632	Elibank Street	56.3954461452	-3.4404238855
73725647	York Place	56.3953486343	-3.4372123714
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
73726796	Rosslyn House	56.3956544332	-3.4464586397
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