2025-02-12     2025-02-13     2025-02-14

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