Doonfoot circular - Ayr - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:17:00	16:17:00	...	1
...	16:18:30	16:18:30	...	2
...	16:20:00	16:20:00	...	3
...	16:21:07	16:21:07	...	4
...	16:22:48	16:22:48	...	5
...	16:23:20	16:23:20	...	6
...	16:24:12	16:24:12	...	7
...	16:24:54	16:24:54	...	8
...	16:25:19	16:25:19	...	9
...	16:26:00	16:26:00	...	10
...	16:26:43	16:26:43	...	11
...	16:27:36	16:27:36	...	12
...	16:28:47	16:28:47	...	13
...	16:29:36	16:29:36	...	14
...	16:30:10	16:30:10	...	15
...	16:31:04	16:31:04	...	16
...	16:31:38	16:31:38	...	17
...	16:32:16	16:32:16	...	18
...	16:32:57	16:32:57	...	19
...	16:33:46	16:33:46	...	20
...	16:34:00	16:34:00	...	21
...	16:34:29	16:34:29	...	22
...	16:34:51	16:34:51	...	23
...	16:35:08	16:35:08	...	24
...	16:35:30	16:35:30	...	25
...	16:36:34	16:36:34	...	26
...	16:37:00	16:37:00	...	27
...	16:38:16	16:38:16	...	28
...	16:39:38	16:39:38	...	29
...	16:40:08	16:40:08	...	30
...	16:40:34	16:40:34	...	31
...	16:41:26	16:41:26	...	32
...	16:41:48	16:41:48	...	33
...	16:42:54	16:42:54	...	34
...	16:43:09	16:43:09	...	35
...	16:44:00	16:44:00	...	36

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

stop_code	stop_name	stop_lat	stop_lon
29723675	Earls Way	55.4328562284	-4.6533629202
29723426	Scaur o Doon Road	55.4358894967	-4.6486179949
29723925	Greenfield Avenue	55.4369506056	-4.6465230697
29723284	Cunning Park Drive	55.4375614652	-4.6457101957
29723968	Belleisle Park	55.4409759588	-4.6424443231
29723239	Belleisle Golf Club	55.4408343909	-4.6423399852
29724589	Belleisle Park Golf ground	55.4435570805	-4.6407193567
29723752	Carwinshoch View	55.4458876467	-4.6406062776
29724727	Seafield Crescent	55.4477144251	-4.6400957811
29723459	Seafield Crescent	55.4493070308	-4.6391900257
29724597	Bentfield Avenue	55.451493065	-4.6382763835
29723565	Southpark Road	55.4523439588	-4.6380010649
29723496	Blackburn Road	55.4536514837	-4.6373924346
29723528	Savoy Park	55.4558602237	-4.6362586645
29723785	Fairfield Road	55.4575181433	-4.6356574911
29723473	Killoch Place	55.4583596952	-4.6291329683
29723835	Carrick Street	55.4614826655	-4.6293725298
29723896	Town Hall	55.4642952437	-4.6315058457
29724362	Dornoch Park	55.4542161667	-4.637050523
29723782	Racecourse Road	55.4582254998	-4.6345340978
29724389	Carwinshoch View	55.4458817394	-4.6404635568
29723732	Health Board head Office	55.4480088141	-4.6397833415
29724395	Seafield Crescent	55.4492311334	-4.6393747394
29725972	Wellington Square	55.4612646089	-4.6349108717
29723487	Beagle Crescent	55.4377751807	-4.650783952
29786297	Greenan Way	55.437749865	-4.6589880603
29785758	Greenan Grove	55.4360795651	-4.6609784451
29785895	Crossburn	55.4314321544	-4.6605707651
29786572	Browncarrick Drive	55.4307061882	-4.6608854924
29786527	Cairnsmore Drive	55.4308683861	-4.6575609072
29787273	Longhill Avenue	55.4307686099	-4.6551197657
29725874	Abbots Way	55.4360857647	-4.6495165129
29726764	Cairnsmore Drive	55.4314467429	-4.6536951409
29724525	Earls Way	55.4381240087	-4.655835228
29757973	Dunure Road	55.4339026925	-4.6618753156