number of errors=31
number of warnings=0
country=CH
Group=chkGrpPostalCode
Group=chkGrpShp
select countrycode,place,numaddresses,array_length(postalcodes,1) as l,postalcodes[1] as pc1,'http://www.geonames.org/maps/google_' || st_y(st_centroid(wkb_geometry)) || '_' || st_x(st_centroid(wkb_geometry)) || '.html' as gnmap from addr_hull_place where geonameid is null and countrycode='CH' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap CH Amlikon-Bissegg 1000 1 8514 http://www.geonames.org/maps/google_47.55988246531725_9.034686654853443.html CH Jouxtens-Mézery 495 1 1008 http://www.geonames.org/maps/google_46.550431542258494_6.595910884660886.html CH Lausanne 26 431 1 1000 http://www.geonames.org/maps/google_46.553399379371065_6.694930314697215.html CH Lutzenberg 316 1 9426 http://www.geonames.org/maps/google_47.4592215017701_9.575010513202182.html CH Full-Reuenthal 315 1 5324 http://www.geonames.org/maps/google_47.61017692816957_8.204367224967537.html CH Laax GR 2 310 1 7032 http://www.geonames.org/maps/google_46.845507813974_9.230789101411975.html CH Sternenberg 248 1 8499 http://www.geonames.org/maps/google_47.387915466924774_8.914325689131095.html CH Unterlangenegg 236 1 3614 http://www.geonames.org/maps/google_46.79889816727106_7.693022941330953.html CH Lausanne 25 219 1 1000 http://www.geonames.org/maps/google_46.55464902679694_6.677465904816911.html CH Silvaplana-Surlej 210 1 7513 http://www.geonames.org/maps/google_46.44439137732235_9.819911835200804.html CH Kefikon TG 169 1 8546 http://www.geonames.org/maps/google_47.54981818927_8.834097394826046.html CH Schmiedrued 155 1 5046 http://www.geonames.org/maps/google_47.26714195357684_8.112582867584138.html CH Aeugstertal 147 1 8914 http://www.geonames.org/maps/google_47.280416592319256_8.489048239064463.html CH Simplon Hospiz 134 1 3907 http://www.geonames.org/maps/google_46.24292769274021_8.022105106858575.html CH Lausanne 27 124 1 1000 http://www.geonames.org/maps/google_46.5412460387337_6.681504057300857.html CH Lussery-Villars 123 1 1307 http://www.geonames.org/maps/google_46.63201956994143_6.524752749473408.html CH Längenbühl 118 1 3636 http://www.geonames.org/maps/google_46.75653737427376_7.53692076070225.html CH Mur (Vully) VD 110 1 1787 http://www.geonames.org/maps/google_46.94118401464486_7.055325531185289.html CH Golaten 105 1 3207 http://www.geonames.org/maps/google_46.98750827786813_7.238300273416782.html CH Müllheim-Wigoltingen 87 1 8554 http://www.geonames.org/maps/google_47.589442550549485_9.013592354247129.html CH Signèse (Ayent) 84 1 1966 http://www.geonames.org/maps/google_46.276469830542695_7.406596997976322.html CH Biogno-Beride 82 1 6981 http://www.geonames.org/maps/google_45.99840860559605_8.83770451890065.html CH Vugelles-La Mothe 73 1 1431 http://www.geonames.org/maps/google_46.821985150007585_6.573047590143016.html CH Genève 15 Aéroport 66 1 1215 http://www.geonames.org/maps/google_46.23541540875203_6.107808389672783.html CH Abländschen 56 1 1657 http://www.geonames.org/maps/google_46.56589773238578_7.2804538727454435.html CH Pierrafortscha 51 1 1723 http://www.geonames.org/maps/google_46.780277862292394_7.180018105153726.html CH Rueyres-Treyfayes 39 1 1626 http://www.geonames.org/maps/google_46.646789985909464_6.9545053522127445.html CH Mont-Tramelan 36 1 2723 http://www.geonames.org/maps/google_47.20768734064433_7.063582295939528.html CH La Verrerie 35 1 1624 http://www.geonames.org/maps/google_46.59446604794922_6.928421683774864.html CH Fontaine Dessous (Liddes) 18 1 1945 http://www.geonames.org/maps/google_46.01230638943394_7.166466931322758.html CH Lucelle 6 1 2807 http://www.geonames.org/maps/google_47.421383381314506_7.243330096410489.html