Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:18:00	17:18:00	...	1
...	17:23:00	17:23:00	...	2
...	17:23:00	17:23:00	...	3
...	17:24:00	17:24:00	...	4
...	17:26:00	17:26:00	...	5
...	17:27:00	17:27:00	...	6
...	17:29:00	17:29:00	...	7
...	17:33:00	17:33:00	...	8
...	17:35:00	17:35:00	...	9
...	17:38:00	17:38:00	...	10
...	17:42:00	17:42:00	...	11
...	17:44:00	17:44:00	...	12
...	17:45:00	17:45:00	...	13
...	17:50:00	17:50:00	...	15
...	17:54:00	17:54:00	...	16
...	17:54:00	17:54:00	...	17
...	17:55:00	17:55:00	...	18
...	17:56:00	17:56:00	...	19
...	17:58:00	17:58:00	...	20
...	18:02:00	18:02: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