Dumfries - Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:20:00	06:20:00	...	1
...	06:22:00	06:22:00	...	2
...	06:23:00	06:23:00	...	3
...	06:28:00	06:28:00	...	4
...	06:28:00	06:28:00	...	5
...	06:29:00	06:29:00	...	6
...	06:29:00	06:29:00	...	7
...	06:34:00	06:34:00	...	8
...	06:40:00	06:40:00	...	10
...	06:42:00	06:42:00	...	11
...	06:43:00	06:43:00	...	12
...	06:47:00	06:47:00	...	13
...	06:49:00	06:49:00	...	14
...	06:52:00	06:52:00	...	15
...	06:55:00	06:55:00	...	16
...	06:57:00	06:57:00	...	17
...	06:58:00	06:58:00	...	18
...	07:00:00	07:00:00	...	19
...	07:01:00	07:01:00	...	20
...	07:01:00	07:01:00	...	21
...	07:02:00	07:02:00	...	22
...	07:03:00	07:03:00	...	23
...	07:05:00	07:05:00	...	24
...	07:07:00	07:07:00	...	25
...	07:09:00	07:09:00	...	26
...	07:10:00	07:10:00	...	27
...	07:12:00	07:12:00	...	28
...	07:17:00	07:17:00	...	29
...	07:17:00	07:17:00	...	30
...	07:20:00	07:20:00	...	31

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
09/07/2018 @ 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
34238492	Railway Station	55.0722541413	-3.6047140725
34234635	English Street	55.0696047174	-3.6059392352
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34238959	Shelter	54.919612988	-3.9783308002
34236494	Tarff Bridge	54.8816613512	-4.0543405244
34236496	Tarff Station	54.8844919973	-4.0527852037
34239257	Garroch Business Park	55.0587358208	-3.6478725216
34236243	Village	55.0361267165	-3.8282349295
34236249	Village	55.0106002783	-3.8673750758
34236575	Village	54.8667865772	-4.0817286228
34236387	Swimming Pool	54.9418754721	-3.9274962305
34235952	Royal Bank	54.9402587048	-3.9302602492
34236389	Markethill	54.9431513867	-3.92638631
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34239239	Ettrick Court	55.0649760072	-3.6249212691
34239349	Cassalands	55.0658573262	-3.6235319247
34236478	Road End	54.9268960079	-3.9576345145
34236482	Hightae Farm	54.9295953192	-3.9473863501
34236259	Ernespie Road	54.9485853226	-3.9209467109
34236264	Ernespie Road	54.9468525945	-3.9230969346
34236257	Gerranton	54.9638621272	-3.9079917526
34236254	Dunjarg	54.9734514219	-3.8959779234
34236253	Chapelton Cottages	54.9822183584	-3.8835917282
34236247	Lochview Motel	55.0235739771	-3.8458887715
34236239	Brae	55.0493572249	-3.7821416575
34236237	Road End	55.0514292038	-3.7670172207
34236235	Road End	55.055640759	-3.7202179695