Dalmellington - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:30:00	15:30:00	...	1
...	15:31:00	15:31:00	...	2
...	15:33:00	15:33:00	...	3
...	15:33:00	15:33:00	...	4
...	15:34:00	15:34:00	...	5
...	15:34:00	15:34:00	...	6
...	15:35:00	15:35:00	...	7
...	15:35:00	15:35:00	...	8
...	15:36:00	15:36:00	...	9
...	15:38:00	15:38:00	...	10
...	15:43:00	15:43:00	...	11
...	15:47:00	15:47:00	...	12
...	15:48:00	15:48:00	...	13
...	15:48:00	15:48:00	...	14
...	15:50:00	15:50:00	...	15
...	15:51:00	15:51:00	...	16
...	15:53:00	15:53:00	...	17
...	15:56:00	15:56:00	...	18
...	15:59:00	15:59:00	...	19
...	16:02:00	16:02:00	...	20
...	16:05:00	16:05:00	...	21
...	16:06:00	16:06:00	...	22
...	16:07:00	16:07:00	...	23
...	16:07:00	16:07:00	...	24
...	16:07:00	16:07:00	...	25
...	16:12:00	16:12:00	...	26
...	16:16:00	16:16:00	...	27
...	16:20:00	16:20:00	...	28
...	16:21:00	16:21:00	...	29
...	16:22:00	16:22:00	...	30

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
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34239328	Carlingwark Street	54.9382167851	-3.9331909813
34235938	Wayside	54.9631763241	-3.9673657601
34235934	Main Street	54.9799534868	-3.9847204018
34235936	South	54.9786480265	-3.9832026567
34235932	Church	54.9812559634	-3.9875196074
34235924	Village	55.0077722986	-4.0411421554
34235789	Post Office	55.0736566969	-4.1409585546
34235837	Braeside	55.0758602462	-4.1398543745
34238979	East Port	55.0738542795	-4.1394339638
34238982	Town Hall	55.0731560321	-4.1408064911
34235959	Shop	55.0878389409	-4.1132438432
34235953	Town Hall	54.9392844985	-3.9327426531
34238536	Dunmuir Road	54.9491415347	-3.9283905981
34236387	Swimming Pool	54.9418754721	-3.9274962305
34235952	Royal Bank	54.9402587048	-3.9302602492
34236389	Markethill	54.9431513867	-3.92638631
34236392	Library	54.9421040326	-3.9278194243
34235897	Little Drumrash	55.0253446005	-4.0729979671
34235946	Abercromby Road	54.9445731825	-3.93758691
34235943	Midpark	54.9503800186	-3.9465488562
34235928	Mill	54.9982937472	-4.006342134
34235926	House	55.0031573612	-4.0203922264
34235895	Sailing Centre	55.0454373182	-4.1020871331
34235879	Ken Bridge	55.08026624	-4.1300156518
34235894	Craigend	55.0602281508	-4.1204322914
34235958	Trolane	55.1064444547	-4.1271756269
34235845	Post Office	55.1060220795	-4.1639009401
34235843	Bank House	55.1059677872	-4.1649327145
34238978	Underhill	55.1067473874	-4.1600050471