number of errors=5
number of warnings=0
Group=chkGrpShp
Group=ckgGrpIsland
select geoname.countrycode,geoname.geonameid,geoname.name,geoname.featureclass,geoname.featurecode,st_distance(geography,wkb_geometry::geography), 'http://map.immofacts.ch/shape/' || geoshapeid || '/' as shape,relevance from geoname,geoname_shape where geoname.geonameid=geoname_shape.geonameid and geoname.featureclass='T' and geoname.featurecode='ISL' and not st_within(geography::geometry,wkb_geometry) order by relevance desc
[{key=MX,number=5}]
countrycode geonameid name featureclass featurecode st_distance shape relevance MX 3516214 Isla el Té T ISL 596.19229817 http://map.immofacts.ch/shape/726182/ 5 MX 3522896 Isla la Mula T ISL 99.05250071 http://map.immofacts.ch/shape/21710/ 4 MX 3483184 Isla Charco Largo T ISL 21.2313912 http://map.immofacts.ch/shape/22165/ 4 MX 8530090 Isla el Reloj T ISL 60.04549182 http://map.immofacts.ch/shape/726121/ 4 MX 3525952 Isla las Conchillosa T ISL 67.76492592 http://map.immofacts.ch/shape/725983/ 4