Perth - Spittalfield - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:00:00	08:00:00	...	1
...	08:09:00	08:09:00	...	2
...	08:16:00	08:16:00	...	3
...	08:17:00	08:17:00	...	4
...	08:17:00	08:17:00	...	5
...	08:18:00	08:18:00	...	6
...	08:18:00	08:18:00	...	7
...	08:20:00	08:20:00	...	8
...	08:23:00	08:23:00	...	9
...	08:24:00	08:24:00	...	10
...	08:25:00	08:25:00	...	11
...	08:28:00	08:28:00	...	12
...	08:29:00	08:29:00	...	13
...	08:35:00	08:35:00	...	14
...	08:36:00	08:36:00	...	15
...	08:40:00	08:40:00	...	16
...	08:42:00	08:42:00	...	17
...	08:42:00	08:42:00	...	18
...	08:44:00	08:44:00	...	19
...	08:45:00	08:45:00	...	20
...	08:46:00	08:46:00	...	21
...	08:48:00	08:48:00	...	22
...	08:50:00	08:50:00	...	23

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
73745843	Rookery	56.4096117724	-3.441542615
73723696	Mill Street	56.3976419397	-3.433151055
73726485	St Johns Academy	56.4099874428	-3.4393688245
73724834	Holiday Inn	56.4163714259	-3.4612666909
73726724	Cross	56.4803360505	-3.4490621638
73728564	Kinclaven Crescent	56.5277040905	-3.4599097917
73726563	Scarth Road	56.4497357721	-3.4709516999
73726954	The Knapp	56.5197281244	-3.4083047442
73726587	Church Hall	56.484623147	-3.4520349919
73724679	St Johns RC Church	56.3997843239	-3.4351435336
73724683	Balhousie Avenue	56.4024769058	-3.4385019254
73724685	Premier Store	56.4047453133	-3.4404673152
73724686	Balhousie Street	56.4072989443	-3.4410824089
73723483	Lindsay Place	56.4096235769	-3.4436175888
73724843	Southbound Bus Bay	56.4396480033	-3.472248829
73724838	Bute Drive	56.4146521412	-3.4584775818
73726543	East Brougham Street	56.4823997605	-3.4508458544
73726574	Marshall Way	56.4522516725	-3.4701889962
73727525	Denmarkfield	56.4364663336	-3.4730827164
73727825	Milton Road	56.4551985584	-3.4709681507
73727826	Benchill View	56.478671969	-3.4499891728
73728527	Gowrie Farm	56.4668043875	-3.4559806665
73729424	Lynton Farm	56.4908945356	-3.4512838695