2025-03-02     2025-03-03     2025-03-04

each adm should be within bounding box of parent ADM5

number of errors=0
number of warnings=0
Group=chkGrpBBox

select l.geonameid,l.countrycode,l.name,l.featurecode,p.geonameid,p.name,p.featurecode from geoname l,geoname p, geoname_bbox b where l.featurecode in ('ADM5') and p.featurecode='ADM5' and l.countrycode=p.countrycode and l.admincode1=p.admincode1 and l.admincode2=p.admincode2 and l.admincode3=p.admincode3 and l.admincode4=p.admincode4 and l.admincode5=p.admincode5 and p.geonameid=b.geonameid and (south>l.longlat[1] or l.longlat[1]>north or (westeast)) or (west>east and ((l.longlat[0]<0 and l.longlat[0]>west) or (l.longlat[0]>0 and l.longlat[0]

[]

geonameid	countrycode	name	featurecode	geonameid	name	featurecode