Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:48:00	07:48:00	...	1
...	07:58:00	07:58:00	...	2
...	08:02:00	08:02:00	...	3
...	08:05:00	08:05:00	...	4
...	08:08:00	08:08:00	...	5
...	08:12:00	08:12:00	...	6
...	08:13:00	08:13:00	...	7
...	08:18:00	08:18:00	...	8
...	08:22:00	08:22:00	...	9
...	08:23:00	08:23:00	...	10
...	08:26:00	08:26:00	...	11
...	08:27:00	08:27:00	...	12
...	08:27:00	08:27:00	...	13
...	08:28:00	08:28:00	...	14
...	08:28:00	08:28:00	...	15
...	08:29:00	08:29:00	...	16
...	08:30:00	08:30:00	...	17
...	08:33:00	08:33:00	...	18
...	08:37:00	08:37:00	...	19
...	08:38:00	08:38:00	...	20
...	08:39:00	08:39:00	...	21
...	08:41:00	08:41:00	...	22
...	08:41:00	08:41:00	...	23
...	08:42:00	08:42:00	...	24
...	08:43:00	08:43:00	...	25

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
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