Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:10:00	16:10:00	...	1
...	16:11:00	16:11:00	...	2
...	16:15:00	16:15:00	...	3
...	16:15:00	16:15:00	...	4
...	16:16:00	16:16:00	...	5
...	16:17:00	16:17:00	...	6
...	16:19:00	16:19:00	...	7
...	16:20:00	16:20:00	...	8
...	16:23:00	16:23:00	...	9
...	16:26:00	16:26:00	...	10
...	16:27:00	16:27:00	...	11
...	16:28:00	16:28:00	...	12
...	16:28:00	16:28:00	...	13
...	16:29:00	16:29:00	...	14
...	16:29:00	16:29:00	...	15
...	16:31:00	16:31:00	...	16
...	16:33:00	16:33:00	...	17
...	16:34:00	16:34:00	...	18
...	16:38:00	16:38:00	...	19
...	16:43:00	16:43:00	...	20
...	16:45:00	16:45:00	...	21
...	16:50:00	16:50:00	...	22
...	16:52:00	16:52:00	...	23
...	16:55:00	16:55:00	...	24
...	17:00:00	17:00:00	...	25
...	17:10:00	17:10: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
29767839	Kilantringan Loch	55.0684422833	-4.9859273278
29723847	Elder Avenue	55.2325915174	-4.8538806512
29723498	Smyrton Hill	55.0816234526	-4.9774289016
29723848	Kings Arms Hotel	55.1007316065	-5.0047049272
29725424	Youth Centre	55.168680266	-4.935734915
29724957	Bennane Head Access Path	55.1441718452	-4.9831557753
29797379	Glenapp Church	55.028734583	-5.0146175568
29768264	Finnarts Bay	55.0080893958	-5.0475599379
29756563	B734	55.1206197396	-4.9955165021
34234728	Market Street	54.9059048595	-5.0291565506
34234964	Cross	54.9045295478	-5.0291468154
34234967	Port Rodie Ferry Terminal	54.9056554799	-5.0225689367
34238989	Stena Terminal	54.9850149133	-5.0344597093
34237263	P & O Ferry Terminal	54.9636491534	-5.0125969042
34239238	P & O Ferry Terminal	54.9660476089	-5.0152142806
34237268	Post Office	54.9709730146	-5.0199751663
34237265	Claddyburn Terr	54.9676740008	-5.016336351
34239282	Old Pier	54.9733473234	-5.0242796309
34237278	Sandmill	54.9128508261	-4.9959702383
34237275	Innermessan	54.921918308	-4.9902916166
34237274	Innermessan	54.9276672061	-4.9872058664
34237259	Leffnoll	54.9488249734	-5.004567569
34237269	Burnfoot Bridge	54.9772634383	-5.0294823101
34239468	Marchburn	54.9978377565	-5.0379617756
34234674	Cairnryan Rd	54.9072749198	-5.0105819795
34234678	Marine Gardens	54.9055058366	-5.0170186732