Perth - Pitcairngreen circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:35:00	07:35:00	...	1
...	07:36:00	07:36:00	...	2
...	07:37:00	07:37:00	...	3
...	07:38:00	07:38:00	...	4
...	07:39:00	07:39:00	...	5
...	07:40:00	07:40:00	...	6
...	07:42:00	07:42:00	...	7
...	07:43:00	07:43:00	...	8
...	07:43:00	07:43:00	...	9
...	07:44:00	07:44:00	...	10
...	07:44:00	07:44:00	...	11
...	07:45:00	07:45:00	...	12
...	07:46:00	07:46:00	...	13
...	07:46:00	07:46:00	...	14
...	07:47:00	07:47:00	...	15
...	07:48:00	07:48:00	...	16
...	07:49:00	07:49:00	...	17
...	07:50:00	07:50:00	...	18
...	07:51:00	07:51:00	...	19
...	07:52:00	07:52:00	...	20
...	07:52:00	07:52:00	...	21
...	07:54:00	07:54:00	...	22
...	07:55:00	07:55:00	...	23
...	07:56:00	07:56:00	...	24
...	07:56:00	07:56:00	...	25
...	07:57:00	07:57:00	...	26
...	07:58:00	07:58:00	...	27
...	07:58:00	07:58:00	...	28
...	07:59:00	07:59:00	...	29
...	08:00:00	08:00:00	...	30
...	08:01:00	08:01:00	...	31

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
73723983	Scroggiehill	56.4173523378	-3.5172635157
73724756	Hotel	56.425475696	-3.5179437665
73725629	Leisure Pool	56.3955335276	-3.4429545814
73725654	Mountview	56.4077472268	-3.5024896864
73725323	Goodlyburn Place	56.3986730836	-3.4572344631
73723563	Hawarden Terrace	56.3982130972	-3.4535551358
73725282	Rose Crescent	56.398022969	-3.4513767749
73723736	Coach House Court	56.3967988276	-3.4461780097
73724897	Letham Road	56.3988722803	-3.459397037
73725285	Fairies Road	56.3988524597	-3.4626044165
73725342	Cargill Place	56.3988556488	-3.4668982621
73725268	Firbank Road	56.3987641236	-3.4708319979
73725272	Mavisbank Gardens	56.3982708957	-3.4737780314
73725275	Newhouse Road	56.3977899662	-3.4771943336
73724385	Soutar Crescent	56.3980560045	-3.4812552469
73723846	Ferguson Drive	56.4015038647	-3.4844679327
73723837	Trinafour	56.4042426937	-3.4823544793
73723479	Grange Terrace	56.4062093173	-3.4786873877
73725632	Elibank Street	56.3954461452	-3.4404238855
73725647	York Place	56.3953486343	-3.4372123714
73724657	South Methven Street	56.3960468152	-3.4343386223
73723478	Tesco	56.4071833305	-3.4783848371
73725653	Perth Mart	56.4072135012	-3.4878829186
73724732	Lochty Industrial Est	56.4099038514	-3.5157676441
73723984	RN Stores	56.4133782108	-3.5152736724
73723979	Bridgeton Store	56.420481659	-3.5170638893
73727686	Pigeon Rock	56.4220229188	-3.5188762362
73723463	Playing Fields	56.4270878376	-3.5176350679
73762689	Hotel	56.4253467901	-3.5181980563
73729494	Mackenzie Drive	56.4153784531	-3.5162933804