number of errors=3
number of warnings=0
country=NL
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='NL' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap NL Kapel Avezaath 336 1 4013 http://www.geonames.org/maps/google_51.88451597458296_5.3835398016288964.html NL Leidschendam 172 1 2267 http://www.geonames.org/maps/google_52.05869279767665_4.356754671157021.html NL Kerk Avezaath 41 1 4017 http://www.geonames.org/maps/google_51.890423330553126_5.3949303246639095.html