PRESTON - LONGRIDGE SCHOOLS - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
lanadmga	Post Office	53.8082378065	-2.7228584501
lanadmgm	Black Bull Garstang Rd	53.79137684	-2.7137186304
lanadmjm	Lightfoot Lane	53.7971131874	-2.7149091513
lanadpdm	St John the Baptist Church	53.803040779	-2.7186845379
lanadpdw	Motorway Bridge	53.8142912621	-2.7100832015
lanadpgd	Daniels Cross	53.8124059417	-2.7157617638
lanagadg	St Cecilias RCHS	53.8243662052	-2.6053403249
lanagmpg	Camforth Hall Lane	53.8242321378	-2.6597241149
lanagmpj	The Croft	53.8233154665	-2.6710423743
lanagmpm	Goosnargh Lane	53.8257321106	-2.6760488322
lanamgwa	Brookside Road	53.793728972	-2.7141836332
lanatdgw	Stags Head	53.8221945239	-2.6689736929
lanatmwa	Marriotts Hotel	53.8052097249	-2.7212119435
landtamg	Whittingham Lane	53.8233172417	-2.6626416453
landtamj	Oakleaf Close	53.8261258639	-2.6795342038
landtamw	Whittingham Hospital The Lodge	53.8226577158	-2.6583625642
landtapm	Willow Tree Avenue	53.8106085808	-2.721714691
landtata	Orchard Farm	53.8154903885	-2.706412685
landtdpa	Old Oak	53.8238778095	-2.6077183302
landtdta	High School	53.8262666115	-2.6081175311
	Brabiner Lane	53.8242560215	-2.6353268372
	The Grapes Inn	53.8255234503	-2.6715942016
	Halfpenny Lane	53.8301011079	-2.6175779622
	Moores Corner	53.8272968306	-2.7009596829