2025-09-13     2025-09-14     2025-09-15

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=KP,number=2}]
fix with st_centroid or ST_PointOnSurface

countrycode	geonameid	name	
KP	1875385	Kŭmgang-gun	
KP	1875619	Kosŏng-gun