number of errors=9
number of warnings=0
Group=chkGrpSea
select name,geonameid from geoname where featurecode='OCN' and not exists (select 1 from geoname_bbox where geoname_bbox.geonameid=geoname.geonameid and wkb_geometry is not null)
name geonameid North Pacific Ocean - Marshall Islands 7670505 North West Pacific Ocean - Helen Reef 7670624 North West Pacific Ocean - to the East 7839117 North West Pacific Ocean - to the East 7733072 North Pacific Ocean - Ulithi Atoll 7647001 Western Central Pacific Ocean - Kiribati 7669370 North West Pacific Ocean - E to S of Palau Islands 7670826 Océano Pacífico del Norte 3812150 Southern Ocean 4036776