number of errors=29
number of warnings=0
Group=chkGrpPostalCode
select geoname.countrycode,geoname.admincode1,geoname.geonameid,geoname.name,placename,zip,zip_code.admincode1,longlat<->estlonglat as dist,'http://www.geonames.org/maps/google_' || estlonglat[1] || '_' || estlonglat[0] || '.html' as gnurl from geoname,zip_code,alternatename where geoname.geonameid=alternatename.geonameid and alternatename.namelocale='post' and alternatename.name=zip and geoname.name=placename and geoname.countrycode=zip_code.countrycode and longlat<->estlonglat>1 order by geoname.countrycode
[{key=ES,number=9}, {key=IT,number=4}, {key=MX,number=3}, {key=US,number=3}, {key=DE,number=2}, {key=GB,number=2}, {key=MH,number=2}, {key=CA,number=1}, {key=IN,number=1}, {key=LV,number=1}, {key=RO,number=1}]
CA=http://www.canadapost.ca/cpotools/apps/fpc/personal/findByCity?execution=e2s1
DE=http://www.deutschepost.de/plzsuche/
ES=http://www.correos.es/comun/CodigosPostales/1010_s-CodPostal.asp
IN=http://www.indiapost.gov.in/
IT=http://poste.it/online/cercacap/home.do
US=https://tools.usps.com/go/ZipLookupAction!input.action
countrycode admincode1 geonameid name placename zip admincode1 dist gnurl CA 10 6138980 Saint-Raymond Saint-Raymond G3L QC 2.4775338432971052 http://www.geonames.org/maps/google_47.237399764830705_-71.87633405685442.html DE 07 2943320 Brühl Brühl 68782 BW 2.1686827289584714 http://www.geonames.org/maps/google_49.3972222_8.5336111.html DE 01 2875909 Lorch Lorch 65391 HE 2.262468965092185 http://www.geonames.org/maps/google_50.046194_7.804182.html ES 58 3119841 A Coruña A Coruña 15070 GA 1.1585465322756971 http://www.geonames.org/maps/google_42.374921_-7.804934.html ES 58 3119841 A Coruña A Coruña 15071 GA 1.1585465322756971 http://www.geonames.org/maps/google_42.374921_-7.804934.html ES 58 3119841 A Coruña A Coruña 15080 GA 1.1585465322756971 http://www.geonames.org/maps/google_42.374921_-7.804934.html ES 56 3105809 Vilarrodona Vilarrodona 17851 CT 1.5611018954742826 http://www.geonames.org/maps/google_42.21826715358368_2.63038042679861.html ES 56 3110109 Sant Ponç Sant Ponç 25290 CT 1.1085017776096628 http://www.geonames.org/maps/google_41.96204_1.60233.html ES 53 2515548 La Rosa La Rosa 35479 CN 2.085820937906041 http://www.geonames.org/maps/google_27.9881866210742_-15.7959365844727.html ES 53 2518250 El Pinillo El Pinillo 35479 CN 2.2951971168652667 http://www.geonames.org/maps/google_27.977544289590103_-15.777069290636147.html ES 51 8604691 Huertos Familiares San Fernando Huertos Familiares San Fernando 14600 AN 1.384016007113357 http://www.geonames.org/maps/google_38.218961_-2.980695.html ES 56 3114481 Palou Palou 25211 CT 1.0594708230625027 http://www.geonames.org/maps/google_41.81786009262823_1.2506672952795532.html GB ENG 2645411 Kington Kington HR5 ENG 1.00887332901676 http://www.geonames.org/maps/google_52.2040825186946_-3.02553176879883.html GB ENG 2634868 Wallington Wallington SM6 ENG 1.1329659257404876 http://www.geonames.org/maps/google_51.35_-0.15.html IN 40 7302806 Bellampalli Bellampalli 504251 40 1.0277376747122822 http://www.geonames.org/maps/google_19.515778729836136_78.57395431622608.html IT 15 2523890 Pantelleria Pantelleria 91017 15 1.4047393245860789 http://www.geonames.org/maps/google_38.00487481470287_12.713643106757237.html IT 13 3173699 Mattinata Mattinata 71030 13 1.0030368041054016 http://www.geonames.org/maps/google_41.53234977484023_15.063893180923769.html IT 15 2524459 Lampedusa Lampedusa 92010 15 2.1383581304323083 http://www.geonames.org/maps/google_37.51602715014869_13.326527989907861.html IT 15 2522818 Ustica Ustica 90010 15 1.0437978806411419 http://www.geonames.org/maps/google_37.97495889675621_13.934185297332759.html LV AN 10860650 Egļukalns Egļukalns LV-4580 03 1.7006765458464217 http://www.geonames.org/maps/google_57.21985811111111_27.36875033333333.html MH 190 2113779 Majuro Majuro 96960 68 6.411671855485676 http://www.geonames.org/maps/google_11.140496_166.410291.html MH 150 6806225 Ebeye Ebeye 96970 68 2.7092712882109566 http://www.geonames.org/maps/google_11.140496_166.410291.html MX 20 3801459 Francisco Villa Francisco Villa 71230 20 1.370994857860531 http://www.geonames.org/maps/google_17.019021221878308_-96.748595246306.html MX 12 3821794 Vista Hermosa Vista Hermosa 40906 12 1.5125298833829497 http://www.geonames.org/maps/google_17.405961345865318_-100.74443678520487.html MX 12 4027593 El Cantón El Cantón 39937 12 1.4869535666721005 http://www.geonames.org/maps/google_16.957296459332824_-99.71434973508067.html RO 20 674294 Lupeni Lupeni 335600 21 2.2272170667180493 http://www.geonames.org/maps/google_45.36028749590424_23.23831558227539.html US NM 5474906 La Madera La Madera 87539 NM 1.2598729600462941 http://www.geonames.org/maps/google_36.465416_-106.578513.html US AR 4124358 Oak Grove Oak Grove 72660 AR 1.1994855798002992 http://www.geonames.org/maps/google_36.461347_-93.432129.html US AK 8605009 Denali National Park Denali National Park 99755 AK 1.7369362471870022 http://www.geonames.org/maps/google_63.543571_-149.986676.html