Porth - Clydach Vale - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	00:34:00	00:34:00	...	1
...	00:35:00	00:35:00	...	2
...	00:35:00	00:35:00	...	3
...	00:36:00	00:36:00	...	4
...	00:36:00	00:36:00	...	5
...	00:37:00	00:37:00	...	6
...	00:37:00	00:37:00	...	7
...	00:37:00	00:37:00	...	8
...	00:37:00	00:37:00	...	9
...	00:38:00	00:38:00	...	10
...	00:38:00	00:38:00	...	11
...	00:38:00	00:38:00	...	12
...	00:39:00	00:39:00	...	13
...	00:39:00	00:39:00	...	14
...	00:39:00	00:39:00	...	15
...	00:40:00	00:40:00	...	16
...	00:40:00	00:40:00	...	17
...	00:41:00	00:41:00	...	18
...	00:41:00	00:41:00	...	19
...	00:42:00	00:42:00	...	20
...	00:42:00	00:42:00	...	21
...	00:44:00	00:44:00	...	22
...	00:44:00	00:44:00	...	23
...	00:45:00	00:45:00	...	24
...	00:45:00	00:45:00	...	25
...	00:46:00	00:46:00	...	26

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

stop_code	stop_name	stop_lat	stop_lon
rhogpga	Ty Porth	51.61561303	-3.4168307857
rhogpda	School	51.6160659409	-3.4210191745
rhojdgj	Cemetery Lodge	51.6167089338	-3.4236103102
rhojdaw	Cemetery Gates	51.6177211999	-3.4283653173
rhojdgp	Carnegie Clinic	51.6179790952	-3.4300778676
rhojdam	Checks	51.6184482851	-3.4328948831
rhojdmd	Royal Hotel	51.6189511606	-3.4410287163
rhojdjw	Miskin Road	51.6226554411	-3.4505504486
rhojdmj	Lee`s Takeaway	51.6251508819	-3.4516268828
rhojdgw	Colliers Arms	51.6276832825	-3.4518955522
rhojdat	Ynyscynon Road	51.628954216	-3.4516471778
rhojdmt	Ynyscynon Park	51.6320365021	-3.4496215975
rhodtmw	Partridge Square	51.6348739047	-3.449220787
rhodtwa	Princess Louise Road	51.6343257492	-3.4506482835
rhodtpj	Magistrates Court	51.632755772	-3.4547162141
rhodtmt	Asda	51.6309836696	-3.4554975313
rhogwtd	Enterprise Centre	51.6282773103	-3.4562055212
rhojadm	Bus Station	51.625521544	-3.4579953676
rhogpdt	Morrisons	51.6101720643	-3.4056854191
rhogpdg	Pontypridd Road	51.6110987229	-3.4078948358
rhogpdp	Mary Street	51.6138390037	-3.4088317908
rhogpgt	Bus Depot	51.6150720796	-3.4109787392
rhojdjd	Miskin Hotel	51.6199217793	-3.4476464546
rhojdjm	Brithweunydd Road	51.6191876699	-3.4466552789
rhopwjw	Garth Road	51.6192941345	-3.4379917018
rhotdaw	Porth Square	51.6117673001	-3.4091286964