Harris Academy - Charleston - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:55:00	14:55:00	...	1
...	14:56:00	14:56:00	...	2
...	14:56:00	14:56:00	...	3
...	14:57:00	14:57:00	...	4
...	14:57:00	14:57:00	...	5
...	14:58:00	14:58:00	...	6
...	14:58:00	14:58:00	...	7
...	14:59:00	14:59:00	...	8
...	15:01:00	15:01:00	...	9
...	15:03:00	15:03:00	...	10
...	15:04:00	15:04:00	...	11
...	15:04:00	15:04:00	...	12
...	15:05:00	15:05:00	...	13
...	15:06:00	15:06:00	...	14
...	15:07:00	15:07:00	...	15
...	15:08:00	15:08:00	...	16
...	15:09:00	15:09:00	...	17
...	15:10:00	15:10:00	...	18
...	15:11:00	15:11:00	...	19
...	15:12:00	15:12:00	...	20
...	15:14:00	15:14:00	...	21
...	15:16:00	15:16:00	...	22

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
36325937	Lochinver Crescent	56.469646374	-3.0529755359
36325938	Thurso Crescent	56.467958416	-3.0485950856
36326423	Harris Academy South	56.4564012899	-3.0099503308
36325754	Riverside Place	56.4579970841	-3.0365235902
36325829	Lynch Centre	56.4715962465	-3.0476402672
36324323	Duncarse Road	56.4724352271	-3.0461699395
36323785	Tweed Crescent	56.4690115595	-3.0365965155
36324348	Dalrymple Terrace	56.4654096087	-3.0224106918
36324349	Denoon Terrace	56.4683774882	-3.0231397244
36324565	Dalrymple Street	56.4646789661	-3.0238517263
36324979	West Park Road	56.4564028739	-3.0097556592
36325235	River Crescent	56.4577643212	-3.0331907604
36325246	Farington Street	56.4565303716	-3.0183427062
36325247	Farington Terrace	56.4564828349	-3.0153720408
36325249	Hazel Avenue	56.4571551747	-3.0286470242
36323793	Spey Drive	56.4682056337	-3.04378122
36325248	Glamis Road	56.4566666497	-3.0236198941
36323786	Arran Drive	56.4698775933	-3.0264426974
36323797	Arran Drive	56.47015908	-3.0293395992
36323796	Tweed Crescent	56.4701525729	-3.0312061088
36324929	Lister Place	56.4602101983	-3.0318615906
36323767	Gowrie Court	56.4683292382	-3.0419017817