Dumfries - DGRI - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:04:00	07:04:00	...	1
...	07:04:00	07:04:00	...	2
...	07:07:00	07:07:00	...	3
...	07:07:00	07:07:00	...	4
...	07:08:00	07:08:00	...	5
...	07:09:00	07:09:00	...	6
...	07:10:00	07:10:00	...	7
...	07:10:00	07:10:00	...	8
...	07:12:00	07:12:00	...	9
...	07:14:00	07:14:00	...	10
...	07:14:00	07:14:00	...	11
...	07:15:00	07:15:00	...	12
...	07:15:00	07:15:00	...	13
...	07:15:00	07:15:00	...	14
...	07:16:00	07:16:00	...	15
...	07:19:00	07:19:00	...	16
...	07:19:00	07:19:00	...	17
...	07:20:00	07:20:00	...	18
...	07:21:00	07:21:00	...	19
...	07:22:00	07:22:00	...	20
...	07:28:00	07:28:00	...	21

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
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
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
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