Harris Academy - Charleston - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:06:00	08:06:00	...	2
...	08:08:00	08:08:00	...	3
...	08:10:00	08:10:00	...	4
...	08:12:00	08:12:00	...	5
...	08:14:00	08:14:00	...	6
...	08:16:00	08:16:00	...	7
...	08:17:00	08:17:00	...	8
...	08:18:00	08:18:00	...	9
...	08:19:00	08:19:00	...	10
...	08:20:00	08:20:00	...	11
...	08:21:00	08:21:00	...	12
...	08:22:00	08:22:00	...	13
...	08:24:00	08:24:00	...	14
...	08:26:00	08:26:00	...	15
...	08:28:00	08:28:00	...	16
...	08:29:00	08:29:00	...	17
...	08:30:00	08:30:00	...	18
...	08:32:00	08:32:00	...	19
...	08:33:00	08:33:00	...	20
...	08:34:00	08:34:00	...	21
...	08:35:00	08:35: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
36325867	Brook Close	56.4614789443	-2.9874466646
36325869	Rosefield Street	56.4624067827	-2.9950170795
36326369	Grosvenor Road	56.4564447231	-3.0079232136
36326373	Charleston Bar	56.4696207114	-3.0238224425
36326423	Harris Academy South	56.4564012899	-3.0099503308
36323267	Peel Street	56.4687190794	-3.0099527766
36323268	Lochee Park	56.4686344014	-3.0115249703
36323273	Tullideph Road	56.4689900394	-3.0053502234
36323737	Donalds Lane	56.4748681095	-3.0281196469
36323743	Buttars Loan	56.4755877602	-3.0290969335
36323787	Elmwood Road	56.4691945738	-3.0210191312
36323825	Tullideph Road	56.4659240019	-3.0000755218
36325252	Hyndford Street	56.4565255884	-3.0023759994
36325239	Windsor Street	56.4564896792	-2.9979128586
36325635	Ancrum Drive	56.4672642185	-3.0032270671
36323458	Balgarthno Street	56.4747314383	-3.0391388447
36325747	Blackness Road	56.4593383197	-2.9854762787
36325742	Peddie Street	56.4569646494	-2.9913374154
36325743	Blackness Avenue	56.4566358797	-2.9942495678
36325372	Buttars Loan	56.4718890752	-3.0298247115
36323742	Brownhill Terrace	56.4757668006	-3.0335013147
36323462	Gourdie Terrace	56.4752317185	-3.043763041