Paisley - Glasgow - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:02:00	08:02:00	...	1
...	08:03:17	08:03:17	...	2
...	08:04:09	08:04:09	...	3
...	08:04:51	08:04:51	...	4
...	08:05:29	08:05:29	...	5
...	08:06:34	08:06:34	...	6
...	08:07:31	08:07:31	...	7
...	08:08:00	08:08:00	...	8
...	08:08:47	08:08:47	...	9
...	08:09:49	08:09:49	...	10
...	08:11:00	08:11:00	...	11
...	08:11:27	08:11:27	...	12
...	08:11:48	08:11:48	...	13
...	08:12:23	08:12:23	...	14
...	08:12:49	08:12:49	...	15
...	08:13:15	08:13:15	...	16
...	08:13:44	08:13:44	...	17
...	08:14:06	08:14:06	...	18
...	08:14:37	08:14:37	...	19
...	08:28:00	08:28:00	...	21
...	08:30:46	08:30:46	...	22
...	08:32:19	08:32:19	...	23
...	08:34:06	08:34:06	...	24
...	08:36:00	08:36:00	...	25

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

stop_code	stop_name	stop_lat	stop_lon
45234567	West George Lane	55.8622888187	-4.2582217603
45236758	Bath Street	55.863754666	-4.2576835561
45235639	Blythswood Street	55.861537786	-4.2633879622
45234765	Waterloo Lane	55.8611275209	-4.2593049724
45237239	Pavillion Theatre	55.8646865275	-4.2553882479
73923278	Balfour Kilpatrick	55.8725544415	-4.3736592479
73924797	Tirry Avenue	55.8702124166	-4.368800733
73923843	Brora Drive	55.8726889826	-4.3825077396
73923868	King George Park Avenue	55.8698345363	-4.3809262043
73925654	Camps Crescent	55.8668652583	-4.3801690333
73925684	Vanguard Way	55.8644590608	-4.3957807422
73923647	Nevis Road	55.865712308	-4.4024909849
73972958	Turner Drive	55.8586199455	-4.4149332183
73923264	Wright Street	55.8633116056	-4.4071374073
73924785	Sandyford Road	55.8614907683	-4.4106205958
73924747	Old Sneddon Street	55.8466999987	-4.4218938544
73923585	Hamilton Street	55.8498820524	-4.4191361425
73925632	West College Scotland	55.8521901101	-4.4178575891
73924729	West College Scotland	55.8539737323	-4.4167380633
73925398	Mews Lane	55.8557200691	-4.4161434373
73923289	Washington Road	55.860920133	-4.4126787939
73924549	Ambassador Way	55.8646282098	-4.3861535435
73925252	Yorkway	55.863765073	-4.3903359383
73924654	Merlinford Drive	55.8741229205	-4.3771441529