Dalmellington - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:40:00	14:40:00	...	1
...	14:41:00	14:41:00	...	2
...	14:41:00	14:41:00	...	3
...	14:44:00	14:44:00	...	4
...	14:45:00	14:45:00	...	5
...	14:45:00	14:45:00	...	6
...	14:46:00	14:46:00	...	7
...	14:47:00	14:47:00	...	8
...	14:47:00	14:47:00	...	9
...	14:47:00	14:47:00	...	10
...	14:49:00	14:49:00	...	11
...	14:50:00	14:50:00	...	12
...	14:55:00	14:55:00	...	13
...	14:59:00	14:59:00	...	14
...	15:00:00	15:00:00	...	15
...	15:00:00	15:00:00	...	16
...	15:07:00	15:07:00	...	17
...	15:10:00	15:10:00	...	18
...	15:15:00	15:15:00	...	19
...	15:18:00	15:18:00	...	20
...	15:22:00	15:22:00	...	21
...	15:24:00	15:24:00	...	22
...	15:27:00	15:27:00	...	23
...	15:28:00	15:28:00	...	24
...	15:29:00	15:29:00	...	25
...	15:29:00	15:29:00	...	26
...	15:29:00	15:29:00	...	27
...	15:34:00	15:34:00	...	28
...	15:35:00	15:35:00	...	29
...	15:35:00	15:35:00	...	30
...	15:35:00	15:35:00	...	31
...	15:36:00	15:36:00	...	32
...	15:38:00	15:38:00	...	33
...	15:42:00	15:42:00	...	34
...	15:42:00	15:42:00	...	35
...	15:44:00	15:44:00	...	36
...	15:49:00	15:49:00	...	37
...	15:50:00	15:50:00	...	38

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
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34239328	Carlingwark Street	54.9382167851	-3.9331909813
34235938	Wayside	54.9631763241	-3.9673657601
34235878	Clachan	55.1056922734	-4.1652627133
34235863	Village	55.2122568681	-4.2622348949
34235934	Main Street	54.9799534868	-3.9847204018
34235936	South	54.9786480265	-3.9832026567
34235932	Church	54.9812559634	-3.9875196074
34235924	Village	55.0077722986	-4.0411421554
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
34235953	Town Hall	54.9392844985	-3.9327426531
34236387	Swimming Pool	54.9418754721	-3.9274962305
34235952	Royal Bank	54.9402587048	-3.9302602492
34236389	Markethill	54.9431513867	-3.92638631
34236392	Library	54.9421040326	-3.9278194243
34235897	Little Drumrash	55.0253446005	-4.0729979671
34239343	Medical centre	54.9498571466	-3.9223659595
34236259	Ernespie Road	54.9485853226	-3.9209467109
34236264	Ernespie Road	54.9468525945	-3.9230969346
34235946	Abercromby Road	54.9445731825	-3.93758691
34235943	Midpark	54.9503800186	-3.9465488562
34235928	Mill	54.9982937472	-4.006342134
34235926	House	55.0031573612	-4.0203922264
34235895	Sailing Centre	55.0454373182	-4.1020871331
34235879	Ken Bridge	55.08026624	-4.1300156518
34235894	Craigend	55.0602281508	-4.1204322914
34235845	Post Office	55.1060220795	-4.1639009401
34238978	Underhill	55.1067473874	-4.1600050471
34238976	Underhill	55.1068316264	-4.160323148
34235847	Allangibbon Br	55.1133507996	-4.1717924396
34235848	Polharrow Br	55.1329823103	-4.1917941068
34235852	Kendoon	55.1623782034	-4.1955420983
34235856	Village	55.1652857848	-4.1997841564
34235857	Polquhanity	55.181656009	-4.2125453342
34235862	Liggat	55.211983761	-4.2541710431