2025-04-15     2025-04-16     2025-04-17

sea shapes are linked to geoNameId

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

select distinct adminname1,st_x(st_centroid(st_union(st_envelope(wkb_geometry)))),st_y(st_centroid(st_union(st_envelope(wkb_geometry)))) from ocean where geonameid is null group by adminname1

adminname1	st_x	st_y	
Canarias Sea	-28.03426309549671	25.64171758194299