number of errors=1
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=1}]
countrycode geonameid name featureclass featurecode st_distance shape relevance MX 9195860 Isla Pájaros T ISL 46.61953952 http://map.immofacts.ch/shape/725487/ 4