number of errors=0
number of warnings=0
select geonameid,featurecode,name,countrycode,altitude,gtopo30,srtm3,astergdem from geoname where altitude/astergdem=3 and altitude>100 and astergdem>0 and relevance >6 and featureclass='T' and featurecode not in ('ISL','ISLS') and not exists (select 1 from qa_exceptions where qa_exceptions.geonameid=geoname.geonameid and qa_exceptions.key='chkElevationFeetConfused') order by relevance desc
geonameid featurecode name countrycode altitude gtopo30 srtm3 astergdem