number of errors=3
number of warnings=0
country=US
Group=chkGrpPostalCode
Group=ckgGrpWP
select distinct zip_code.countrycode,wp_postalcode.title,placename,code,to_char(longlat<->estlonglat,'99.99') as dist,url,'http://www.geonames.org/maps/google_' || wp_postalcode.longlat[1] || '_' || wp_postalcode.longlat[0] || '.html' as wpurl,zip_code.geonameid from wp_postalcode_code,wp_postalcode,zip_code where wp_postalcode.wikipediaid=wp_postalcode_code.wikipediaid and wp_postalcode.language=wp_postalcode_code.language and code=zip and wp_postalcode.countrycode=zip_code.countrycode and longlat<->estlonglat>1 and title=placename and iswithinccbounds and zip_code.countrycode='US' order by title
[{key=US,number=3}]
US=https://tools.usps.com/go/ZipLookupAction!input.action
countrycode title placename code dist url wpurl geonameid US Bogue Chitto Bogue Chitto 39629 2.07 http://it.wikipedia.org/wiki/Bogue_Chitto http://www.geonames.org/maps/google_32.829722_-88.92.html 4418952 US Daisytown Daisytown 15427 1.09 http://es.wikipedia.org/wiki/Daisytown http://www.geonames.org/maps/google_40.319722222222225_-78.90027777777779.html 5186248 US Woody Creek Woody Creek 81656 8.80 http://es.wikipedia.org/wiki/Woody_Creek http://www.geonames.org/maps/google_36.175_-115.1363888888889.html 5444723