number of errors=13
number of warnings=0
Group=chkGrpBBox
Group=chkGrpPostalCode
select zip_code.countrycode,zip,placename,zip_code.geonameid,admincode1,admincode2,admincode3,admin1geonameid,st_distance(geography::geometry,wkb_geometry) as dist,'http://www.geonames.org/maps/google_' || estlonglat[1] || '_' || estlonglat[0] || '.html' as gnurl from zip_code,geoname_bbox b where admin1geonameid=b.geonameid and not st_within(geography::geometry,wkb_geometry) and zip_code.countrycode in ('PR') order by countrycode
[{key=PR,number=13}]
countrycode zip placename geonameid admincode1 admincode2 admincode3 admin1geonameid dist gnurl PR 00978 St Just null 139 null null 4568452 0.016930009033968352 http://www.geonames.org/maps/google_18.378559983333336_-66.04998061666667.html PR 00740 Puerto Real null 053 null null 4564949 0.026551323681361077 http://www.geonames.org/maps/google_18.2499612_-65.74927275.html PR 00765 Vieques null 147 null null 4568924 0.6656625535334519 http://www.geonames.org/maps/google_18.085888066666666_-66.24313083333332.html PR 00950 Toa Baja 4568407 137 null null 4568408 0.0007196812688876214 http://www.geonames.org/maps/google_18.4438353_-66.2596126.html PR 00704 Aguirre 8335063 057 null null 4565107 0.0493392059965475 http://www.geonames.org/maps/google_17.95293307437774_-66.26197814941406.html PR 00934 Fort Buchanan 8335065 021 null null 4562837 3.333935015267252e-05 http://www.geonames.org/maps/google_18.412151794706237_-66.12207412719727.html PR 00981 Carolina 4563243 127 null null 4568138 0.03833842071437495 http://www.geonames.org/maps/google_18.3807819_-65.9573872.html PR 00979 Carolina 4563243 127 null null 4568138 0.03833842071437495 http://www.geonames.org/maps/google_18.3807819_-65.9573872.html PR 00982 Carolina 4563243 127 null null 4568138 0.03833842071437495 http://www.geonames.org/maps/google_18.3807819_-65.9573872.html PR 00951 Toa Baja 4568407 137 null null 4568408 0.0007196812688876214 http://www.geonames.org/maps/google_18.4438353_-66.2596126.html PR 00949 Toa Baja 4568407 137 null null 4568408 0.0007196812688876214 http://www.geonames.org/maps/google_18.4438353_-66.2596126.html PR 00968 Guaynabo 4565119 127 null null 4568138 0.01320302176925454 http://www.geonames.org/maps/google_18.3574502_-66.1109998.html PR 00785 Guayama 4565105 059 null null 4565112 0.6201174250219237 http://www.geonames.org/maps/google_17.9841328_-66.1137767.html