number of errors=7
number of warnings=0
country=LU
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='LU' order by numaddresses desc
countrycode place numaddresses l pc1 gnmap LU Blumenthal (Bech) 14 1 L-7639 http://www.geonames.org/maps/google_49.744870086470016_6.265875601374405.html LU Graulinster (Bech) 11 1 L-6240 http://www.geonames.org/maps/google_49.742537398236465_6.289602423574994.html LU Lehrhof 8 1 L-9144 http://www.geonames.org/maps/google_49.85848247161537_5.941550761307064.html LU Itzig 6 1 L-5280 http://www.geonames.org/maps/google_49.601400080908476_6.205474636890478.html LU Beringen 5 1 L-7409 http://www.geonames.org/maps/google_49.77026844982806_6.1510279485865915.html LU Grundhof (Berdorf) 4 1 L-6360 http://www.geonames.org/maps/google_49.83223534706068_6.3304789998539945.html LU Kalkesbach (Consdorf) 3 1 L-6214 http://www.geonames.org/maps/google_49.80037966348516_6.3532158525934515.html