Straiton or Ayr - Dunure - Transport Data Hub

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