Newton Stewart - Port William - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	11:00:00	11:00:00	...	1
...	11:00:00	11:00:00	...	2
...	11:02:00	11:02:00	...	3
...	11:03:00	11:03:00	...	4
...	11:06:00	11:06:00	...	5
...	11:07:00	11:07:00	...	6
...	11:07:00	11:07:00	...	7
...	11:07:00	11:07:00	...	8
...	11:08:00	11:08:00	...	9
...	11:11:00	11:11:00	...	10
...	11:18:00	11:18:00	...	11
...	11:18:00	11:18:00	...	12
...	11:20:00	11:20:00	...	13
...	11:25:00	11:25:00	...	14
...	11:25:00	11:25:00	...	15
...	11:25:00	11:25:00	...	16
...	11:25:00	11:25:00	...	17
...	11:26:00	11:26:00	...	18
...	11:31:00	11:31:00	...	19
...	11:34:00	11:34:00	...	20
...	11:38:00	11:38:00	...	21
...	11:40:00	11:40:00	...	22
...	11:43:00	11:43:00	...	23
...	11:46:00	11:46:00	...	24
...	11:46:00	11:46:00	...	25
...	11:47:00	11:47:00	...	26
...	11:50:00	11:50:00	...	27
...	11:52:00	11:52:00	...	28
...	11:54:00	11:54:00	...	29
...	11:56:00	11:56:00	...	30
...	12:00:00	12:00:00	...	31

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
34236939	Boyack Road	54.7009945653	-4.3675804279
34236856	North Main St	54.8679230158	-4.4432389531
34236863	Main Street	54.8318292117	-4.4562711552
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
34236892	Village	54.7916471322	-4.4313072828
34236895	Pheasant Inn	54.7924155419	-4.4337802722
34236924	St John Street	54.7362001866	-4.4147478153
34236926	The Grapes	54.7340759902	-4.4148854915
34236858	Standing Stones	54.8580660716	-4.4595025099
34236839	Moss of Cree	54.9342677271	-4.4625611134
34236843	Baltersan	54.922066758	-4.4631420127
34236846	A714	54.9121628632	-4.4639254773
34236848	Carsegowan	54.8987967873	-4.4661036257
34236852	Culquhirk	54.8811942532	-4.4537711224
34236854	Primary	54.8697496392	-4.4444873086
34236862	Whauphill Jct	54.843360671	-4.4647757661
34236867	Balfern	54.8215928062	-4.4343057387
34236869	Orchardton Cottages	54.8131895915	-4.408102843
34236879	Whitehills	54.791405857	-4.4118785337
34236896	Castlewigg	54.7568080478	-4.4351861945
34236923	Bus Depot	54.7377076674	-4.4153346738
34236928	Clydesdale Bank	54.732669479	-4.415997891
34236932	High Street	54.7301109226	-4.4180822983
34236936	Low Balcray	54.7127841254	-4.4034030585
34236938	Prestrie Farm	54.7074054389	-4.3917522746