Bangor - Glanrafon - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:15:00	06:15:00	...	1
...	06:16:00	06:16:00	...	2
...	06:16:00	06:16:00	...	3
...	06:17:00	06:17:00	...	4
...	06:18:00	06:18:00	...	5
...	06:19:00	06:19:00	...	6
...	06:19:00	06:19:00	...	7
...	06:22:00	06:22:00	...	8
...	06:23:00	06:23:00	...	9
...	06:25:00	06:25:00	...	10
...	06:26:00	06:26:00	...	11
...	06:26:00	06:26:00	...	12
...	06:27:00	06:27:00	...	13
...	06:28:00	06:28:00	...	14
...	06:29:00	06:29:00	...	15
...	06:30:00	06:30:00	...	16
...	06:34:00	06:34:00	...	17
...	06:34:00	06:34:00	...	18
...	06:35:00	06:35:00	...	19
...	06:39:00	06:39:00	...	20
...	06:42:00	06:42:00	...	21
...	06:42:00	06:42:00	...	22
...	06:44:00	06:44:00	...	23

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
02/01/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
gwnagtm	Antelope Inn	53.2187636212	-4.1610045917
gwnamgp	Railway Station	53.2234235001	-4.1354273833
gwnamda	Morrisons	53.2257680913	-4.1350347117
gwnpmdg	Bangor Uchaf	53.2283778659	-4.1348949166
gwnpmda	Look Out	53.228291971	-4.1386812053
gwnajda	Coleg Normal	53.2230765729	-4.1517090756
gwnamat	Ffordd Deiniol	53.2253692204	-4.1317039646
gwnamgj	Bus Station	53.2281460862	-4.1262385389
gwntpjd	Farrar Street	53.2239210332	-4.1332499499
ynydagm	Carreg y Borth	53.2235390996	-4.1643911011
ynydajp	Bus Station	53.2253570803	-4.1642880586
ynyawta	Art Gallery	53.2284893919	-4.1611199548
ynyapga	Lon Brynteg	53.2389882076	-4.1428263281
ynyadjm	Cemetery	53.260372657	-4.0991096369
ynyadjd	West End	53.2618420544	-4.0968425481
ynyajwd	Glanrafon House	53.3052278544	-4.094916104
ynyadjg	Bulkeley Hotel	53.263357987	-4.0919235352
ynyapdm	Cichle Hill	53.2342350025	-4.1551309214
ynyapdt	Gazelle Hotel	53.2448109366	-4.1294630704
ynyawdw	Playing Field	53.2906215408	-4.0885895518
ynyawdj	Ponty y Rhyd	53.2955885124	-4.0868061738
ynyapmw	Fryars Bay	53.279744954	-4.0854039037
ynygatj	Plas Rhianfa	53.2382671912	-4.1444237685