Gyle Centre - Seafield - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	23:41:00	23:41:00	...	1
...	23:42:00	23:42:00	...	2
...	23:42:00	23:42:00	...	3
...	23:43:00	23:43:00	...	4
...	23:43:00	23:43:00	...	5
...	23:44:00	23:44:00	...	6
...	23:44:00	23:44:00	...	7
...	23:45:00	23:45:00	...	8
...	23:45:00	23:45:00	...	9
...	23:45:00	23:45:00	...	10
...	23:46:00	23:46:00	...	11
...	23:47:00	23:47:00	...	12
...	23:48:00	23:48:00	...	13
...	23:49:00	23:49:00	...	14
...	23:50:00	23:50:00	...	15
...	23:51:00	23:51:00	...	16
...	23:52:00	23:52:00	...	17
...	23:52:00	23:52:00	...	18
...	23:53:00	23:53:00	...	19
...	23:53:00	23:53:00	...	20
...	23:54:00	23:54:00	...	21
...	23:55:00	23:55:00	...	22
...	23:56:00	23:56:00	...	23
...	23:56:00	23:56:00	...	24
...	23:57:00	23:57:00	...	25
...	23:57:00	23:57:00	...	26
...	23:58:00	23:58:00	...	27
...	23:59:00	23:59:00	...	28
...	00:00:00	00:00:00	...	29
...	00:00:00	00:00:00	...	30
...	00:01:00	00:01:00	...	31
...	00:03:00	00:03:00	...	32
...	00:05:00	00:05:00	...	33
...	00:07:00	00:07:00	...	34
...	00:09:00	00:09:00	...	35
...	00:10:00	00:10:00	...	36
...	00:11:00	00:11:00	...	37
...	00:12:00	00:12:00	...	38
...	00:14:00	00:14:00	...	39

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

stop_code	stop_name	stop_lat	stop_lon
36236827	Broomhouse Roundabout	55.9294419585	-3.28679225
36242468	Gyle Centre	55.9381556535	-3.314249172
36236854	South Gyle Park	55.9342752893	-3.3039687965
36247694	Lochside Crescent	55.9346962579	-3.3159249174
36247426	Lochside Place	55.9331772457	-3.3134402894
36245242	Redheughs Avenue	55.933184591	-3.3093746606
36236856	South Gyle Mains	55.9335525478	-3.3000867011
36236857	South Gyle Wynd	55.933093144	-3.2976381989
36236863	Forrester High School	55.9312934018	-3.2927600505
36253275	Bankhead Drive	55.929857797	-3.2917038614
36243478	Drum Brae South	55.942912871	-3.2918022427
36236589	St Ninians Road	55.943196509	-3.2870242574
36236587	Glebe Road	55.9429349914	-3.2836692094
36238768	Station Road	55.9425133567	-3.2792842098
36236586	Belgrave Road	55.9418820675	-3.2734354281
36235925	Edinburgh Zoo	55.942331536	-3.2673179413
36236583	Pinkhill	55.9425322475	-3.2652750713
36236584	Balgreen Road	55.9439968539	-3.2573810167
36238343	Belmont Crescent	55.9444730761	-3.2547384729
36236585	Western Corner	55.9449865529	-3.2501916253
36239658	Murrayfield Road	55.9453584824	-3.2445192572
36232652	Ormidale Terrace	55.9457421197	-3.2403363126
36232653	Roseburn Gardens	55.9457942288	-3.2351499535
36232654	Wester Coates	55.9457947425	-3.2288090552
36232656	Magdala Crescent	55.9460248263	-3.222843684
36232657	Haymarket Station	55.9459542015	-3.2181818345
36232637	West Maitland Street	55.9469130734	-3.2157139433
36236572	Shandwick Place	55.9496334176	-3.2095537641
36235973	Princes Street (west)	55.951361837	-3.2009597554
36253729	George Street (Assembly Rooms)	55.9532720193	-3.1994974413
36232379	George Street (The Dome)	55.9539400292	-3.195482147
36232497	Dublin Street	55.9560849593	-3.1920406419
36232498	York Place	55.9566384478	-3.1886941293
36235979	Elm Row	55.9588662918	-3.1840852566
36236792	Forester Park Avenue	55.9332945693	-3.2878644166
36236789	Broomhall Gardens	55.9363470897	-3.2906871872
36236785	Broomhall Road	55.938401569	-3.292708681
36242835	Meadow Place Road	55.9419471267	-3.2930669757
36236839	Redheughs Avenue	55.9340288247	-3.3077223313