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

shape country should be the same as island country for single country islands

number of errors=0
number of warnings=0
Group=chkGrpShp
Group=ckgGrpIsland

select geoname.countrycode, geoname_shape.countrycode,geoname.geonameid,geoshapeid,ansiname, 'http://map.immofacts.ch/shape/' || geoshapeid || '/' as shape from geoname,geoname_shape where geoname.geonameid=geoname_shape.geonameid and featurecode='ISL' and geoname.countrycode<>geoname_shape.countrycode and geoname.cc2 is null

[]

countrycode	countrycode	geonameid	geoshapeid	ansiname	shape