Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:15:00	14:15:00	...	1
...	14:16:00	14:16:00	...	2
...	14:18:00	14:18:00	...	3
...	14:23:00	14:23:00	...	4
...	14:23:00	14:23:00	...	5
...	14:24:00	14:24:00	...	6
...	14:29:00	14:29:00	...	7
...	14:35:00	14:35:00	...	9
...	14:38:00	14:38:00	...	10
...	14:38:00	14:38:00	...	11
...	14:42:00	14:42:00	...	12
...	14:44:00	14:44:00	...	13
...	14:47:00	14:47:00	...	14
...	14:57:00	14:57:00	...	15
...	14:58:00	14:58:00	...	16
...	14:59:00	14:59:00	...	17
...	15:00:00	15:00:00	...	18
...	15:02:00	15:02:00	...	19

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
20/08/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34232643	Whitesands	55.0686992366	-3.6159573982
34234626	Loreburne Centre	55.0665163226	-3.6097775657
34238492	Railway Station	55.0722541413	-3.6047140725
34234635	English Street	55.0696047174	-3.6059392352
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34239257	Garroch Business Park	55.0587358208	-3.6478725216
34236243	Village	55.0361267165	-3.8282349295
34236249	Village	55.0106002783	-3.8673750758
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
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34239239	Ettrick Court	55.0649760072	-3.6249212691
34236247	Lochview Motel	55.0235739771	-3.8458887715
34236239	Brae	55.0493572249	-3.7821416575
34236237	Road End	55.0514292038	-3.7670172207
34236235	Road End	55.055640759	-3.7202179695