Sandyhills - Dalbeattie - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:38:00	08:38:00	...	1
...	08:38:00	08:38:00	...	2
...	08:39:00	08:39:00	...	3
...	08:39:00	08:39:00	...	4
...	08:41:00	08:41:00	...	5
...	08:42:00	08:42:00	...	6
...	08:43:00	08:43:00	...	7
...	08:43:00	08:43:00	...	8
...	08:44:00	08:44:00	...	9
...	08:44:00	08:44:00	...	10
...	08:44:00	08:44:00	...	11
...	08:45:00	08:45:00	...	12
...	08:45:00	08:45:00	...	13
...	08:47:00	08:47:00	...	14
...	08:48:00	08:48:00	...	15
...	08:50:00	08:50:00	...	16

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
34236347	Maxwell Arms	54.9332021558	-3.8232492185
34238242	Primary School	54.9330583494	-3.8160469976
34238239	Barrhill Rd	54.9357212466	-3.8152772723
34238257	Galla Avenue	54.9372280649	-3.8268813647
34238252	Glenshalloch Road	54.9283903502	-3.821673675
34238253	Crown Inn	54.9321895175	-3.8212523193
34236346	John Street	54.9340304886	-3.8225530679
34238256	Station Road	54.9352496057	-3.8257613977
34238243	William St	54.9314662577	-3.8173331586
34236342	Park Terrace	54.9364061465	-3.8211619658
34238478	Church Crescent	54.9295512122	-3.8275633906
34238245	Union Street	54.9291287891	-3.8167751208
34238246	Copeland Street	54.9268747251	-3.8172509401
34238247	Blair Street	54.9259418998	-3.8189255532
34238248	Port Street	54.9259648535	-3.8203935696
34238249	Charters Crt	54.9266265632	-3.8212193888