Straiton or Ayr - Dunure - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	21:20:00	21:20:00	...	1
...	21:21:05	21:21:05	...	2
...	21:21:43	21:21:43	...	3
...	21:22:16	21:22:16	...	4
...	21:22:37	21:22:37	...	5
...	21:22:59	21:22:59	...	6
...	21:23:31	21:23:31	...	7
...	21:23:57	21:23:57	...	8
...	21:24:23	21:24:23	...	9
...	21:25:07	21:25:07	...	10
...	21:25:45	21:25:45	...	11
...	21:27:16	21:27:16	...	12
...	21:28:54	21:28:54	...	13
...	21:31:21	21:31:21	...	14
...	21:32:01	21:32:01	...	15
...	21:32:34	21:32:34	...	16
...	21:33:27	21:33:27	...	17
...	21:34:00	21:34:00	...	18
...	21:34:18	21:34:18	...	19
...	21:34:31	21:34:31	...	20
...	21:34:52	21:34:52	...	21
...	21:35:10	21:35:10	...	22
...	21:35:31	21:35:31	...	23
...	21:35:45	21:35:45	...	24
...	21:36:02	21:36:02	...	25
...	21:36:10	21:36:10	...	26
...	21:38:33	21:38:33	...	27
...	21:40:48	21:40:48	...	28
...	21:44:02	21:44:02	...	29
...	21:45:42	21:45:42	...	30
...	21:46:00	21:46: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