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

seas have shape

number of errors=0
number of warnings=0
Group=chkGrpSea

select distinct adminname1,geonameid from ocean where not exists (select 1 from geoname_bbox where geoname_bbox.geonameid=ocean.geonameid and wkb_geometry is not null) and geonameid >0

adminname1	geonameid