2025-03-04     2025-03-05     2025-03-06

adm4code from zip_code same as adm4 code from geoname table

number of errors=0
number of warnings=0
Group=chkGrpPostalCode

select zip_code.countrycode,placename,zip,geoname.geonameid,geoname.name,zip_code.admincode4,adminname4 from zip_code,geoname where zip_code.geonameid=geoname.geonameid and zip_code.admincode4<>geoname.admincode4 and zip_code.admincode4 is not null and featurecode<>'ADM4H' and not exists (select 1 from qa_exceptions where qa_exceptions.geonameid=geoname.geonameid and qa_exceptions.zip=zip_code.zip and qa_exceptions.key='chkPostalCodeAdmin4CodeEqGeoNameAdm4Code')

[]

countrycode	placename	zip	geonameid	name	admincode4	adminname4