Dumfries - Sandyhills - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:40:00	07:40:00	...	1
...	07:40:00	07:40:00	...	2
...	07:40:00	07:40:00	...	3
...	07:41:00	07:41:00	...	4
...	07:41:00	07:41:00	...	5
...	07:43:00	07:43:00	...	6
...	07:44:00	07:44:00	...	7
...	07:47:00	07:47:00	...	8
...	07:49:00	07:49:00	...	9
...	07:52:00	07:52:00	...	10
...	07:54:00	07:54:00	...	11
...	07:55:00	07:55:00	...	12
...	08:01:00	08:01:00	...	13
...	08:05:00	08:05:00	...	14
...	08:08:00	08:08:00	...	15
...	08:11:00	08:11:00	...	16
...	08:15:00	08:15:00	...	17
...	08:18:00	08:18:00	...	18
...	08:19:00	08:19:00	...	19
...	08:22:00	08:22:00	...	20
...	08:23:00	08:23:00	...	21
...	08:24:00	08:24:00	...	22
...	08:26:00	08:26:00	...	23
...	08:29:00	08:29:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
34232643	Whitesands	55.0686992366	-3.6159573982
34235749	Post Office	54.979968885	-3.6219070819
34235754	Kindar Drive	54.9775478341	-3.6160904811
34235758	Village	54.9165188469	-3.5960129932
34235759	Village	54.9165923479	-3.5958910875
34235762	Village	54.9228261477	-3.5720292359
34235768	Holiday Village	54.8752090523	-3.5996789528
34238463	Southwick	54.8978358004	-3.6726862603
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34235729	New Abbey Rd	55.0653557617	-3.622728622
34235693	New Abbey Rd	55.0606386915	-3.6212850906
34235689	New Abbey Rd	55.0595246576	-3.6212557082
34235736	Cargenholm	55.0445303572	-3.6161107983
34238673	Village	55.0381124738	-3.6195612111
34235743	Mabie Forest	55.0197542644	-3.6327891652
34235746	Whinnyhill	55.0081419602	-3.6241075131
34235757	Drumburn	54.9425469588	-3.5939218173
34235786	Road End	54.9052044656	-3.6109288212
34235784	Prestonmill	54.9034422725	-3.615038407
34235782	Torrorie Farm	54.8982503159	-3.6256066279
34235765	Loaningfoot	54.8856278486	-3.6164769306
34235767	Loaningfoot	54.8856113348	-3.6163671392
34238459	Mainsriddle	54.8943959435	-3.6422142877
34235747	Shambellie	54.9892253313	-3.6226243208