number of errors=31
number of warnings=0
country=IS
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='IS' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap IS Reykjavík - 1 3505 1 101 http://www.geonames.org/maps/google_64.14023316532815_-21.939274212991876.html IS Reykjavík - 12 3300 1 112 http://www.geonames.org/maps/google_64.14628514579577_-21.787654557734037.html IS Reykjavík - 8 2577 1 108 http://www.geonames.org/maps/google_64.12606684940015_-21.876059458473783.html IS Reykjavík - 10 2432 1 110 http://www.geonames.org/maps/google_64.09696433082146_-21.771854721669477.html IS Reykjavík - 5 2155 1 105 http://www.geonames.org/maps/google_64.13901185175776_-21.900897166374975.html IS Reykjavík - 9 1954 1 109 http://www.geonames.org/maps/google_64.1036209204356_-21.837271546423803.html IS Reykjavík - 4 1707 1 104 http://www.geonames.org/maps/google_64.14421658904526_-21.856048725368336.html IS Reykjavík - 13 1363 1 113 http://www.geonames.org/maps/google_64.1212896837407_-21.729005948594867.html IS Reykjavík - 7 1099 1 107 http://www.geonames.org/maps/google_64.14454502048004_-21.964747385271657.html IS Mosfellsbæ 967 1 276 http://www.geonames.org/maps/google_64.31135943802902_-21.515008866331733.html IS Reykjavík - 11 940 1 111 http://www.geonames.org/maps/google_64.10590655564657_-21.81674089627307.html IS Reykholt í Borgarfirði 870 1 320 http://www.geonames.org/maps/google_64.67467601404228_-21.207640263972653.html IS Ãlfus 611 1 816 http://www.geonames.org/maps/google_63.94573599221839_-21.354349916139817.html IS Ólafsfirði 537 1 625 http://www.geonames.org/maps/google_66.03699371705626_-18.72145824938139.html IS Mývatni 385 1 660 http://www.geonames.org/maps/google_65.36457784690603_-16.590701808479487.html IS Snæfellsbæ 377 1 356 http://www.geonames.org/maps/google_64.82921111451832_-23.445593141041936.html IS Keflavíkurflugvelli 358 1 235 http://www.geonames.org/maps/google_63.98146348840279_-22.619309434646475.html IS Reykhólahreppi 343 1 380 http://www.geonames.org/maps/google_65.50967767113865_-22.484651856628002.html IS Reykjavík - 3 294 1 103 http://www.geonames.org/maps/google_64.12675939409176_-21.89347451165841.html IS Ísafirði 282 1 401 http://www.geonames.org/maps/google_66.1771167495553_-22.683975203668798.html IS Stað 204 1 500 http://www.geonames.org/maps/google_65.3034639364362_-21.22822616264086.html IS Fljótum 179 1 570 http://www.geonames.org/maps/google_66.02453975436934_-19.077881108066265.html IS Borgarfirði (eystri) 149 1 720 http://www.geonames.org/maps/google_65.44889755707736_-13.797377463887438.html IS Öræfum 109 1 785 http://www.geonames.org/maps/google_63.912393773040066_-16.795015792967238.html IS Norðurfirði 107 1 524 http://www.geonames.org/maps/google_66.04821454833696_-21.578452497303342.html IS Fosshólli 103 1 645 http://www.geonames.org/maps/google_65.2901579071151_-17.408549643070923.html IS Reykjanesbæ 101 1 233 http://www.geonames.org/maps/google_63.886283911874294_-22.64855458282282.html IS Laugum 70 1 650 http://www.geonames.org/maps/google_65.7221342252074_-17.361541941994545.html IS Hólmavík 69 1 512 http://www.geonames.org/maps/google_65.89770631013857_-22.383435597817357.html IS Flatey á Breiðafirði 53 1 345 http://www.geonames.org/maps/google_65.40540330303729_-22.778031502229947.html IS Mjóafirði 47 1 715 http://www.geonames.org/maps/google_65.21550626276198_-13.772663604963977.html