Dalmellington - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:25:00	17:25:00	...	1
...	17:25:00	17:25:00	...	2
...	17:26:00	17:26:00	...	3
...	17:29:00	17:29:00	...	4
...	17:29:00	17:29:00	...	5
...	17:29:00	17:29:00	...	6
...	17:30:00	17:30:00	...	7
...	17:30:00	17:30:00	...	8
...	17:30:00	17:30:00	...	9
...	17:30:00	17:30:00	...	10
...	17:32:00	17:32:00	...	11
...	17:33:00	17:33:00	...	12
...	17:37:00	17:37:00	...	13
...	17:40:00	17:40:00	...	14
...	17:41:00	17:41:00	...	15
...	17:41:00	17:41:00	...	16
...	17:43:00	17:43:00	...	17
...	17:44:00	17:44:00	...	18
...	17:46:00	17:46:00	...	19
...	17:49:00	17:49:00	...	20
...	17:52:00	17:52:00	...	21
...	17:55:00	17:55:00	...	22
...	17:58:00	17:58:00	...	23
...	17:59:00	17:59:00	...	24
...	18:00:00	18:00:00	...	25
...	18:00:00	18:00:00	...	26
...	18:00:00	18:00:00	...	27
...	18:05:00	18:05:00	...	28
...	18:07:00	18:07:00	...	29
...	18:10:00	18:10:00	...	30
...	18:11:00	18:11:00	...	31
...	18:12:00	18:12:00	...	32

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
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
34239343	Medical centre	54.9498571466	-3.9223659595
34236259	Ernespie Road	54.9485853226	-3.9209467109
34236264	Ernespie Road	54.9468525945	-3.9230969346
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