Pontypridd - Tesco Upper Boat - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:12:00	08:12:00	...	1
...	08:15:00	08:15:00	...	2
...	08:16:00	08:16:00	...	3
...	08:17:00	08:17:00	...	4
...	08:19:00	08:19:00	...	5
...	08:20:00	08:20:00	...	6
...	08:21:00	08:21:00	...	7
...	08:21:00	08:21:00	...	8
...	08:22:00	08:22:00	...	9
...	08:23:00	08:23:00	...	10
...	08:24:00	08:24:00	...	11
...	08:30:00	08:30:00	...	12
...	08:30:00	08:30:00	...	13
...	08:32:00	08:32:00	...	14
...	08:32:00	08:32:00	...	15
...	08:34:00	08:34:00	...	16
...	08:35:00	08:35:00	...	17
...	08:35:00	08:35:00	...	18
...	08:36:00	08:36:00	...	19
...	08:36:00	08:36:00	...	20
...	08:36:00	08:36:00	...	21
...	08:37:00	08:37:00	...	22
...	08:37:00	08:37:00	...	23
...	08:40:00	08:40:00	...	24

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
17/11/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
rhojpwa	Tesco	51.5802237488	-3.294381809
rhodmgp	Hawthorn Inn	51.5804834856	-3.3074505413
rhodmga	Caeglas	51.5791038059	-3.3021432571
rhodmgd	Foundry Houses	51.5786709197	-3.2990136006
rhogmdp	Brynffynnon Clinic	51.605354092	-3.3331034814
rhogpaj	Tygwyn Road	51.6047931058	-3.3286539116
rhogmgj	Common Hospital	51.6024935712	-3.3268540414
rhopaja	Bus Station	51.605504184	-3.3396638261
rhodjpa	St Mary`s Church	51.5965100333	-3.3216264769
rhodjma	Castle Inn Bridge	51.5915331443	-3.3220161262
rhogtmg	Post Office	51.5858828761	-3.3135091333
rhogtad	Tennyson Close	51.5887454183	-3.3100118148
rhogtpa	Wordsworth Gardens	51.5888702256	-3.3068829891
rhogtgj	Leisure Centre	51.5827122322	-3.3091743372
rhogtgp	Library	51.5851351166	-3.3144402034
rhogtjg	Poplar Road Methodist	51.583723318	-3.3096219741
rhogtja	Masefield Way Top	51.5896078156	-3.3052440974
rhogtjw	Poets Close	51.5901713406	-3.3087392105
rhogtdm	Fairfield Lane	51.5814065453	-3.3101470958
rhogtga	Glantaff School	51.5901138639	-3.3194920071
rhodjmj	Gwaun Road	51.5922165599	-3.3188167042
rhodjmt	Morien Crescent	51.5919275511	-3.3165274313
rhopdgw	Glyntaff Campus	51.5939144389	-3.322951482
rhoptdm	Ilan Avenue	51.5907455234	-3.3192937779