number of errors=4
number of warnings=0
country=DK
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='DK' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap DK Thyholm 2758 1 7790 http://www.geonames.org/maps/google_56.63978274121555_8.536651801918941.html DK Veksø Sjælland 1385 1 3670 http://www.geonames.org/maps/google_55.756957114998_12.227695222797733.html DK Ørum Djurs 1072 1 8586 http://www.geonames.org/maps/google_56.445630376495146_10.655348665675737.html DK Askø-Lilleø 338 1 4942 http://www.geonames.org/maps/google_54.899367891458596_11.490420016447214.html