Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:16:00	17:16:00	...	1
...	17:26:00	17:26:00	...	2
...	17:30:00	17:30:00	...	3
...	17:33:00	17:33:00	...	4
...	17:36:00	17:36:00	...	5
...	17:41:00	17:41:00	...	6
...	17:42:00	17:42:00	...	7
...	17:47:00	17:47:00	...	8
...	17:51:00	17:51:00	...	9
...	17:52:00	17:52:00	...	10
...	17:55:00	17:55:00	...	11
...	17:56:00	17:56:00	...	12
...	17:56:00	17:56:00	...	13
...	17:57:00	17:57:00	...	14
...	17:57:00	17:57:00	...	15
...	17:58:00	17:58:00	...	16
...	17:59:00	17:59:00	...	17
...	18:02:00	18:02:00	...	18
...	18:05:00	18:05:00	...	19
...	18:06:00	18:06:00	...	20
...	18:08:00	18:08:00	...	21
...	18:09:00	18:09:00	...	22
...	18:09:00	18:09:00	...	23
...	18:10:00	18:10:00	...	24
...	18:11:00	18:11:00	...	25
...	18:14:00	18:14: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