number of errors=239
number of warnings=24
Group=chkGrpPostalCode
select countrycode,geoname.geonameid,geoname.name,featurecode,alternatename.name, case when alternatename.name like '% %' then 'WRN' else 'ERR' end as ERRWRN from alternatename,geoname where alternatename.namelocale='post' and alternatename.geonameid=geoname.geonameid and alternatename.name not like '%CEDEX%' and not exists (select 1 from zip_code where countrycode=geoname.countrycode and alternatename.name=zip) and countrycode in (select distinct countrycode from zip_code) order by countrycode
[{key=DE,number=78}, {key=US,number=47}, {key=BG,number=16}, {key=ES,number=14}, {key=HR,number=11}, {key=BE,number=10}, {key=GU,number=10}, {key=CH,number=9}, {key=IT,number=9}, {key=GR,number=8}, {key=GB,number=7}, {key=LU,number=6}, {key=BR,number=5}, {key=RU,number=5}, {key=IN,number=4}, {key=CN,number=3}, {key=AT,number=2}, {key=MC,number=2}, {key=NL,number=2}, {key=PT,number=2}, {key=TH,number=2}, {key=UA,number=2}, {key=ZA,number=2}, {key=AU,number=1}, {key=BD,number=1}, {key=GP,number=1}, {key=LT,number=1}, {key=LV,number=1}, {key=MA,number=1}, {key=NZ,number=1}]
AT=http://www.post.at/en/post_subsite_postleitzahlfinder.php?
AU=http://auspost.com.au/apps/postcode.html
BD=http://www.bangladeshpost.gov.bd/PostCode.asp
DE=http://www.deutschepost.de/plzsuche/
ES=http://www.correos.es/comun/CodigosPostales/1010_s-CodPostal.asp
HR=http://www.posta.hr/default.aspx?pretpum&tvrsta=mjesto&id=3417
IN=http://www.indiapost.gov.in/
IT=http://poste.it/online/cercacap/home.do
US=https://tools.usps.com/go/ZipLookupAction!input.action
ZA=http://www.postoffice.co.za/postcodes/postcodesc.pdf
countrycode geonameid name featurecode name errwrn AT 7872004 Unterweitersdorf ADM3 4213 ERR AT 2763205 Überackern ADM3 5123 ERR AU 12217997 Aintree PPL 3336 ERR BD 12495186 University of Barishal UNIV 8254 ERR BE 7648909 Brussel X-Luchthaven Remailing ZN 1934 ERR BE 7648068 Promo-Control PO 1414 ERR BE 7647751 FPS Mobility and Transport ADMF 1212 ERR BE 6930381 European Parliament ADMF 1047 ERR BE 7647445 Rtbf BLDG 1044 ERR BE 7648908 Brucargo PPL 1931 ERR BE 7647748 Rtl - Tvi BLDG 1201 ERR BE 7648577 Cargovil PPL 1804 ERR BE 6695079 NATO ZN 1110 ERR BE 7648578 VTM PPL 1818 ERR BG 12188474 Policonsult Ltd. TWO 1415 ERR BG 12954205 Pizza Box BLDG 1421 ERR BG 12226376 Health Zone CTRM 6003 ERR BG 732480 Chestimensko PPL 9469 ERR BG 12226374 Omron Healthcare Bulgaria by DINI OTC Ltd CTRM 1510 ERR BG 11995142 Tessto REST 9010 ERR BG 12238271 Black Sea - Hall of Creativity CTRF 9010 ERR BG 12188473 Policonsult Ltd. TWO 9009 ERR BG 12200003 Poli-fresh BLDO 9009 ERR BG 12176060 Crown Paints Varna RET 9002 ERR BG 13132303 Yanko Yankov, MD, PhD HSPC 9005 ERR BG 13060870 Arette Beauty Studio BLDG 1421 ERR BG 12688955 Роден Дом 85 ЕООД BLDG 9009 ERR BG 12129528 Pixhold Photo & Video BLDG 1612 ERR BG 12226375 DINI OTC Ltd CTRM 9009 ERR BG 12954399 Restaurant 507 BLDG 1415 ERR BR 3448439 São Paulo PPLA 01331-000 ERR BR 3448439 São Paulo PPLA 82010-340 ERR BR 3448439 São Paulo PPLA 22640-101 ERR BR 8644045 Rua Jose Neves Cypreste ST 29060-300 ERR BR 10177376 Promtec - Bobinas, Etiquetas Adesivas, Tags e Ribbons MFG 13030-405 ERR CH 8478285 Obersaxen Giraniga PPL 7135 ERR CH 8478300 Untervaz Bahnhof PPL 7201 ERR CH 6292521 Faltigberg PPL 8639 ERR CH 7670048 Affeier PPL 7133 ERR CH 2661513 Biel/Bienne PPLA2 2510 ERR CH 2661682 Augio PPL 6547 ERR CH 8469279 Ponte Cremenaga PPL 6996 ERR CH 7287373 Unterbözberg ADM3H 5224 ERR CH 8478286 Obersaxen Friggahüs PPL 7136 ERR CN 11822707 DoubleTree by Hilton Hotel Shenzhen Longhua HTL 518131 ERR CN 7304087 Citic Square MALL 200041 ERR CN 7306540 Pacific Place MALL 111111 ERR DE 3213266 Despetal ADM4H 31035 ERR DE 2866753 Neckarwestheim PPLA4 74380 ERR DE 2921228 Geraberg PPLA4 99331 ERR DE 2851826 Prüm PPL 54592 ERR DE 2929670 Erfurt PPLA 99090 ERR DE 2879139 Leipzig PPLA3 04135 ERR DE 2928810 Essen PPLA3 45001 ERR DE 6557657 Bad Wünnenberg ADM4 33182 ERR DE 2818653 Unterstadion PPLA4 88619 ERR DE 2826336 Stotternheim PPLX 99095 ERR DE 2870701 Mittelhausen PPLX 99095 ERR DE 6558796 Marktschellenberg, Markt ADM4 04466 ERR DE 2871244 Midlum PPLA4 27632 ERR DE 2812104 Weischlitz PPLA4 08121 ERR DE 11856394 Oberzent ADM4 64760 ERR DE 2878350 Leuna PPL 06236 ERR DE 2929670 Erfurt PPLA 99095 ERR DE 2885679 Konstanz PPLA3 78432 ERR DE 2842144 Salzhausen PPLA4 21372 ERR DE 2886242 Köln PPLA2 50861 ERR DE 2935494 Dorum PPLA4 27632 ERR DE 2848762 Reinheim PPL 64348 ERR DE 2870962 Misselwarden PPLA4 27632 ERR DE 2925533 Frankfurt am Main PPLA3 60559 ERR DE 2925533 Frankfurt am Main PPLA3 60552 ERR DE 2861650 Nürnberg PPLA3 90126 ERR DE 2879139 Leipzig PPLA3 04303 ERR DE 2907887 Heidenau PPL 01827 ERR DE 2803606 Zweifelscheid PPLA4 04439 ERR DE 2873352 Markkleeberg PPL 04445 ERR DE 2851113 Rackwitz PPLA4 04448 ERR DE 2951711 Beckeln PPLA4 04454 ERR DE 2843667 Rottleberode PPLX 06548 ERR DE 2837085 Schönau am Königssee PPL 08129 ERR DE 2901420 Hohenstein-Ernstthal PPL 09358 ERR DE 2933994 Eberholzen PPLA4 31035 ERR DE 2822881 Theißen PPLX 06711 ERR DE 2891621 Kempten (Allgäu) PPL 87434 ERR DE 2861632 Nürtingen PPL 79852 ERR DE 2929671 Erftstadt PPLA4 50371 ERR DE 2947416 Bochum PPLA3 44719 ERR DE 2925549 Frankenthal PPL 96529 ERR DE 2913571 Günthersdorf PPLX 04430 ERR DE 2851077 Radebeul PPL 01462 ERR DE 2836658 Schönfeld PPLA4 01474 ERR DE 2856107 Ottendorf-Okrilla PPLA4 01478 ERR DE 2901405 Hohentengen PPLA4 08138 ERR DE 2842688 Saalfeld PPLA3 08358 ERR DE 2863429 Niederfrohna PPLA4 08399 ERR DE 2940993 Burkhardtsdorf PPLA4 09240 ERR DE 2803798 Zschopau PPL 09434 ERR DE 2833296 Selb PPL 09636 ERR DE 6547647 Schöneiche bei Berlin ADM4 12625 ERR DE 2804646 Zeuthen PPLA4 15751 ERR DE 2885732 Königs Wusterhausen PPL 15758 ERR DE 2822029 Todendorf PPLA4 22961 ERR DE 2807647 Winzenburg PPLA4 31087 ERR DE 2959686 Achern PPL 77841 ERR DE 3274969 Hesseneck PPLA4 64759 ERR DE 2871958 Mengersgereuth-Hämmern PPLX 96529 ERR DE 2876215 Lohme PPL 99843 ERR DE 2926688 Finsterbergen PPLX 99898 ERR DE 2832495 Siegen PPLA3 57087 ERR DE 6559102 Gronau (Westf.) ADM4 48585 ERR DE 2861650 Nürnberg PPLA3 90442 ERR DE 2858763 Obertshausen PPL 64179 ERR DE 2809889 Wetzlar PPLA3 35537 ERR DE 2918987 Görlitz PPLA3 02628 ERR DE 2934246 Düsseldorf PPLA 40469 ERR DE 2920999 Gernrode PPLX 06485 ERR DE 2918321 Gräfenhainichen PPL 06772 ERR DE 2911298 Hamburg PPLA 22539 ERR DE 2908032 Heide PPLA3 25743 ERR DE 2891122 Kiel PPLA 24110 ERR DE 6557140 Kleinaitingen ADM4 86907 ERR DE 2929747 Erbshausen PPLX 96262 ERR DE 3274970 Sensbachtal ADM4H 64759 ERR DE 11696185 Argenbühl PPL 88620 ERR ES 3117735 Madrid PPLC 28000 ERR ES 3110727 San Cristóbal de la Polantera PPLA3 24359 ERR ES 13192192 Urbanizacion Casas Viejas PPLA3 02099 ERR ES 13192193 La Poblachuela PPLA3 13197 ERR ES 6324533 Santa Ponsa PPL 07182 ERR ES 3107775 Torrelavega PPL 39317 ERR ES 3115394 Nogueira de Ramuín PPLA3 32162 ERR ES 2515493 Las Cabezas de San Juan PPL 41729 ERR ES 2516443 Ingenio PPLA3 35000 ERR ES 3107574 Trasmiras PPLA3 32694 ERR ES 3114649 Padrenda PPLA3 32220 ERR ES 6360669 Cillorigo de Liébana ADM3 39585 ERR ES 2518399 El Jardín PPL 02330 ERR ES 2522265 Alarcón PPLA3 16213 ERR GB 11591736 Hackenthorpe PPL S12 ERR GB 12036330 Cessnock PPL G511 ERR GB 12036330 Cessnock PPL G512 ERR GB 10107877 Hampton by Hilton London Luton Airport HTL LU2 0NB WRN GB 7304578 Trinity Leeds MALL LS1 6QN WRN GB 7304585 The Trafford Centre MALL M17 8AF WRN GB 7304577 Silverburn MALL G53 6QR WRN GP 3579158 Gros Morne PPL 97213 ERR GR 735241 Melánthio PPL 572 00 WRN GR 734088 Theodhósia PPL 572 00 WRN GR 736327 Ellinikón PPL 572 00 WRN GR 734392 Rizaná PPL 572 00 WRN GR 255638 Pelasgía PPL 351 32 WRN GR 8358616 Ampelókipoi PPLA3 561 21 WRN GR 8358616 Ampelókipoi PPLA3 561 23 WRN GR 736097 Ísoma PPL 572 00 WRN GU 4043499 Inarajan Village PPLA 96917 PO BOX WRN GU 7874008 Hagåtña Village PPL 96932 PO BOX WRN GU 4043909 Dededo Village PPLA 96912 PO BOX WRN GU 4043656 Barrigada Village PPLA 96921 PO BOX WRN GU 4044012 Hagåtña PPLC 96932 PO BOX WRN GU 7268049 Mangilao Village PPLA 96923 PO BOX WRN GU 4043399 Merizo Village PPLA 96916 PO BOX WRN GU 7874631 Tamuning PPLX 96931 PO BOX WRN GU 4038659 Tamuning-Tumon-Harmon Village PPLA 96931 PO BOX WRN GU 4043804 Agat Village PPLA 96928 PO BOX WRN HR 3201092 Duboka PPL 34350 ERR HR 3203680 Borovik PPL 31418 ERR HR 3201423 Okrug Donji PPL 51317 ERR HR 3202512 Cret Bizovački PPL 31222 ERR HR 3201320 Draganići PPLA2 47201 ERR HR 3282309 Grabovci PPL 22215 ERR HR 3343490 Ferenci PPL 52447 ERR HR 3202769 Čemernica Lonjska PPL 10312 ERR HR 3213246 Cicvare PPL 22214 ERR HR 3189452 Šušnjari PPL 10314 ERR HR 3199399 Sveta Helena PPL 10382 ERR IN 8593724 Thumha PPL 852159 ERR IN 11000670 NaimNagar AREA 546009 ERR IN 10097564 DoubleTree by Hilton Hotel Goa - Arpora - Baga HTL 403518 ERR IN 10111630 Hilton Garden Inn Trivandrum HTL 695039 ERR IT 3168488 San Cataldo PPL 41123 ERR IT 3173331 Modena PPLA2 41123 ERR IT 3174664 Livigno PPLA3 23041 ERR IT 3169755 Punta Marina PPL 48121 ERR IT 3169755 Punta Marina PPL 48122 ERR IT 3169755 Punta Marina PPL 48123 ERR IT 3169755 Punta Marina PPL 48124 ERR IT 3169755 Punta Marina PPL 48125 ERR IT 3172968 Montecopiolo ADM3H 47868 ERR LT 596659 Nemirseta PPL LT-00153 ERR LU 2960054 Strassen PPLA3 L-1019 ERR LU 2960596 Esch-sur-Alzette PPLA2 L-4056 ERR LU 2960731 Boxhorn PPL L-9741 ERR LU 2960280 Mensdorf PPL L-6918 ERR LU 2960268 Meysembourg PPL L-7461 ERR LU 6296718 Luxembourg Findel Airport AIRP L-1110 ERR LV 10860664 Ss. Boris and Gleb Cathedral, Daugavpils CH LV-5400 ERR MA 11592204 Hilton Tangier City Center HTL 90000 ERR MC 8298440 Bureau de Poste de Monte Carlo Larvotto PO 98001 ERR MC 8298439 Bureau de Poste de Monaco Herculis PO 98020 ERR NL 12036153 De Kleikervennen HTH 8412 LW WRN NL 12036154 L.W. Kleikerbos FRST 8412 LW WRN NZ 6232069 Flat Bush LCTY 2019 ERR PT 12047290 Ribeira de Elos PPL 5050-565 ERR PT 12110883 Seixas Pharmacy HSPD 5000-143 ERR RU 506205 Porozovo PPL 155420 ERR RU 463738 Zelyony Gorod PPL 603121 ERR RU 11280178 Innopolis PPL 420500 ERR RU 6607332 Berëzovka PPL 607638 ERR RU 506310 Porech’ye PPL 249072 ERR TH 9883433 Hilton Pattaya HTL 20260 ERR TH 6966707 Ongkan Borihan Suan Tambon Thung Mo GOVL 90240 ERR UA 11151573 Bozhedarivka PPL 52308 ERR UA 700569 Mykolayiv PPLA 54000 ERR US 4139714 National Archives Building ARCHV 20408-0001 ERR US 4366728 Richard Montgomery High School SCH 20852-1147 ERR US 4778797 Piedmont Virginia Community College SCH 22902-7589 ERR US 5375945 Museum of Contemporary Art MUS 90012-3007 ERR US 4362729 Montgomery Hills Baptist Church CH 20910-1458 ERR US 4140722 Thomas Jefferson Building BLDG 20540-4660 ERR US 5112380 Chautauqua Institution null 14722-0028 ERR US 4945841 Northborough Free Library LIBR 01532-1942 ERR US 5353996 Greek Theater BLDG 90027-1247 ERR US 5575878 Colorado State University SCH 80523-0100 ERR US 4364132 Noyes Library for Young Children LIBR 20895-3361 ERR US 4215676 Piedmont College SCH 30535-0010 ERR US 7725244 John Brown Museum MUS 66064-0037 ERR US 4372686 Walt Whitman High School SCH 20817-6199 ERR US 4140423 School of International Service SCH 20016-8003 ERR US 4359528 Johns Hopkins University SCH 21218-2688 ERR US 8109027 Prescott Public Library LIBR 86303-3998 ERR US 7236278 Mendocino College - Coast Center SCH 95437-5668 ERR US 5409503 Mendocino College - North County Center SCH 95490-3202 ERR US 6341576 Hammond-Harwood House BLDG 21401-1626 ERR US 4349171 Bowie State University UNIV 20715-9465 ERR US 4372151 University of Maryland School of Medicine SCH 21201-1559 ERR US 5324889 United States Postal Service Office, Artois PO 35913 ERR US 5848111 US Post Office Waimea (Kamuela PO) PO 97643 ERR US 7228019 US Post Office, Newington PO 30446-9998 ERR US 5360932 John Muir Branch Los Angeles Public Library LIBR 90044-3605 ERR US 5110266 The Bronx PPLA2 10499 ERR US 4496357 University of North Carolina - Greensboro SCH 27402-6170 ERR US 4356060 Germantown Library LIBR 20874-2672 ERR US 4361119 Long Branch Library LIBR 20901-3834 ERR US 4347554 Aspen Hill Library LIBR 20853-2829 ERR US 6340085 Clarice Smith Performing Arts Center BLDG 20742-1625 ERR US 4374097 Woodmoor Post Office PO 20901-9998 ERR US 4366992 Robert Frost Middle School SCH 20850-3441 ERR US 4897746 Janme Addams Hull House BLDG 60607-7017 ERR US 4095104 University of South Alabama SCH 36688-0002 ERR US 4350021 Cabin John Middle School SCH 20854-4000 ERR US 4364544 Olney Library LIBR 20832-1798 ERR US 4352835 Davis Library LIBR 20817-1638 ERR US 4960345 Cary Library LIBR 04730-2196 ERR US 5489053 Saint Johns College SCH 87505-4599 ERR US 5258137 Craig High School SCH 53545-4398 ERR US 5779999 Primary Children's Medical Center HSP 84113-1100 ERR US 7136090 National Labor College SCH 20903-1706 ERR US 5377658 North Hollywood Regional Branch Los Angeles Public Library LIBR 91601-3119 ERR US 7167991 Nationals Park STDM 20003-1507 ERR US 12501251 Old Gold RET 95460-9203 ERR ZA 3359957 Villiersdorp PPL 6848 ERR ZA 1020992 Barrydale PPL 6750 ERR