Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	10:59:00	10:59:00	...	1
...	11:09:00	11:09:00	...	2
...	11:13:00	11:13:00	...	3
...	11:16:00	11:16:00	...	4
...	11:19:00	11:19:00	...	5
...	11:24:00	11:24:00	...	6
...	11:25:00	11:25:00	...	7
...	11:30:00	11:30:00	...	8
...	11:34:00	11:34:00	...	9
...	11:35:00	11:35:00	...	10
...	11:38:00	11:38:00	...	11
...	11:39:00	11:39:00	...	12
...	11:39:00	11:39:00	...	13
...	11:40:00	11:40:00	...	14
...	11:40:00	11:40:00	...	15
...	11:41:00	11:41:00	...	16
...	11:42:00	11:42:00	...	17
...	11:45:00	11:45:00	...	18
...	11:48:00	11:48:00	...	19
...	11:49:00	11:49:00	...	20
...	11:51:00	11:51:00	...	21
...	11:52:00	11:52:00	...	22
...	11:52:00	11:52:00	...	23
...	11:53:00	11:53:00	...	24
...	11:54:00	11:54:00	...	25
...	11:59:00	11:59:00	...	26

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

stop_code	stop_name	stop_lat	stop_lon
29738939	Kilantringan Loch	55.0682502316	-4.9856936891
29723847	Elder Avenue	55.2325915174	-4.8538806512
29724753	Arrol Avenue	55.0999473347	-5.0044265399
29724729	Old Smyrton	55.0804179286	-4.9767281109
29725425	Telephone Exchange	55.1688134589	-4.9354306036
29748545	Bennane Head Access Path	55.1441354191	-4.9828077459
29748567	Glenapp Church	55.0286857756	-5.0144104292
29739525	Finnarts Bay	55.0080519653	-5.0472598815
29794538	B734	55.1205884678	-4.9953259191
34234727	Port Rodie	54.9052714766	-5.024630926
34234964	Cross	54.9045295478	-5.0291468154
34238989	Stena Terminal	54.9850149133	-5.0344597093
34237262	P & O Ferry Terminal	54.964138457	-5.0128054357
34239238	P & O Ferry Terminal	54.9660476089	-5.0152142806
34237267	Post Office	54.9710744393	-5.0198733849
34237264	Claddyburn Terr	54.9677687719	-5.0161403071
34239279	Old Pier	54.9734323573	-5.0241141043
34237279	Sandmill	54.9127903143	-4.9958721057
34237276	Innermessan	54.9218784254	-4.9900857374
34237273	Innermessan	54.9275450192	-4.9870563021
34237258	Leffnoll	54.9486337181	-5.0043033768
34237272	Burnfoot Bridge	54.9772938597	-5.0293439249
34239469	Marchburn	54.9977987407	-5.0377242417
34234673	Cairnryan Rd	54.9084287866	-5.0068295802
34234675	Cairnryan Rd	54.9068421248	-5.0117199092
34234676	Marine Gardens	54.9055233244	-5.0166767176