Dunure - Ayr - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	22:46:00	22:46:00	...	1
...	22:46:11	22:46:11	...	2
...	22:47:19	22:47:19	...	3
...	22:49:25	22:49:25	...	4
...	22:51:00	22:51:00	...	5
...	22:54:31	22:54:31	...	6
...	22:55:20	22:55:20	...	7
...	22:56:16	22:56:16	...	8
...	22:56:38	22:56:38	...	9
...	22:57:02	22:57:02	...	10
...	22:58:15	22:58:15	...	11
...	22:58:42	22:58:42	...	12
...	22:59:26	22:59:26	...	13
...	22:59:58	22:59:58	...	14
...	23:01:01	23:01:01	...	15
...	23:01:24	23:01:24	...	16
...	23:01:54	23:01:54	...	17
...	23:02:24	23:02:24	...	18
...	23:02:55	23:02:55	...	19
...	23:03:38	23:03:38	...	20
...	23:04:04	23:04:04	...	21
...	23:04:31	23:04:31	...	22
...	23:05:05	23:05:05	...	23
...	23:06:00	23:06:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
29723675	Earls Way	55.4328562284	-4.6533629202
29723426	Scaur o Doon Road	55.4358894967	-4.6486179949
29723925	Greenfield Avenue	55.4369506056	-4.6465230697
29723689	Chapelpark Road	55.4445308144	-4.6293196974
29724737	Bellvale Avenue	55.446663415	-4.6287974151
29723484	Arran View	55.4048049446	-4.7595707019
29724636	Carrick Gardens	55.451108392	-4.6294253342
29723856	Ballantine Drive	55.4541804178	-4.6291078605
29724264	Barnes Crescent	55.4581322077	-4.6342747726
29724572	Beresford Terrace	55.4579912928	-4.6299626584
29723672	Bellevue Street	55.4560792576	-4.6294240719
29725378	Fisherton Primary School	55.4133341326	-4.7424680153
29725687	Corsehill Road	55.4488498306	-4.629116862
29723247	Bus Station	55.4620991148	-4.6341438916
29724932	Holiday Park	55.4259545234	-4.6841643214
29723263	Clochranhill Road	55.4330610318	-4.633078075
29725487	Harbour view	55.4065296545	-4.7580321137
29724342	Belleisle Golf Course	55.4361261948	-4.6318277352
29723934	Rozelle House	55.4384005808	-4.6309830942
29723754	Longbank Road	55.4429044558	-4.629290546
29787274	Ailsa View	55.432094851	-4.6594455322
29792343	Mount Charles Crescent	55.436237418	-4.6437559706
29792372	Wrightfield Place	55.4329519911	-4.6364697019
29796745	Caravan Park	55.4237869068	-4.7111076596