Dumfries - Annan Newington - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:30:00	08:30:00	...	1
...	08:30:00	08:30:00	...	2
...	08:31:00	08:31:00	...	3
...	08:40:00	08:40:00	...	4
...	08:42:00	08:42:00	...	5
...	08:45:00	08:45:00	...	6
...	08:47:00	08:47:00	...	7
...	08:48:00	08:48:00	...	8
...	08:50:00	08:50:00	...	9
...	08:53:00	08:53:00	...	10
...	08:57:00	08:57:00	...	11
...	08:57:00	08:57:00	...	12
...	08:57:00	08:57:00	...	13
...	08:58:00	08:58:00	...	14
...	08:58:00	08:58:00	...	15
...	08:58:00	08:58:00	...	16
...	08:59:00	08:59:00	...	17
...	08:59:00	08:59:00	...	18
...	08:59:00	08:59:00	...	19
...	09:00:00	09:00:00	...	20
...	09:02:00	09:02:00	...	21
...	09:04:00	09:04:00	...	22
...	09:05:00	09:05:00	...	23
...	09:06:00	09:06:00	...	24
...	09:08:00	09:08:00	...	25
...	09:15:00	09:15:00	...	26

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
27/08/2012 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34234632	Leafield Road	55.0688182599	-3.6035585572
34235345	Annan Road	55.0696781557	-3.5880098028
34237625	Moreig Hotel	55.070314428	-3.5957092406
34237623	Annan Road	55.0702786318	-3.5991220659
34235347	Annan Road	55.0702019024	-3.592635076
34235364	DGRI	55.0566493824	-3.5967311392
34237675	Stance 3	54.9877461675	-3.2598275613
34237626	Bypass	55.0665734965	-3.5243536211
34235323	Annan Road	55.0689343251	-3.5670414182
34237374	House	55.0085073133	-3.3363330463
34235353	St Michaels St	55.064666912	-3.6062268945
34237646	War Memorial	54.9872225579	-3.2626555526
34235324	Annan Road	55.069015704	-3.5704900479
34237643	North Howes	54.9913064567	-3.2743501136
34237639	Stenriesgate	55.0221352955	-3.3731236211
34237636	Hetland Hall	55.0343814176	-3.4203745584
34237635	Byeloch	55.04316977	-3.4463997312
34237632	Cleuchbrae	55.0520420853	-3.4635166018
34237628	Mouswald Banks	55.0588155487	-3.4763988946
34235343	Annan Road	55.0693106612	-3.5851762124
34235326	Annan Road	55.0686235517	-3.5757994212
34235328	Annan Road	55.0686722943	-3.580358694
34235356	Nithbank	55.0620588586	-3.603632718
34238932	D and G College	55.0475488501	-3.58545892
34235358	Johnstone Park	55.0607371538	-3.6023115647
34235362	Picket Cross	55.0596627671	-3.5999513168