Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:03:00	15:03:00	...	1
...	15:08:00	15:08:00	...	2
...	15:08:00	15:08:00	...	3
...	15:09:00	15:09:00	...	4
...	15:11:00	15:11:00	...	5
...	15:12:00	15:12:00	...	6
...	15:14:00	15:14:00	...	7
...	15:18:00	15:18:00	...	8
...	15:20:00	15:20:00	...	9
...	15:23:00	15:23:00	...	10
...	15:27:00	15:27:00	...	11
...	15:29:00	15:29:00	...	12
...	15:30:00	15:30:00	...	13
...	15:35:00	15:35:00	...	15
...	15:39:00	15:39:00	...	16
...	15:39:00	15:39:00	...	17
...	15:40:00	15:40:00	...	18
...	15:41:00	15:41:00	...	19
...	15:43:00	15:43:00	...	20
...	15:47:00	15:47:00	...	21

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
34238492	Railway Station	55.0722541413	-3.6047140725
34239328	Carlingwark Street	54.9382167851	-3.9331909813
34239256	Garroch Business Park	55.058946228	-3.6475993342
34236245	Village	55.0362139469	-3.8284110426
34236248	Village	55.0107770262	-3.8675709629
34232827	Academy Street	55.0719004393	-3.6104010107
34236387	Swimming Pool	54.9418754721	-3.9274962305
34232826	Buccleuch Street	55.0698551744	-3.6148607006
34236274	Maxweltown West Church	55.0678624437	-3.6207628578
34236278	Laurieknowe	55.0664324035	-3.6228661612
34235987	Ettrick Court	55.0648627851	-3.6253238315
34236263	Ernespie Road	54.9484257364	-3.9213763226
34236262	Ernespie Road	54.9468037381	-3.9233444344
34236258	Gerranton	54.9639293214	-3.9082917406
34236256	Dunjarg	54.9735288442	-3.8962003204
34236252	Chapelton Cottages	54.9822239525	-3.8838107849
34236246	Lochview Motel	55.0236337634	-3.8460948945
34236242	Brae	55.0493980096	-3.7824252424
34236238	Road End	55.0516439615	-3.7664631053
34236236	Road End	55.0558030987	-3.7201779633