Stranraer Academy - Drummore - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:10:00	08:10:00	...	1
...	08:10:00	08:10:00	...	2
...	08:12:00	08:12:00	...	3
...	08:16:00	08:16:00	...	4
...	08:21:00	08:21:00	...	5
...	08:24:00	08:24:00	...	6
...	08:25:00	08:25:00	...	7
...	08:26:00	08:26:00	...	8
...	08:30:00	08:30:00	...	9
...	08:32:00	08:32:00	...	10
...	08:34:00	08:34:00	...	11
...	08:35:00	08:35:00	...	12
...	08:38:00	08:38:00	...	13
...	08:41:00	08:41:00	...	14
...	08:44:00	08:44:00	...	15
...	08:49:00	08:49:00	...	16
...	08:50:00	08:50:00	...	17

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

stop_code	stop_name	stop_lat	stop_lon
34238573	Academy	54.9056565763	-5.0025972304
34234897	County Hotel	54.8354768654	-4.9799828557
34234937	Bayview	54.7693551848	-4.9411869868
34234963	Village	54.6894417024	-4.8951739699
34239359	Stair Street	54.6923852865	-4.8976496757
34239246	Bridge of Aird	54.9042779874	-4.9998109365
34234846	Whiteleys Farm	54.8793124744	-5.0157302435
34234893	Bridgebank	54.8662882053	-4.9989200648
34234895	Outer Blair	54.8535667765	-4.9927239906
34234925	North Milmain	54.8327364213	-4.9758871547
34234927	Sandmill Farm	54.8191252225	-4.9585999444
34239358	Kirkmadrine	54.7969277541	-4.9611784791
34234935	Drumantrae	54.7785405524	-4.9427872002
34234939	Chapel Rossan	54.7648981074	-4.9410966959
34234945	Balkelzie Bridge	54.7505574641	-4.941501789
34234957	Terally	54.7247722521	-4.9117510179
34234959	Curghie	54.6997848992	-4.9047593279