Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:23:00	08:23:00	...	1
...	08:23:00	08:23:00	...	2
...	08:23:00	08:23:00	...	3
...	08:24:00	08:24:00	...	4
...	08:24:00	08:24:00	...	5
...	08:24:00	08:24:00	...	6
...	08:25:00	08:25:00	...	7
...	08:25:00	08:25:00	...	8
...	08:25:00	08:25:00	...	9
...	08:25:00	08:25:00	...	10
...	08:25:00	08:25:00	...	11
...	08:26:00	08:26:00	...	12
...	08:26:00	08:26:00	...	13
...	08:27:00	08:27:00	...	14
...	08:27:00	08:27:00	...	15
...	08:28:00	08:28:00	...	16
...	08:29:00	08:29:00	...	17
...	08:31:00	08:31:00	...	18

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
29723847	Elder Avenue	55.2325915174	-4.8538806512
29723648	Henrietta Street	55.2434150401	-4.8588733815
29723597	Hervey Road	55.237841252	-4.8550435333
29723486	Inglis Way	55.2368187796	-4.8468683485
29723653	Todd Street	55.235198658	-4.8496470479
29723984	Piedmont Road	55.2342605196	-4.8497844137
29724263	Fauldribbon Road	55.2369881112	-4.852701239
29724565	Arran Court	55.2357696257	-4.8479102651
29723683	Gregg Place	55.2368068983	-4.8454516407
29723598	Urnfield	55.2357812045	-4.8462593007
29723574	Duncan Street	55.239745126	-4.8555104529
29724373	Sacred Heart Primary	55.241497053	-4.8586255094
29724574	Piedmount Road	55.2358510581	-4.852887212
29725742	Chestnut Drive	55.2344400929	-4.8517164279
29764865	Hawthorn Drive	55.2297015772	-4.8525253534
29764875	Willow Drive	55.2314086958	-4.851027471
29764929	Rowan Road	55.2326361016	-4.8496681696
29764938	Coalpots Road	55.2339579126	-4.8504234455