populated places have timezone

number of errors=11
number of warnings=0
Group=chkGrpTimezone

select countrycode,geonameid,name,featurecode from geoname where timezoneid is null and featureclass in ('P') and featurecode <>'PPLQ'

[{key=CN,number=6}, {key=MX,number=5}]
update tmp5 set timezoneid=geoname_timezone.timezoneid from geoname_timezone where geoname_timezone.countrycode=tmp5.countrycode and layer=2 and st_within(tmp5.geography::geometry,wkb_geometry) and tmp5.timezoneid is null;
update geoname set timezoneid=tmp5.timezoneid from tmp5 where tmp5.geonameid=geoname.geonameid and geoname.timezoneid is null;

countrycode	geonameid	name	featurecode	
MX	13494954	La Tres de Holanda	PPL	
CN	13494964	Shuangwai	PPL	
MX	13494955	Bajio del Simental	PPL	
MX	13494956	El Coyote de Abajo	PPL	
CN	13494957	Liujiatian	PPL	
CN	13494961	Nanjiecun	PPL	
CN	13494962	Yaozhuangcun	PPL	
CN	13494965	Shangyong	PPL	
CN	13494966	Jiangnancun	PPL	
MX	13494982	Rinconada de Banthí	PPLX	
MX	13494981	Las Adjuntas de los Zocua	PPL