Rosewell - Fort Kinnaird - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:26:00	12:26:00	...	1
...	12:27:00	12:27:00	...	2
...	12:28:00	12:28:00	...	3
...	12:29:00	12:29:00	...	4
...	12:31:00	12:31:00	...	5
...	12:31:00	12:31:00	...	6
...	12:32:00	12:32:00	...	7
...	12:34:00	12:34:00	...	8
...	12:35:00	12:35:00	...	9
...	12:35:00	12:35:00	...	10
...	12:36:00	12:36:00	...	11
...	12:37:00	12:37:00	...	12
...	12:40:00	12:40:00	...	13
...	12:41:00	12:41:00	...	14
...	12:41:00	12:41:00	...	15
...	12:42:00	12:42:00	...	16

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

stop_code	stop_name	stop_lat	stop_lon
36234276	King's Road	55.9566462226	-3.1207514262
36234279	Bridge Street	55.9549318774	-3.117578772
36234282	Portobello Town Hall	55.9534882446	-3.1152629923
36234365	Parrotshot	55.9389849322	-3.1123806698
36234368	Corbiewynd	55.9395070956	-3.1082811828
36234372	Milton Link	55.939745129	-3.1057904763
36245253	Fort Kinnaird	55.935031318	-3.1023905909
36234379	Newcraighall Road	55.9336886469	-3.0987988687
36242942	Retail Park	55.9332672297	-3.1017162122
36234383	Niddrie Cottages	55.9328851199	-3.1042504487
36234579	Standford Gardens	55.951656423	-3.1161231484
36238368	Southfield Place	55.9487038137	-3.1196892358
36238369	Durham Place Lane	55.9465043113	-3.1184888643
36238372	Milton Road	55.9442962483	-3.1172403495
36234359	Magdalene Drive	55.9407389773	-3.1151526685
36234363	The Jewel	55.9391327479	-3.114914394