Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:40:00	07:40:00	...	1
...	07:45:00	07:45:00	...	2
...	07:45:00	07:45:00	...	3
...	07:46:00	07:46:00	...	4
...	07:48:00	07:48:00	...	5
...	07:49:00	07:49:00	...	6
...	07:51:00	07:51:00	...	7
...	07:55:00	07:55:00	...	8
...	07:57:00	07:57:00	...	9
...	08:00:00	08:00:00	...	10
...	08:04:00	08:04:00	...	11
...	08:06:00	08:06:00	...	12
...	08:07:00	08:07:00	...	13
...	08:12:00	08:12:00	...	15
...	08:16:00	08:16:00	...	16
...	08:16:00	08:16:00	...	17
...	08:17:00	08:17:00	...	18
...	08:18:00	08:18:00	...	19
...	08:20:00	08:20:00	...	20
...	08:24:00	08:24: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