number of errors=3
number of warnings=0
Group=chkGrpSea
Group=chkGrpShp
select ocean.geoshapeid,geoname_shape.modificationtime,ocean.adminname1,sourceid,ocean.source,st_npoints(ocean.wkb_geometry),st_npoints(geoname_shape.wkb_geometry) from ocean,geoname_shape where ocean.geoshapeid = geoname_shape.geoshapeid and not st_equals(ocean.wkb_geometry,geoname_shape.wkb_geometry)
update ocean set wkb_geometry=geoname_shape.wkb_geometry,shapegeography=ST_GeographyFromText(astext(st_multi(geoname_shape.wkb_geometry))) from geoname_shape where ocean.geoshapeid = geoname_shape.geoshapeid and not st_equals(ocean.wkb_geometry,geoname_shape.wkb_geometry)
geoshapeid modificationtime adminname1 sourceid source st_npoints st_npoints 574337 null Venetian Lagoon 299 ossaa 26137 376317 58297 2018-07-24 11:54:32.371931 Adriatic Sea 1000 vmap ocean bnd 1327 2761 58642 2018-07-24 11:48:38.840173 Adriatic Sea 1000 vmap ocean bnd 1770 5057