Re: [postgis-users] create holes in ocean polygons with island polygons

2019-08-20 Thread paul.malm
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

Re: [postgis-users] ArcGIS desktop accessing and reading from PostGIS

2019-08-20 Thread Shaozhong SHI
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).

Re: [postgis-users] ArcGIS desktop accessing and reading from PostGIS

2019-08-20 Thread Basques, Bob (CI-StPaul)
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

[postgis-users] ArcGIS desktop accessing and reading from PostGIS

2019-08-20 Thread Shaozhong SHI
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

Re: [postgis-users] create holes in ocean polygons with island polygons

2019-08-20 Thread Komяpa
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

[postgis-users] create holes in ocean polygons with island polygons

2019-08-20 Thread paul.malm
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

Re: [postgis-users] splitting linestrings with a polygon

2019-08-20 Thread paul.malm
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

Re: [postgis-users] splitting linestrings with a polygon

2019-08-20 Thread Nicolas Ribot
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

[postgis-users] splitting linestrings with a polygon

2019-08-20 Thread paul.malm
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