Castle Douglas - Town service - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:50:00	08:50:00	...	1
...	08:54:00	08:54:00	...	2
...	08:55:00	08:55:00	...	3
...	08:55:00	08:55:00	...	4
...	08:56:00	08:56:00	...	5
...	08:57:00	08:57:00	...	6
...	08:58:00	08:58:00	...	7
...	09:00:00	09:00:00	...	8
...	09:04:00	09:04:00	...	9
...	09:07:00	09:07:00	...	10
...	09:08:00	09:08:00	...	11
...	09:10:00	09:10:00	...	12
...	09:12:00	09:12:00	...	13
...	09:14:00	09:14:00	...	14
...	09:15:00	09:15:00	...	15
...	09:16:00	09:16:00	...	16
...	09:17:00	09:17:00	...	17
...	09:18:00	09:18:00	...	18
...	09:19:00	09:19:00	...	19

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
03/04/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34239328	Carlingwark Street	54.9382167851	-3.9331909813
34236268	Brown Crescent	54.9413403847	-3.9187120404
34235956	Cairnsmore Road	54.944810913	-3.9333826144
34238535	Dunmuir Road	54.9489209674	-3.9281301879
34236387	Swimming Pool	54.9418754721	-3.9274962305
34236389	Markethill	54.9431513867	-3.92638631
34238973	Cotton Street	54.939422039	-3.9337015687
34239343	Medical centre	54.9498571466	-3.9223659595
34236263	Ernespie Road	54.9484257364	-3.9213763226
34236262	Ernespie Road	54.9468037381	-3.9233444344
34236272	Gordon Drive	54.9420583878	-3.9187774722
34239325	Whitelaw Avenue	54.9442707348	-3.9164159387
34236267	Oakwell Road	54.9436834761	-3.92286753
34236265	Oakwell Road	54.9436579177	-3.9222105492
34235954	Railway Terrace	54.942874561	-3.9313692471
34235945	Abercromby Road	54.9446115943	-3.9374326205
34236385	Jubille Terrace	54.9386806642	-3.9345402181
34236384	Whitepark Rd	54.9377159236	-3.9290768443
34238684	Queen Elizabeth Drive	54.9370839796	-3.9235827987