number of errors=5
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 Gulf Of Berau 133.004837036133 -2.43036115169525 Iceland Sea -18.796775913848432 67.32383548077348 North Greenland Sea -9.261889182223195 77.17604728995896 Palk Strait And Palk Bay 79.57564163208006 9.625930786132812