Sandyhills - Dalbeattie - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:50:00	07:50:00	...	1
...	07:51:00	07:51:00	...	2
...	07:53:00	07:53:00	...	3
...	07:53:00	07:53:00	...	4
...	07:57:00	07:57:00	...	5
...	08:00:00	08:00:00	...	6
...	08:01:00	08:01:00	...	7
...	08:03:00	08:03:00	...	8
...	08:07:00	08:07:00	...	9
...	08:08:00	08:08:00	...	10
...	08:09:00	08:09:00	...	11
...	08:10:00	08:10:00	...	12
...	08:11:00	08:11:00	...	13
...	08:11:00	08:11:00	...	14
...	08:13:00	08:13:00	...	15
...	08:18:00	08:18:00	...	16
...	08:23:00	08:23:00	...	17
...	08:25:00	08:25:00	...	18
...	08:26:00	08:26:00	...	19
...	08:27:00	08:27:00	...	20
...	08:28:00	08:28:00	...	21
...	08:30:00	08:30:00	...	22

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
34238293	Village	54.8800304901	-3.7311051792
34238285	Village	54.8655365455	-3.797068609
34238278	Shop	54.8758153458	-3.8136115965
34238274	Hill	54.8817672414	-3.8110729701
34238273	Hill	54.8816226026	-3.8111288367
34238276	Mariner	54.8796226161	-3.8144529304
34238275	Mariner	54.87963346	-3.8143287119
34236347	Maxwell Arms	54.9332021558	-3.8232492185
34238263	High Street	54.9287682154	-3.8198491005
34238253	Crown Inn	54.9321895175	-3.8212523193
34238675	Portling	54.8748701147	-3.7456440451
34238287	Village	54.8725842818	-3.7651204247
34238282	Road End	54.8717991599	-3.7690447158
34238279	Road End	54.8717475367	-3.7688866037
34238284	Tearooms	54.864934211	-3.7867261956
34238283	Tearooms	54.864824823	-3.7868304339
34238269	Caravan Park	54.8890611531	-3.8053194679
34238272	Caravan Park	54.8888285514	-3.8052466953
34238268	Greenhill	54.9048127325	-3.8164439102
34238264	High Street	54.9232487855	-3.8175087848
34236362	Craignair Church	54.9312557167	-3.8265793428
34238726	High School	54.9311264812	-3.8291956613