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=RU,number=1}]
countrycode geonameid name featureclass featurecode st_distance shape relevance RU 2125578 Ostrov Getabu T ISL 2930.28105028 http://map.immofacts.ch/shape/738402/ 4