convex hull from addresses has geonameid

number of errors=0
number of warnings=0
country=CX
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='CX' order by numaddresses desc

countrycode	place	numaddresses	l	pc1	gnmap