Carnock - Queen Anne High Sch - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:09:00	08:09:00	...	1
...	08:09:00	08:09:00	...	2
...	08:10:00	08:10:00	...	3
...	08:10:00	08:10:00	...	4
...	08:11:00	08:11:00	...	5
...	08:13:00	08:13:00	...	6
...	08:14:00	08:14:00	...	7
...	08:15:00	08:15:00	...	8
...	08:16:00	08:16:00	...	9
...	08:17:00	08:17:00	...	10
...	08:19:00	08:19:00	...	11
...	08:20:00	08:20:00	...	12
...	08:25:00	08:25:00	...	13
...	08:28:00	08:28:00	...	14
...	08:29:00	08:29:00	...	15
...	08:30:00	08:30:00	...	16
...	08:31:00	08:31:00	...	17
...	08:32:00	08:32:00	...	18
...	08:32:00	08:32:00	...	19
...	08:33:00	08:33:00	...	20
...	08:35:00	08:35:00	...	21

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
07/09/2016 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
34325359	Craigluscar Road	56.0818416434	-3.4989206099
34325325	Milesmark Depot	56.0802503883	-3.4908244078
34325268	Milesmark Primary School	56.0785726551	-3.4838985329
34324986	McLean Primary School	56.0766684916	-3.4725782443
34324975	Trenchard Place	56.0763782786	-3.4690324052
34325248	Broomhead Flats	56.0779837721	-3.4632287678
34325459	Primary School	56.0847888352	-3.5405297988
34325473	Bonhard Road	56.0859407975	-3.5439829065
34325476	Sir George Bruce Road	56.0859713301	-3.5537233591
34325493	Blairwood Park	56.0871501404	-3.5713373793
34325432	Dean Ridge	56.084008328	-3.5223229373
34325624	Porterfield	56.0875956871	-3.5793754978
34325632	Woodlands Terrace	56.0901432246	-3.6006481848
34325489	East Avenue	56.0865993381	-3.603683376
34325496	Houldsworth Street	56.0869013566	-3.6053352613
34325252	William Street	56.0776732477	-3.4794774752
34325497	Main Street	56.0873795818	-3.5758950982
34398974	Carnock Road	56.0873164186	-3.5631956716
34347627	Comrie Mains Farm	56.0909308055	-3.5960356063
34346958	Queen Anne High School	56.0808577024	-3.4633537938
34346754	Wilson Street	56.088390726	-3.6027452667