number of errors=4
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=GL,number=2}, {key=BR,number=1}, {key=CN,number=1}]
countrycode geonameid name featureclass featurecode st_distance shape relevance CN 1816034 Caofeidian T ISL 74.72523818 http://map.immofacts.ch/shape/25624/ 7 GL 3419561 Sungaussat Nunât T ISL 27.61838807 http://map.immofacts.ch/shape/17178/ 4 BR 3387602 Ilha Sirituba T ISL 2825.90321172 http://map.immofacts.ch/shape/722556/ 4 GL 3419452 Tapeq T ISL 169.0935041 http://map.immofacts.ch/shape/15496/ 4