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=MX,number=9}, {key=CN,number=2}]
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;
countrycode geonameid name featurecode MX 13308916 Ocoro PPLX MX 13308914 Tamaulipas PPLX MX 13308917 El Gallo de Limones PPLX MX 13308918 Sector la Cruz PPL MX 13308921 Ingeniero Rubén Márquez y su Anexo Número Dos PPL MX 13308920 Platanar Abajo Primera Sección PPL MX 13308923 Veinticuatro de Febrero PPL MX 13308925 Campo la Primavera PPL MX 13308924 Las Huertas PPL CN 13308926 Tianbacun PPL CN 13308927 Xiaoliziping PPLX