number of errors=13
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=11}, {key=MX,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 CN 13286739 Xigoucun PPL MX 13286759 Novapodaca PPLX CN 13286734 Zhangjia PPLF CN 13286735 Xijiangcun PPL CN 13286736 Fuzhuangcun PPL MX 13286723 La Ratonera Cuatro PPL CN 13286730 Laocunzi PPLX CN 13286738 Xiping PPL CN 13286740 Tiejianglu PPLL CN 13286741 Guanshangcun PPL CN 13286742 Dihoucun PPL CN 13286743 Xizhanglushicun PPL CN 13286744 Jibeicun PPL