Dumfries - Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:51:00	07:51:00	...	1
...	07:53:00	07:53:00	...	2
...	07:53:00	07:53:00	...	3
...	07:59:00	07:59:00	...	4
...	08:00:00	08:00:00	...	5
...	08:01:00	08:01:00	...	6
...	08:04:00	08:04:00	...	7
...	08:08:00	08:08:00	...	8
...	08:08:00	08:08:00	...	9
...	08:09:00	08:09:00	...	10
...	08:11:00	08:11:00	...	11
...	08:12:00	08:12:00	...	12
...	08:14:00	08:14:00	...	13
...	08:18:00	08:18:00	...	14
...	08:20:00	08:20:00	...	15
...	08:23:00	08:23:00	...	16
...	08:26:00	08:26:00	...	17
...	08:27:00	08:27:00	...	18
...	08:29:00	08:29:00	...	19
...	08:35:00	08:35:00	...	21
...	08:39:00	08:39:00	...	22
...	08:39:00	08:39:00	...	23
...	08:40:00	08:40:00	...	24
...	08:41:00	08:41:00	...	25
...	08:42:00	08:42:00	...	26
...	08:45:00	08:45:00	...	27

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
09/07/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
34236485	Shelter	54.9196833119	-3.9784278772
34236493	Tarff Bridge	54.881727661	-4.054671285
34236495	Tarff Station	54.8842416213	-4.0532401916
34239256	Garroch Business Park	55.058946228	-3.6475993342
34236245	Village	55.0362139469	-3.8284110426
34236248	Village	55.0107770262	-3.8675709629
34236576	Village	54.86684677	-4.0818875669
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
34236476	Road End	54.9269558596	-3.9578247059
34238678	Hightae Farm	54.9296771486	-3.9473278731
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