number of errors=0
number of warnings=0
Group=chkGrpShp
Group=ckgGrpIsland
select geoname.countrycode,geoname.geonameid,geoshapeid,ansiname, GeometryType(wkb_geometry) as geomtype,st_area(wkb_geometry) as area, st_nrings(wkb_geometry), relevance, 'http://map.immofacts.ch/shape/' || geoshapeid || '/' as shape from geoname,geoname_shape where geoname.geonameid=geoname_shape.geonameid and featurecode='ISL' and GeometryType(wkb_geometry)<>'POLYGON'
[]
countrycode geonameid geoshapeid ansiname geomtype area st_nrings relevance shape