Stranraer - Drummore - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:55:00	08:55:00	...	1
...	08:56:00	08:56:00	...	2
...	08:57:00	08:57:00	...	3
...	08:58:00	08:58:00	...	4
...	08:59:00	08:59:00	...	5
...	08:59:00	08:59:00	...	6
...	08:59:00	08:59:00	...	7
...	09:00:00	09:00:00	...	8
...	09:02:00	09:02:00	...	9
...	09:05:00	09:05:00	...	10
...	09:05:00	09:05:00	...	11
...	09:06:00	09:06:00	...	12
...	09:10:00	09:10:00	...	13
...	09:11:00	09:11:00	...	14
...	09:16:00	09:16:00	...	15
...	09:20:00	09:20:00	...	16
...	09:22:00	09:22:00	...	17
...	09:22:00	09:22:00	...	18
...	09:24:00	09:24:00	...	19
...	09:26:00	09:26:00	...	20
...	09:29:00	09:29:00	...	21
...	09:31:00	09:31:00	...	22
...	09:32:00	09:32:00	...	23
...	09:33:00	09:33:00	...	24
...	09:37:00	09:37:00	...	25
...	09:39:00	09:39:00	...	26

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
34234965	Port Rodie	54.905491064	-5.0241169027
34234849	Millview Terr	54.8688621054	-5.0129696389
34234896	Village Road End	54.8358940708	-4.9802005288
34234923	St Stephens	54.8371147199	-4.9762562835
34234934	Village Shop	54.807236344	-4.9620574544
34234938	Bayview	54.7679241373	-4.9408809615
34234949	Village	54.7240997205	-4.9551165104
34234963	Village	54.6894417024	-4.8951739699
34234683	John Niven Centre	54.9006867072	-5.0246145743
34234685	John Niven Centre	54.9002095953	-5.025000005
34239292	Lewis Street	54.8996793169	-5.0246326035
34234638	St John Street	54.9037016872	-5.0234053804
34234639	Dalrymple Street	54.9011031688	-5.0230544913
34234829	Stoneykirk Rd	54.8940509888	-5.022837767
34234847	Whiteleys Farm	54.8794400423	-5.0156618142
34239289	Lidl	54.8965125224	-5.0229131021
34234878	Mill	54.8664562572	-5.0055729274
34234892	Bridgebank	54.8664025606	-4.9990220865
34234936	Drumantrae	54.7783311919	-4.9425231324
34234942	Chapel Rossan	54.764819972	-4.9409821867
34234943	Balkelzie Bridge	54.7505915438	-4.9412089476
34234947	Botanic Gardens	54.7379438966	-4.9500030397
34234952	Kilumpha	54.7253008173	-4.9334420217
34234956	Brick Works	54.7271049834	-4.9205396121
34234958	Terally	54.7246320072	-4.9116011609
34234962	Curghie	54.6998084246	-4.9045281619