Rosewell - Fort Kinnaird - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:52:00	07:52:00	...	1
...	07:52:00	07:52:00	...	2
...	07:53:00	07:53:00	...	3
...	07:53:00	07:53:00	...	4
...	07:54:00	07:54:00	...	5
...	07:55:00	07:55:00	...	6
...	07:55:00	07:55:00	...	7
...	07:56:00	07:56:00	...	8
...	07:57:00	07:57:00	...	9
...	07:57:00	07:57:00	...	10
...	07:58:00	07:58:00	...	11
...	07:58:00	07:58:00	...	12
...	07:58:00	07:58:00	...	13
...	07:59:00	07:59:00	...	14
...	07:59:00	07:59:00	...	15
...	08:00:00	08:00:00	...	16
...	08:01:00	08:01:00	...	17
...	08:01:00	08:01:00	...	18
...	08:02:00	08:02:00	...	19
...	08:03:00	08:03:00	...	20
...	08:03:00	08:03:00	...	21
...	08:06:00	08:06:00	...	22
...	08:07:00	08:07:00	...	23
...	08:07:00	08:07:00	...	24
...	08:08:00	08:08:00	...	25

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
36234648	Royal High Primary	55.9545817424	-3.1401029361
36234649	Nrothfield Road	55.9531429346	-3.1382829466
36234652	Mountcastle Grove	55.9520378379	-3.133398034
36234653	Mountcastle Gardens	55.9514790989	-3.1306432194
36234654	Figgate Park	55.9500122814	-3.1279421488
36247269	Duddingston Road	55.9480128306	-3.1264908679
36234568	Portobello High School	55.9478894969	-3.1252382685
36234569	St John's Primary School	55.9483108903	-3.1223841266
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
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
36234642	Goff Avenue	55.9572290492	-3.1258135946
36234643	Telferton	55.957023127	-3.1276976009
36234645	Parker Road	55.9565662817	-3.1314642418
36234646	Moira Terrace	55.9562745553	-3.134851233
36234647	Piershill Cemetery	55.9558437009	-3.1386985655