Dalmellington - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:22:00	16:22:00	...	1
...	16:22:00	16:22:00	...	2
...	16:22:00	16:22:00	...	3
...	16:22:00	16:22:00	...	4
...	16:25:00	16:25:00	...	5
...	16:29:00	16:29:00	...	6
...	16:31:00	16:31:00	...	7
...	16:33:00	16:33:00	...	8
...	16:34:00	16:34:00	...	9
...	16:34:00	16:34:00	...	10
...	16:34:00	16:34:00	...	11
...	16:37:00	16:37:00	...	12
...	16:40:00	16:40:00	...	13
...	16:44:00	16:44:00	...	14
...	16:49:00	16:49:00	...	15
...	16:50:00	16:50:00	...	16
...	16:51:00	16:51:00	...	17
...	16:54:00	16:54:00	...	18
...	16:55:00	16:55:00	...	19
...	16:55:00	16:55:00	...	20
...	16:58:00	16:58:00	...	21
...	17:01:00	17:01:00	...	22
...	17:02:00	17:02:00	...	23
...	17:03:00	17:03:00	...	24
...	17:04:00	17:04:00	...	25
...	17:05:00	17:05:00	...	26

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

stop_code	stop_name	stop_lat	stop_lon
34239328	Carlingwark Street	54.9382167851	-3.9331909813
34235939	Wayside	54.9632509501	-3.9671975766
34235876	Clachan	55.1057789377	-4.1649381772
34235935	Main Street	54.9800101754	-3.9845512953
34235937	South	54.9786954775	-3.9830487252
34235929	Church	54.9812503009	-3.9873161617
34235923	Village	55.0078647253	-4.0409904646
34235789	Post Office	55.0736566969	-4.1409585546
34235837	Braeside	55.0758602462	-4.1398543745
34238979	East Port	55.0738542795	-4.1394339638
34238982	Town Hall	55.0731560321	-4.1408064911
34235962	Shop	55.0879213906	-4.1131541723
34236387	Swimming Pool	54.9418754721	-3.9274962305
34235898	Little Drumrash	55.0254594787	-4.0731134182
34235945	Abercromby Road	54.9446115943	-3.9374326205
34236385	Jubille Terrace	54.9386806642	-3.9345402181
34235942	Midpark	54.9504548657	-3.9463650822
34235927	Mill	54.9983758617	-4.0062680591
34235925	House	55.0033536357	-4.0204802798
34235896	Sailing Centre	55.04545798	-4.1019316804
34235879	Ken Bridge	55.08026624	-4.1300156518
34235893	Craigend	55.0603018981	-4.1203265759
34235957	Trolane	55.1065247257	-4.127211248
34235845	Post Office	55.1060220795	-4.1639009401
34235843	Bank House	55.1059677872	-4.1649327145
34238976	Underhill	55.1068316264	-4.160323148