West Granton - Pencaitland - Transport Data Hub

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

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
36253684	Waterfront Broadway	55.9783488232	-3.2422934059
36245435	West Granton Terminus	55.9793993021	-3.2423751675
36234347	Magdalene Drive	55.9441381458	-3.1058836638
36234352	Hope Lane	55.9441436093	-3.1102709612
36234356	Portobello High School	55.9436700623	-3.1149487142
36234693	Milton Gardens North	55.9430502385	-3.1208709955
36234694	Duddingston Gardens	55.9426375624	-3.1257263794
36234689	Duddingston Row	55.9426759023	-3.130370653
36234687	Duddingston Avenue	55.943921628	-3.1326805705
36234695	Duddingston Mills	55.9458960951	-3.1358606075
36234729	Paisley Drive	55.9477390284	-3.1377080286
36234732	Northfield Crescent	55.9495876574	-3.1399080973
36234734	Northfield Crescent	55.9506911711	-3.1410615253
36234735	Willowbrae Gardens	55.9529025047	-3.1458030107
36234736	Abercorn Road	55.9536518998	-3.1473466211
36234737	Meadowbank House	55.9550784783	-3.1523858404
36234738	Meadowbank Stadium	55.95559596	-3.1566135022
36234739	Wishaw Terrace	55.9563313797	-3.1615365176
36234742	Marionville Road	55.9567029017	-3.1640622781
36234743	Carlyle Place	55.9571890591	-3.1677607757
36243272	Calton Terrace Brae	55.9558844659	-3.1726705697
36235895	Regent Terrace	55.953350149	-3.179304393
36235894	St Andrew's House	55.9538747666	-3.183628552
36236783	Waterloo Place	55.9536067065	-3.1872078502
36235976	Princes Street (Waverley Steps)	55.9528962187	-3.1909977299
36243234	Princes Street (west)	55.9511628114	-3.2010977238
36245986	Queensferry Street	55.9504119051	-3.208969499
36232368	Drumsheugh Place	55.951550719	-3.211951709
36232365	Dean Bridge	55.9543285603	-3.2154659203
36232695	Learmonth Terrace	55.9551075427	-3.2193822781
36232865	Flora Stevenson School	55.957779505	-3.2253927174
36232868	Comely Bank Cemetery	55.9600046586	-3.2284264215
36232873	Western General	55.9618752293	-3.2309686426
36232876	West Woods	55.9633609253	-3.2324575869
36232874	North Werber Park	55.9649667442	-3.2336140431
36232852	Crewe Toll	55.9664293106	-3.2347179702
36232832	Crewe Toll	55.9694458455	-3.2367687724
36232834	Crewe Road West	55.9728271215	-3.2382867553
36232835	Boswall Parkway	55.9751486276	-3.2388577008
36232836	Royston Mains Crescent	55.9767162354	-3.2393405008