Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	21:45:00	21:45:00	...	1
...	21:45:00	21:45:00	...	2
...	21:45:00	21:45:00	...	3
...	21:47:00	21:47:00	...	4
...	21:52:00	21:52:00	...	5
...	21:55:00	21:55:00	...	6
...	21:56:00	21:56:00	...	7
...	22:00:00	22:00:00	...	8
...	22:02:00	22:02:00	...	9
...	22:05:00	22:05:00	...	10
...	22:08:00	22:08:00	...	11
...	22:10:00	22:10:00	...	12
...	22:11:00	22:11:00	...	13
...	22:14:00	22:14:00	...	14
...	22:14:00	22:14:00	...	15
...	22:14:00	22:14:00	...	16
...	22:15:00	22:15:00	...	17

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

stop_code	stop_name	stop_lat	stop_lon
34232643	Whitesands	55.0686992366	-3.6159573982
34235989	Garroch Loaning	55.0617390254	-3.6530692943
34236243	Village	55.0361267165	-3.8282349295
34236249	Village	55.0106002783	-3.8673750758
34236387	Swimming Pool	54.9418754721	-3.9274962305
34236389	Markethill	54.9431513867	-3.92638631
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34239349	Cassalands	55.0658573262	-3.6235319247
34236259	Ernespie Road	54.9485853226	-3.9209467109
34236264	Ernespie Road	54.9468525945	-3.9230969346
34236257	Gerranton	54.9638621272	-3.9079917526
34236254	Dunjarg	54.9734514219	-3.8959779234
34236253	Chapelton Cottages	54.9822183584	-3.8835917282
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