2025-03-05     2025-03-06     2025-03-07

admincode1 of postal code record different from admincode1 from linked geoname feature

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

select zip_code.countrycode,zip,placename,zip_code.admincode1,geoname.geonameid,name,geoname.admincode1 from geoname,zip_code where geoname.geonameid=zip_code.geonameid and zip_code.countrycode='GB' and geoname.geonameid not in (2653256,2640646,2641696,2645155,2653228,2639123,2635936,11593295,2639924,12261572,12266578,2643895) and geoname.admincode1<>zip_code.admincode1 order by 1,2

countrycode	zip	placename	admincode1	geonameid	name	admincode1