Bangor - Gerlan - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:15:00	07:15:00	...	1
...	07:15:00	07:15:00	...	2
...	07:15:00	07:15:00	...	3
...	07:16:00	07:16:00	...	4
...	07:16:00	07:16:00	...	5
...	07:16:00	07:16:00	...	6
...	07:17:00	07:17:00	...	7
...	07:17:00	07:17:00	...	8
...	07:18:00	07:18:00	...	9
...	07:18:00	07:18:00	...	10
...	07:19:00	07:19:00	...	11
...	07:20:00	07:20:00	...	12
...	07:20:00	07:20:00	...	13
...	07:23:00	07:23:00	...	14
...	07:28:00	07:28:00	...	15
...	07:29:00	07:29:00	...	16
...	07:29:00	07:29:00	...	17
...	07:30:00	07:30:00	...	18
...	07:30:00	07:30:00	...	19
...	07:30:00	07:30:00	...	20
...	07:31:00	07:31:00	...	21
...	07:31:00	07:31:00	...	22
...	07:32:00	07:32: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
gwnajtm	Pen y bryn	53.2310810266	-4.1138878742
gwnajma	Glan Traeth	53.2292049189	-4.1111884267
gwnajtj	Nelson	53.2321508997	-4.1174318171
gwngawj	Nantygro	53.2315782776	-4.1248503828
gwnpjag	Brynbella Cottage	53.1884098461	-4.0782433425
gwnpgjt	Dol-goch	53.1861057418	-4.0747791496
gwnpgma	Meifod	53.1837844667	-4.0707457694
gwnapjw	Rhes Penrhyn	53.1815903696	-4.0666291522
gwnapta	Victoria Square	53.1806141105	-4.063304728
gwnapjp	Spar	53.1795311075	-4.0609480817
gwnapmj	Glanffrydlas	53.176936955	-4.0575913854
gwngatm	Penuel Church	53.2299693916	-4.1258344775
gwngawa	Depot	53.2336101951	-4.1203059211
gwnajwa	Maesgeirchen Entrance	53.2274831913	-4.1104294988
gwngjpm	Amlosgfa	53.2243292286	-4.1098249218
gwngjtg	Llandegai Industrial Estate	53.2189210128	-4.104511051
gwnajam	Bus Station	53.2284662543	-4.1264341983
gwnawjt	Llandegai Ffordd Fawr	53.2175046514	-4.1022397374
gwnawjw	Llandegai Vicarage	53.2154415123	-4.1014646725
gwngawp	Canolfan Bangor	53.2333595174	-4.123275383
gwnpwpj	Llys-y-gwynt	53.2032637448	-4.1057949307
gwntpwj	Rhes Penrhyn Terrace	53.1812484323	-4.0656099949
gwntwgt	Ffordd Pant	53.1773793086	-4.0564453332