number of errors=0
number of warnings=0
Group=ckgGrpIsland
Group=ckgGrpWP
select rank,name,altitude,gtopo30,srtm3,countrycode,url,'http://www.geonames.org/maps/google_' || wp_island.longlat[1] || '_' || wp_island.longlat[0] || '.html' as gnurl,case when rank>95 then 'ERR' else 'WRN' end as ERRWRN from wp_island where rank>99 and geonameid is null and url is not null order by rank desc
rank name altitude gtopo30 srtm3 countrycode url gnurl errwrn