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

population density of bbox < threshold, to find bboxes which are far too large.

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

select geoname.geonameid,name,geoname.featurecode,countrycode,to_char((north-south)*(east-west)/population,'990D999') as popdens,population,north,south,east,west,geoshapeid,accuracylevel from geoname_bbox,geoname where geoname.geonameid=geoname_bbox.geonameid and population>0 and (north-south)*(east-west)/population>0.1 and geoname.geonameid not in (select geonameid from qa_exceptions where key='chkBBoxPopulationDensity')

geonameid	name	featurecode	countrycode	popdens	population	north	south	east	west	geoshapeid	accuracylevel