2025-05-28     2025-05-29     2025-05-30

each ADM2 should be within shape

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

select countrycode,geoname.geonameid,name from geoname,geoname_bbox where not exists (select 1 from geoname_bbox where geoname.geonameid=geoname_bbox.geonameid and (st_within(geography::geometry,wkb_geometry) or wkb_geometry is null)) and geoname.geonameid=geoname_bbox.geonameid and geoname.featurecode='ADM2' and geoname.countrycode not in ('CU','FM')

[{key=TR,number=2}]
fix with st_centroid or ST_PointOnSurface

countrycode	geonameid	name	
TR	9565135	Bağlar	
TR	7732330	Gemlik