Dumfries - Cargenbridge - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:24:00	07:24:00	...	1
...	07:24:00	07:24:00	...	2
...	07:24:00	07:24:00	...	3
...	07:24:00	07:24:00	...	4
...	07:24:00	07:24:00	...	5
...	07:26:00	07:26:00	...	6
...	07:28:00	07:28:00	...	7
...	07:29:00	07:29:00	...	8
...	07:29:00	07:29:00	...	9
...	07:30:00	07:30:00	...	10
...	07:32:00	07:32:00	...	11
...	07:33:00	07:33:00	...	12
...	07:36:00	07:36:00	...	13
...	07:37:00	07:37:00	...	14
...	07:37:00	07:37:00	...	15
...	07:38:00	07:38:00	...	16
...	07:39:00	07:39:00	...	17
...	07:39:00	07:39:00	...	18
...	07:40:00	07:40:00	...	19
...	07:43:00	07:43:00	...	20
...	07:43:00	07:43:00	...	21
...	07:43:00	07:43:00	...	22
...	07:44:00	07:44:00	...	23
...	07:45:00	07:45:00	...	24

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
08/07/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34236275	Burns Statue	55.070142229	-3.6128675685
34235656	Troqueer Rd	55.0613193815	-3.6092714214
34235657	Troqueer Rd	55.0616353019	-3.6098478009
34235658	East Riverside Dr	55.0585122207	-3.6047434633
34235659	Moat Road	55.0586041786	-3.6093503491
34235672	Hill Avenue	55.0576286386	-3.6110804189
34235673	Holm Ave	55.059207976	-3.6119423951
34235674	Holm Ave	55.0603949677	-3.6105339268
34235675	Troqueer Rd	55.0623076208	-3.6106577241
34235679	Troqueer Primary	55.0611323385	-3.6172808965
34235684	Balliol Avenue	55.0599475917	-3.6191903299
34235685	Shelter	55.0598672203	-3.6205023307
34235695	Cargenbridge Ave	55.055245298	-3.6408091761
34235696	Cargenbridge Ave	55.0545486147	-3.6424871437
34235697	Drungans Drive	55.0529482734	-3.6425311972
34235698	Cargen Road	55.0527281208	-3.6408627562
34235986	DuPont	55.0550275385	-3.6429607763
34235732	Rotchell Road	55.0629432041	-3.6210024577
34232826	Buccleuch Street	55.0698551744	-3.6148607006
34235678	Pleasance Avenue	55.062751985	-3.6130713695
34236274	Maxweltown West Church	55.0678624437	-3.6207628578
34236278	Laurieknowe	55.0664324035	-3.6228661612
34235987	Ettrick Court	55.0648627851	-3.6253238315
34235692	New Abbey Rd	55.0606541549	-3.6214736118