Sandyhills - Dalbeattie - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:00:00	07:00:00	...	1
...	07:00:00	07:00:00	...	2
...	07:00:00	07:00:00	...	3
...	07:00:00	07:00:00	...	4
...	07:00:00	07:00:00	...	5
...	07:01:00	07:01:00	...	6
...	07:04:00	07:04:00	...	7
...	07:07:00	07:07:00	...	8
...	07:08:00	07:08:00	...	9
...	07:09:00	07:09:00	...	10
...	07:10:00	07:10:00	...	11
...	07:10:00	07:10:00	...	12
...	07:11:00	07:11:00	...	13
...	07:12:00	07:12:00	...	14
...	07:16:00	07:16:00	...	15
...	07:19:00	07:19:00	...	16
...	07:20:00	07:20:00	...	17
...	07:20:00	07:20:00	...	18
...	07:21:00	07:21:00	...	19
...	07:22:00	07:22:00	...	20
...	07:26:00	07:26:00	...	21
...	07:30:00	07: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
34238294	Village	54.8801261852	-3.7313275175
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
34236348	Maxwell Arms	54.9332388714	-3.8237971952
34238262	High Street	54.9287265769	-3.8196287186
34238258	High Street	54.930956718	-3.8201508514
34238292	Portling	54.874957249	-3.7458348471
34238286	Village	54.8725779412	-3.765556538
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
34238267	Greenhill	54.9048961324	-3.8162760883
34238265	High Street	54.9226866678	-3.817233758
34239346	Port Street	54.9263635743	-3.8189757984
34238259	High Street	54.932414294	-3.8212468713