Dalmellington - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:20:00	12:20:00	...	1
...	12:22:00	12:22:00	...	2
...	12:22:00	12:22:00	...	3
...	12:22:00	12:22:00	...	4
...	12:22:00	12:22:00	...	5
...	12:23:00	12:23:00	...	6
...	12:25:00	12:25:00	...	7
...	12:27:00	12:27:00	...	8
...	12:29:00	12:29:00	...	9
...	12:30:00	12:30:00	...	10
...	12:30:00	12:30:00	...	11
...	12:30:00	12:30:00	...	12
...	12:32:00	12:32:00	...	13
...	12:35:00	12:35:00	...	14
...	12:38:00	12:38:00	...	15
...	12:42:00	12:42:00	...	16
...	12:43:00	12:43:00	...	17
...	12:44:00	12:44:00	...	18
...	12:47:00	12:47:00	...	19
...	12:48:00	12:48:00	...	20
...	12:48:00	12:48:00	...	21
...	12:51:00	12:51:00	...	22
...	12:54:00	12:54:00	...	23
...	12:55:00	12:55:00	...	24
...	12:56:00	12:56:00	...	25
...	12:57:00	12:57:00	...	26
...	12:58:00	12:58:00	...	27
...	12:59:00	12:59:00	...	28
...	12:59:00	12:59:00	...	29
...	13:00:00	13:00:00	...	30

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
34239343	Medical centre	54.9498571466	-3.9223659595
34236263	Ernespie Road	54.9484257364	-3.9213763226
34236262	Ernespie Road	54.9468037381	-3.9233444344
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
34238978	Underhill	55.1067473874	-4.1600050471
34238976	Underhill	55.1068316264	-4.160323148