number of errors=7
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=4}, {key=CN,number=2}, {key=BV,number=1}]
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 13513040 Las Milpas de Abajo PPL MX 13513039 Llanitos Babicanora PPL MX 13513041 Las Milpas de En Medio PPL BV 13513008 Norvegia Station PPL CN 13513047 Shangjiecun PPL MX 13513042 Babitochi Uno PPL CN 13513043 Jiangpengzi PPL