2025-03-01     2025-03-02     2025-03-03

convex hull from addresses has geonameid

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

countrycode	place	numaddresses	l	pc1	gnmap