number of errors=0
number of warnings=0
country=DE
select geonameid,name,featurecode,countrycode,admincode1,admincode2 from geoname where countrycode='DE' and admincode1 in ('03','04','06','08','09','10','11','12','13','14','15','16') and (admincode2 is null or admincode2 <>'00') and admincode3 is not null
update geoname set admincode2='00' where countrycode='DE' and admincode1 in ('03','04','06','08','09','10','11','12','13','14','15','16') and (admincode2 is null or admincode2 <>'00') and admincode3 is not null;
geonameid name featurecode countrycode admincode1 admincode2