Straiton or Ayr - Dunure - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	13:10:00	13:10:00	...	1
...	13:11:05	13:11:05	...	2
...	13:11:43	13:11:43	...	3
...	13:12:16	13:12:16	...	4
...	13:12:37	13:12:37	...	5
...	13:12:59	13:12:59	...	6
...	13:13:31	13:13:31	...	7
...	13:13:57	13:13:57	...	8
...	13:14:23	13:14:23	...	9
...	13:15:07	13:15:07	...	10
...	13:15:45	13:15:45	...	11
...	13:17:16	13:17:16	...	12
...	13:18:54	13:18:54	...	13
...	13:21:21	13:21:21	...	14
...	13:22:01	13:22:01	...	15
...	13:22:34	13:22:34	...	16
...	13:23:27	13:23:27	...	17
...	13:24:00	13:24:00	...	18
...	13:24:28	13:24:28	...	19
...	13:24:48	13:24:48	...	20
...	13:25:19	13:25:19	...	21
...	13:25:48	13:25:48	...	22
...	13:26:19	13:26:19	...	23
...	13:26:41	13:26:41	...	24
...	13:27:08	13:27:08	...	25
...	13:27:20	13:27:20	...	26
...	13:31:00	13:31:00	...	27
...	13:32:30	13:32:30	...	28
...	13:34:41	13:34:41	...	29
...	13:35:47	13:35:47	...	30
...	13:36:00	13:36:00	...	31

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
26/03/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
29723569	Smith Street	55.4581268872	-4.6278361438
29724375	Chapelpark Road	55.4449046029	-4.6290757399
29723959	Bellvale Quadrant	55.4473054651	-4.6286187308
29723642	Robsland Avenue	55.4487468712	-4.6288885991
29723545	Rosebank Crescent	55.4502003077	-4.6290169484
29723843	Ayr Road	55.4129752482	-4.7428381673
29723484	Arran View	55.4048049446	-4.7595707019
29723274	Carrick Avenue	55.4519692624	-4.6291030428
29723573	Carrick House Nursing Home	55.4531871357	-4.6288993976
29723945	Abbots Way	55.4348484481	-4.6551724712
29724548	Ballantine Drive	55.4543729883	-4.6289308701
29723529	Harbour View	55.4064790072	-4.7578863944
29723874	Bellevue Street	55.4562006995	-4.6292107036
29725978	Holiday Park	55.4257113418	-4.6858232624
29726373	Longbank Road	55.4428001384	-4.629125478
29724942	Fullarton Street	55.4611605861	-4.6313918729
29723854	Doonholm Road	55.4325920356	-4.6335685215
29723487	Beagle Crescent	55.4377751807	-4.650783952
29723647	Belleisle Golf Course	55.4378510051	-4.6310413747
29786297	Greenan Way	55.437749865	-4.6589880603
29785758	Greenan Grove	55.4360795651	-4.6609784451
29785679	Crossburn	55.4315019	-4.6606703089
29786363	Browncarrick	55.4306589043	-4.6609929659
29786347	Cairnsmore Drive	55.4308038396	-4.6576356084
29785654	Newark Crescent	55.4307264729	-4.6549904718
29785824	Kilbrandon Crescent	55.4359529332	-4.6585351638
29725874	Abbots Way	55.4360857647	-4.6495165129
29726254	Belleisle Cottages	55.43684861	-4.645836393
29726829	Dunure Road	55.4328802073	-4.6543288695
29724525	Earls Way	55.4381240087	-4.655835228
29796743	Caravan Park	55.4237133532	-4.7111816439