Harris Academy - Charleston - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
36326264	Lochinver Crescent	56.4697016453	-3.0528147472
36326265	Deveron Terrace	56.4680932904	-3.0485825729
36326373	Charleston Bar	56.4696207114	-3.0238224425
36326398	Harris Academy North	56.4565180639	-3.0099534303
36324323	Duncarse Road	56.4724352271	-3.0461699395
36323789	Gowrie Court	56.4684681972	-3.0414024165
36324347	Denoon Terrace	56.4682805525	-3.0229098794
36324573	Dalrymple Street	56.4645372526	-3.0236044673
36324895	Dunholm Road	56.4722087063	-3.0495888628
36324987	Hazel Avenue	56.4571104176	-3.0275424135
36325238	West Grove Avenue	56.4565546008	-3.0142867992
36324984	West Park Road	56.4565324475	-3.0125986831
36324989	Invergowrie Drive	56.457701287	-3.0310471188
36323782	Arran Drive	56.4702819676	-3.0307713505
36324928	Lister Place	56.4601396867	-3.0316974004
36324978	Glamis Road	56.4568114412	-3.0234939785
36323795	Tweed Crescent	56.4693509568	-3.0357617168
36324985	Arnhall Drive	56.4566143385	-3.0190589085
36324346	Dalrymple Terrace	56.4654471427	-3.0222169404
36325258	Riverside Place	56.4580716537	-3.0362010835