2025-03-03     2025-03-04     2025-03-05

each country lat/lng should be within its bounding box

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

select geoname.geonameid,countrycode,featureclass,geoname.featurecode,west,north,east,south from geoname_bbox,geoname where geoname.geonameid=geoname_bbox.geonameid and (south>longlat[1] or longlat[1]>north or (westeast)) or (west>east and ((longlat[0]<0 and longlat[0]>west) or (longlat[0]>0 and longlat[0]

geonameid	countrycode	featureclass	featurecode	west	north	east	south