Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:05:00	08:05:00	...	2
...	08:05:00	08:05:00	...	3
...	08:08:00	08:08:00	...	4
...	08:15:00	08:15:00	...	5
...	08:16:00	08:16:00	...	6
...	08:19:00	08:19:00	...	7
...	08:21:00	08:21:00	...	8
...	08:25:00	08:25:00	...	9
...	08:27:00	08:27:00	...	10
...	08:30:00	08:30:00	...	11
...	08:37:00	08:37:00	...	12
...	08:40:00	08:40:00	...	13
...	08:43:00	08:43:00	...	14
...	08:48:00	08:48:00	...	15
...	08:48:00	08:48:00	...	16
...	08:49:00	08:49:00	...	17
...	08:50:00	08:50:00	...	18

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
34236234	Village Hall	55.0457015356	-3.7233292467
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