Dumfries - DGRI - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:35:00	06:35:00	...	1
...	06:37:00	06:37:00	...	2
...	06:40:00	06:40:00	...	3
...	06:43:00	06:43:00	...	4
...	06:43:00	06:43:00	...	5
...	06:44:00	06:44:00	...	6
...	06:45:00	06:45:00	...	7
...	06:46:00	06:46:00	...	8
...	06:46:00	06:46:00	...	9
...	06:48:00	06:48:00	...	10
...	06:50:00	06:50:00	...	11
...	06:50:00	06:50:00	...	12
...	06:51:00	06:51:00	...	13
...	06:51:00	06:51:00	...	14
...	06:51:00	06:51:00	...	15
...	06:52:00	06:52:00	...	16
...	06:54:00	06:54:00	...	17
...	06:55:00	06:55:00	...	18
...	06:56:00	06:56:00	...	19
...	06:56:00	06:56:00	...	20
...	06:57:00	06:57:00	...	21
...	06:59:00	06:59:00	...	22
...	07:04:00	07:04:00	...	23
...	07:05:00	07:05: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
34234624	Great King St	55.0694241691	-3.6100822712
34234626	Loreburne Centre	55.0665163226	-3.6097775657
34236275	Burns Statue	55.070142229	-3.6128675685
34235365	Campus	55.0497979877	-3.5901030273
34235367	Bankend Rd	55.0506829852	-3.5897780645
34238946	Campus	55.0494911717	-3.5950060866
34238947	Campus	55.0503395521	-3.5919873073
34238948	Campus	55.0486410409	-3.5912937762
34238949	Campus	55.0487431374	-3.5903586296
34235364	DGRI	55.0566493824	-3.5967311392
34235368	DGRI	55.0578457463	-3.598704563
34234598	Loreburn Street	55.0707184769	-3.6100716112
34235354	St Michaels St	55.0637214716	-3.6049989239
34235353	St Michaels St	55.064666912	-3.6062268945
34232826	Buccleuch Street	55.0698551744	-3.6148607006
34235357	Nithbank	55.0618061103	-3.6037165604
34235356	Nithbank	55.0620588586	-3.603632718
34238735	Whitesands	55.0654145789	-3.6094984317
34235359	Johnstone Park	55.0603542002	-3.6020457375
34235358	Johnstone Park	55.0607371538	-3.6023115647
34235363	Picket Cross	55.0596415104	-3.6002009896
34235362	Picket Cross	55.0596627671	-3.5999513168