number of errors=0
number of warnings=0
country=US
Group=chkGrpPostalCode
select a.countrycode, a.zip, a.placename,b.placename, a.estlonglat<->b.estlonglat, a.admincode1,a.admincode2 from zip_code a, zip_code b where a.countrycode=b.countrycode and a.zip=b.zip and a.estlonglat<->b.estlonglat>1 and a.placename
https://tools.usps.com/go/ZipLookupAction!input.action
countrycode zip placename placename ?column? admincode1 admincode2