Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:00:00	08:00:00	...	1
...	08:02:00	08:02:00	...	2
...	08:02:00	08:02:00	...	3
...	08:02:00	08:02:00	...	4
...	08:02:00	08:02:00	...	5
...	08:05:00	08:05:00	...	6
...	08:06:00	08:06:00	...	7
...	08:08:00	08:08:00	...	8
...	08:13:00	08:13:00	...	9
...	08:15:00	08:15:00	...	10
...	08:25:00	08:25:00	...	11
...	08:26:00	08:26:00	...	12
...	08:30:00	08:30:00	...	13
...	08:30:00	08:30:00	...	14
...	08:34:00	08:34:00	...	15
...	08:39:00	08:39:00	...	16
...	08:42:00	08:42:00	...	17
...	08:51:00	08:51:00	...	18
...	08:52:00	08:52:00	...	19
...	08:53:00	08:53:00	...	20
...	08:54:00	08:54:00	...	21
...	08:54:00	08:54:00	...	22
...	08:55:00	08:55:00	...	23
...	08:57:00	08:57:00	...	24
...	08:58:00	08:58:00	...	25
...	09:00:00	09:00:00	...	26

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
03/04/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34232643	Whitesands	55.0686992366	-3.6159573982
34234626	Loreburne Centre	55.0665163226	-3.6097775657
34236282	DuPont	55.0540499435	-3.6441418597
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34236234	Village Hall	55.0457015356	-3.7233292467
34236249	Village	55.0106002783	-3.8673750758
34238494	Village	55.0115272688	-3.8974931034
34238496	Village	54.9893596347	-3.9126404637
34238629	Village	54.9734911229	-3.927745193
34238535	Dunmuir Road	54.9489209674	-3.9281301879
34235952	Royal Bank	54.9402587048	-3.9302602492
34236389	Markethill	54.9431513867	-3.92638631
34235974	Auchengibbert	55.023833222	-3.828723304
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34239239	Ettrick Court	55.0649760072	-3.6249212691
34239349	Cassalands	55.0658573262	-3.6235319247
34239343	Medical centre	54.9498571466	-3.9223659595
34236259	Ernespie Road	54.9485853226	-3.9209467109
34236263	Ernespie Road	54.9484257364	-3.9213763226
34236262	Ernespie Road	54.9468037381	-3.9233444344
34236264	Ernespie Road	54.9468525945	-3.9230969346
34236247	Lochview Motel	55.0235739771	-3.8458887715
34235985	Drumsleet	55.0517225445	-3.6514197735
34235982	Tregallon	55.0517056573	-3.6756680875
34235978	Northpark	55.0486094221	-3.7127940828
34238746	Primary	55.0101379655	-3.8693866569