number of errors=6
number of warnings=0
country=ZA
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='ZA' order by title
[{key=ZA,number=6}]
ZA=http://www.postoffice.co.za/postcodes/postcodesc.pdf
countrycode title placename code dist url wpurl geonameid ZA Bultfontein Bultfontein 9670 4.65 http://nl.wikipedia.org/wiki/Bultfontein http://www.geonames.org/maps/google_-29.14_26.229999999999997.html 1014742 ZA Elliot Elliot 5460 1.24 http://nl.wikipedia.org/wiki/Elliot http://www.geonames.org/maps/google_-31.334166666666665_27.848888888888887.html 1005782 ZA Joubertina Joubertina 6410 4.10 http://nl.wikipedia.org/wiki/Joubertina http://www.geonames.org/maps/google_-33.825_23.85777777777778.html 993613 ZA Klipplaat Klipplaat 6255 2.00 http://nl.wikipedia.org/wiki/Klipplaat http://www.geonames.org/maps/google_-31.018055555555556_24.340277777777775.html 989173 ZA Kranskop Kranskop 3268 4.28 http://nl.wikipedia.org/wiki/Kranskop http://www.geonames.org/maps/google_-28.9667_30.8667.html null ZA Sterkspruit Sterkspruit 9762 6.05 http://en.wikipedia.org/wiki/Sterkspruit http://www.geonames.org/maps/google_-30.529999999999998_27.37361111111111.html 952354