number of errors=91
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=82}, {key=MX,number=6}, {key=BV,number=1}, {key=HM,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 13513039 Llanitos Babicanora PPL MX 13513042 Babitochi Uno PPL MX 13513040 Las Milpas de Abajo PPL MX 13513041 Las Milpas de En Medio PPL CN 13513043 Jiangpengzi PPL CN 13513115 Shadongcun PPL CN 13513047 Shangjiecun PPL CN 13513088 Xintiancun PPL CN 13513085 Mudancun PPL CN 13513086 Miantiancun PPL CN 13513087 Fuyancun PPL CN 13513090 Xidapocun PPL CN 13513089 Lichengcun PPL CN 13513091 Lihuacun PPL CN 13513092 Beifenglicun PPL CN 13513093 Gaochengcun PPL CN 13513097 Donggoucun PPL CN 13513094 Fangcaocun PPL CN 13513095 Antiancun PPL CN 13513101 Xinxingcun PPL CN 13513110 Changyancun PPL CN 13513096 Qiusongcun PPL CN 13513131 Chunhecun PPL CN 13513098 Mopanshancun PPL CN 13513111 Xishancun PPL CN 13513105 Tangzigoucun PPL CN 13513099 Shangpingcun PPL CN 13513102 Wolongcun PPL CN 13513100 Longhecun PPL CN 13513104 Zhongxingcun PPL CN 13513114 Fu’ancun PPL CN 13513103 Longyancun PPL CN 13513106 Changxingcun PPL CN 13513107 Yongpingcun PPL CN 13513108 Fenglincun PPL CN 13513109 Donglincun PPL CN 13513119 Mudanchuancun PPL CN 13513120 Dongxingcun PPL CN 13513121 Gongxingcun PPL CN 13513122 Zhong’ancun PPL CN 13513128 Mudanchicun PPL CN 13513112 Ping’ancun PPL CN 13513123 Dongzhencun PPL CN 13513124 Dongweizicun PPL CN 13513136 Dashicun PPL CN 13513125 Taixingcun PPL CN 13513113 Dasongshucun PPL CN 13513129 Qinglintun PPL CN 13513126 Liuxingcun PPL CN 13513135 Shuangqiaocun PPL CN 13513132 Erjiashancun PPL CN 13513134 Gongjiadiancun PPL CN 13513127 Xixingcun PPL CN 13513133 Dongyangcun PPL CN 13513130 Jiapigoucun PPL CN 13513137 Zhongxingcun PPL CN 13513138 Longshuicun PPL CN 13513139 Yingbicun PPL CN 13513116 Mingyuegoucun PPL CN 13513117 Yongxingcun PPL CN 13513118 Hongxingcun PPL CN 13513148 Duanshubeicun PPL CN 13513149 Daxingcun PPL CN 13513161 Jinkuangcun PPL CN 13513164 Laomiaocun PPL CN 13513150 Qinghuacun PPL CN 13513154 Beichengzicun PPL CN 13513151 Shitoucun PPL CN 13513140 Heshengcun PPL CN 13513152 Minzhucun PPL CN 13513145 Tianshancun PPL CN 13513158 Xingfucun PPL CN 13513141 Yaoyinggoucun PPL CN 13513144 Wujiazicun PPL CN 13513142 Cilaoyagoucun PPL CN 13513143 Huojiayingcun PPL CN 13513146 Qingsongcun PPL CN 13513153 Xinhuacun PPL CN 13513147 Zhongdachuancun PPL CN 13513155 Zhongtuncun PPL CN 13513156 Shichengcun PPL CN 13513160 Shenxiandongcun PPL CN 13513157 Xin’ancun PPL CN 13513159 Hongyuncun PPL BV 13513008 Norvegia Station PPL CN 13513162 Taiyangcun PPL CN 13513163 Tongzigoucun PPL HM 13513198 Spit Base PPL null 13513206 Neumayer Station III PPL MX 13513214 Eusebio Fuentes PPL MX 13513572 Las Arboledas Nuevo Algodones PPLX