number of errors=8
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=BR,number=4}, {key=GL,number=2}, {key=CN,number=1}, {key=MV,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 BR 3391468 Ilha Inajatuba T ISL 1389.06280482 http://map.immofacts.ch/shape/4704/ 5 MV 1282367 Fehigili T ISL 1269.44983613 http://map.immofacts.ch/shape/704094/ 5 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 BR 3394100 Ilha Murituba T ISL 4490.63511821 http://map.immofacts.ch/shape/721957/ 4 BR 8508248 Ilha Itapera T ISL 5020.76114933 http://map.immofacts.ch/shape/722073/ 4 GL 3419452 Tapeq T ISL 169.0935041 http://map.immofacts.ch/shape/15496/ 4