Dumfries - Sandyhills - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:45:00	06:45:00	...	1
...	06:47:00	06:47:00	...	2
...	06:50:00	06:50:00	...	3
...	06:50:00	06:50:00	...	4
...	06:50:00	06:50:00	...	5
...	06:51:00	06:51:00	...	6
...	06:51:00	06:51:00	...	7
...	06:53:00	06:53:00	...	8
...	06:54:00	06:54:00	...	9
...	06:57:00	06:57:00	...	10
...	06:59:00	06:59:00	...	11
...	07:02:00	07:02:00	...	12
...	07:04:00	07:04:00	...	13
...	07:05:00	07:05:00	...	14
...	07:11:00	07:11:00	...	15
...	07:17:00	07:17:00	...	16
...	07:18:00	07:18:00	...	17
...	07:19:00	07:19:00	...	18
...	07:21:00	07:21:00	...	19
...	07:24:00	07:24:00	...	20
...	07:24:00	07:24:00	...	21
...	07:28:00	07:28:00	...	22
...	07:30:00	07:30:00	...	23

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
34234626	Loreburne Centre	55.0665163226	-3.6097775657
34238624	DG One A	55.0692832052	-3.6057854031
34235749	Post Office	54.979968885	-3.6219070819
34235754	Kindar Drive	54.9775478341	-3.6160904811
34238463	Southwick	54.8978358004	-3.6726862603
34238293	Village	54.8800304901	-3.7311051792
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
34238459	Mainsriddle	54.8943959435	-3.6422142877
34238465	Southwick	54.8966757313	-3.6766459333
34238295	Laggan	54.8815920462	-3.7167057949
34235747	Shambellie	54.9892253313	-3.6226243208