Riccarton - Ocean Terminal - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:20:00	08:20:00	...	1
...	08:21:00	08:21:00	...	2
...	08:22:00	08:22:00	...	3
...	08:23:00	08:23:00	...	4
...	08:25:00	08:25:00	...	5
...	08:26:00	08:26:00	...	6
...	08:27:00	08:27:00	...	7
...	08:28:00	08:28:00	...	8
...	08:30:00	08:30:00	...	9
...	08:31:00	08:31:00	...	10
...	08:32:00	08:32:00	...	11
...	08:33:00	08:33:00	...	12
...	08:34:00	08:34:00	...	13
...	08:36:00	08:36:00	...	14
...	08:37:00	08:37:00	...	15
...	08:39:00	08:39:00	...	16
...	08:40:00	08:40:00	...	17
...	08:40:00	08:40:00	...	18
...	08:41:00	08:41:00	...	19
...	08:42:00	08:42:00	...	20
...	08:44:00	08:44:00	...	21
...	08:45:00	08:45:00	...	22
...	08:47:00	08:47:00	...	23
...	08:48:00	08:48:00	...	24
...	08:51:00	08:51:00	...	25
...	08:52:00	08:52:00	...	26
...	08:54:00	08:54:00	...	27
...	08:56:00	08:56:00	...	28

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
29/07/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
36234873	The Avenue	55.9101572474	-3.3175251856
36236485	Port Hamilton	55.943366254	-3.2081575153
36236486	Gilmore Park	55.9423809195	-3.2124177678
36236489	Fountain Park	55.9411877544	-3.2158707659
36236493	Dundee Terrace	55.940105771	-3.218974827
36236496	Angle Park Terrace	55.9386365088	-3.2239716427
36236498	St Michaels Church	55.9367409361	-3.2275458207
36236525	Shandon Place	55.9350773712	-3.2312710846
36236526	Hermand Street	55.9335710525	-3.2345368219
36236528	Hutchison Crossway	55.9306922036	-3.2384628108
36236532	Hutchison Place	55.9293816321	-3.2401175961
36236535	Slateford Station	55.927178471	-3.24296008
36238754	Allan Park Road	55.9250402273	-3.245596277
36235949	Water of Leith Centre	55.9232215086	-3.2477303586
36235359	Inglis Green Road	55.9236027814	-3.2517754425
36235363	Longstone Park	55.9252432876	-3.2583259552
36235367	Longstone Crescent	55.9250474791	-3.2634088548
36232586	Longstone Gardens	55.9253640399	-3.267580212
36232587	Longstone Terrace	55.9257574635	-3.2695135651
36234858	Parkhead Terrace	55.9259332927	-3.2716318832
36234859	Sighthill Post office	55.9247225699	-3.2766174249
36234862	Sighthill Gardens	55.9234542417	-3.2828010066
36234863	Napier University (Sighthill)	55.9228016586	-3.2876443725
36234864	Wester Hailes Road	55.921866566	-3.2928462368
36234867	Calder View	55.9208029706	-3.2982835929
36246389	Hermiston Park & Ride	55.9171220106	-3.314081286
36246974	Research Avenue North	55.9144978247	-3.3250162958
36246945	Boundary Road North	55.9125772746	-3.3239588447