Newton Stewart - Port William - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:05:00	12:05:00	...	1
...	12:06:00	12:06:00	...	2
...	12:09:00	12:09:00	...	3
...	12:10:00	12:10:00	...	4
...	12:12:00	12:12:00	...	5
...	12:14:00	12:14:00	...	6
...	12:17:00	12:17:00	...	7
...	12:19:00	12:19:00	...	8
...	12:20:00	12:20:00	...	9
...	12:21:00	12:21:00	...	10
...	12:21:00	12:21:00	...	11
...	12:24:00	12:24:00	...	12
...	12:26:00	12:26:00	...	13
...	12:27:00	12:27:00	...	14
...	12:30:00	12:30:00	...	15
...	12:33:00	12:33:00	...	16
...	12:40:00	12:40:00	...	17
...	12:40:00	12:40:00	...	18
...	12:40:00	12:40:00	...	19
...	12:40:00	12:40:00	...	20
...	12:40:00	12:40:00	...	21
...	12:44:00	12:44:00	...	22
...	12:46:00	12:46:00	...	23
...	12:47:00	12:47:00	...	24
...	12:53:00	12:53:00	...	25
...	12:57:00	12:57:00	...	26
...	12:57:00	12:57:00	...	27
...	12:57:00	12:57:00	...	28
...	12:57:00	12:57:00	...	29
...	12:58:00	12:58:00	...	30
...	13:01:00	13:01:00	...	31
...	13:02:00	13:02:00	...	32
...	13:05:00	13:05:00	...	33

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

stop_code	stop_name	stop_lat	stop_lon
34235258	Dashwood Square	54.9558578033	-4.4842817904
34236942	Main Street	54.7008518426	-4.3647627409
34236856	North Main St	54.8679230158	-4.4432389531
34236864	Main Street	54.8318518907	-4.456038953
34239278	Primary School	54.833643583	-4.4585615651
34236872	Forteviot Gardens	54.7895759396	-4.3715741785
34236873	Mill Road	54.7896264696	-4.3717482474
34236874	South Crescent	54.7890867151	-4.3690100289
34236875	South Street	54.7880668242	-4.3696814454
34236876	High Street	54.7884855264	-4.3707947938
34236893	Village	54.7915130797	-4.4312681211
34236894	Pheasant Hotel	54.7919483559	-4.4337677481
34236925	The Grapes	54.734053383	-4.4146666664
34236857	Standing Stones	54.8579783302	-4.4598399732
34239384	Standing Stones	54.8580339685	-4.4575372097
34239294	Wigtown Road	54.9515211576	-4.4809529226
34236838	Moss of Cree	54.9342990856	-4.4623444679
34236842	Baltersan	54.9220423527	-4.4630156658
34236845	A714	54.9121112084	-4.4638130987
34236847	Carsegowan	54.8989253262	-4.4659711041
34236849	Culquhirk	54.881243235	-4.4535714169
34236853	Primary	54.8698583176	-4.4444471288
34236859	Whauphill Jct	54.8434532955	-4.4646412266
34236865	Balfern	54.8216661926	-4.4342323155
34236868	Orchardton Cottages	54.8132629625	-4.4080293866
34236878	Whitehills	54.7913526041	-4.4118442493
34236897	Castlewigg	54.7568473919	-4.4350175836
34236898	Bus Depot	54.7378528705	-4.4152656391
34236929	St John Street	54.7348530934	-4.4146831853
34238676	Post Office	54.7325858796	-4.4156822398
34236934	High Street	54.7300598375	-4.4179394599
34236935	Low Balcray	54.7128921771	-4.403393927
34236937	Prestrie Farm	54.707470127	-4.3916629395