Thanks Darafei, perfect!
Just for newbees like me if they read this mail:
you have missed one “)” at the near end
UPDATE public."Ocean"
SET the_geom = coalesce(ST_Multi(ST_Difference("Ocean".the_geom, (select
ST_Union(the_geom) from "Islands" as b where ST_Intersects( "Ocean ".the_geom,
b.the_ge
Why do you think loading is a heavy duty?
On Tuesday, 20 August 2019, Basques, Bob (CI-StPaul) <
bob.basq...@ci.stpaul.mn.us> wrote:
> All,
>
> One biggie, is that the ESRI side does not like connecting to the
> “postgres” named database, claiming it’s a System database (whatever that
> means).
All,
One biggie, is that the ESRI side does not like connecting to the “postgres”
named database, claiming it’s a System database (whatever that means). This is
not readily available as a limitation either when looking for reasons why it
won’t connect. We’ve been using the “postgres” database
How to ensure that all versions of ArcGIS desktop applications can access
and read from server-based PostGIS/PostgreSQL?
Regards,
Shao
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
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
Thanks, Nicolas!
Från: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] För Nicolas
Ribot
Skickat: den 20 augusti 2019 09:21
Till: PostGIS Users Discussion
Ämne: Re: [postgis-users] splitting linestrings with a polygon
Hi,
Keep the geometry column as multilinestring, as resulting sp
Hi,
Keep the geometry column as multilinestring, as resulting splitting can
produce such objects, but add a st_multi after the intersection, on the
update clause:
... SET the_geom = st_multi(ST_Intersection(b.the_geom, p.the_geom))
It will force geometries to be multi, even if it only contains on
Hi, I have a problem with MultiLinestrings/Linestrings.
I have one layer with Linestrings which I would like to split in the
intersections of a polygon (MultiPolygon) in a polygon layer.
I tried this:
UPDATE public."linelayer" b
SET the_geom = ST_Intersection(b.the_geom, p.the_geom)
FROM