_Intersects( "Ocean ".the_geom,
b.the_geom, the_geom);
Från: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] För Darafei
"Kom?pa" Praliaskouski
Skickat: den 20 augusti 2019 15:38
Till: PostGIS Users Discussion
Ämne: Re: [postgis-users] create holes in ocean polygons w
You're getting a copy of each ocean for each island with that island
removed, and only one gets back into the table. You probably want to remove
an union of all islands from each ocean.
UPDATE public."Ocean"
SET the_geom = coalesce(ST_Multi(ST_Difference("Ocean".the_geom, (select
ST_Union(the_g
Hi,
I have a table with ocean polygons and would like to create holes in those
polygons with an island layer (including island polygons).
I've tried this:
UPDATE public."Ocean"
SET the_geom = ST_Multi(ST_Difference("Ocean".the_geom, b.the_geom))
FROM "Islands" as b
WHERE ST_Intersects( "Ocean ".t
