Edinburgh - St Andrews - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:30:00	08:30:00	...	1
...	08:32:00	08:32:00	...	2
...	08:34:00	08:34:00	...	3
...	08:53:00	08:53:00	...	4
...	08:55:00	08:55:00	...	5
...	09:05:00	09:05:00	...	6
...	09:06:00	09:06:00	...	7
...	09:09:00	09:09:00	...	8
...	09:17:00	09:17:00	...	9
...	09:19:00	09:19:00	...	10
...	09:21:00	09:21:00	...	11
...	09:23:00	09:23:00	...	12
...	09:25:00	09:25:00	...	13
...	09:27:00	09:27:00	...	14
...	09:31:00	09:31:00	...	15
...	09:34:00	09:34:00	...	16
...	09:42:00	09:42:00	...	17

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

stop_code	stop_name	stop_lat	stop_lon
36237987	Slip Road	55.9875092345	-3.4042804575
36238725	Barnton Junction	55.9607986881	-3.3050208971
36238726	Hillpark Steps	55.9627215926	-3.2758499743
36237643	Telford Road	55.9601837948	-3.2561118499
36232728	Craigleith Drive	55.9557072539	-3.2403186827
36232696	Learmonth Terrace	55.9552435509	-3.2192584245
36246236	Queensferry Street	55.9504686291	-3.2086830099
36235972	Princes Street (west)	55.9512566262	-3.2016130961
36243246	Princes Street (Scott Mon.)	55.9523426463	-3.1952727578
36253232	Bus Station	55.9555492402	-3.1907588826
34323243	North Access	56.0120776034	-3.4033593826
34323249	Park & Ride	56.022579057	-3.4059705638
34347935	Park & Ride	56.0837579931	-3.3920643882
34347938	Park & Ride Arrival Bay	56.0839217326	-3.3910900212
34328587	Woodside Inn	56.1897986757	-3.1496643897
34328987	Bus Station	56.1955175242	-3.1702707412
34347457	Bankhead Roundabout	56.1831504885	-3.1466783918