2025-02-14     2025-02-15     2025-02-16

too many holes (not lakes) not US

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

select geoshapeid,geonameid,ST_NumInteriorRings(wkb_geometry),countrycode,level from geoname_shape where ST_NumInteriorRings(wkb_geometry)>10 and level>0 and countrycode not in ('CA','US') and geoshapeid not in (570298,102405,22987,22997,27161,27174)

fix with HoleRemover

geoshapeid	geonameid	st_numinteriorrings	countrycode	level	
143139	3027486	63	FR	4	
143040	2992770	131	FR	4	
143119	3032212	88	FR	4