2025-03-05     2025-03-06     2025-03-07

shape for islands should be simple polygons

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