Re: [postgis-users] ST_Split with Multilinestring

2016-06-16 Thread Birgit Laggner
Hi Sandro, mmh... I really would like to, but I am no programmer and wouldn't know how to contribute and I am not in a position to decide about financing somebody to add this functionality. I'm sorry. But thank you anyway for clarifying the current functionality status! Regards, Birgit Am

Re: [postgis-users] ST_Split with Multilinestring

2016-06-16 Thread Birgit Laggner
Hi Rémi, thank you for sharing your function. In the meantime I seem to have solved the problem by combining the st_split function with a function from an old use case: CREATE OR REPLACE FUNCTION ST_SplitPolygon(poly geometry, blade geometry) RETURNS geometry AS $$ declare out_geom

Re: [postgis-users] ST_Split with Multilinestring

2016-06-16 Thread Sandro Santilli
On Wed, Jun 15, 2016 at 07:19:34PM +0200, Birgit Laggner, vTI wrote: > Hi Sandro, > > yes, I read so, too. But, our database has PostGIS version: > "POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. > 4.9.1, 04 March 2015" GDAL="GDAL 1.11.2, released 2015/02/10" > LIBXML="2.9.2"

Re: [postgis-users] ST_Split with Multilinestring

2016-06-16 Thread Rémi Cura
Hey, I wrote a multi-friendly st_split a while ago. Maybe it will help you: https://github.com/Remi-C/_utilities/blob/master/postgis/rc_split_multi.sql Cheers, Rémi-C 2016-06-15 19:19 GMT+02:00 Birgit Laggner, vTI : > Hi Sandro, > > yes, I read so, too. But, our

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Birgit Laggner, vTI
Hi Sandro, yes, I read so, too. But, our database has PostGIS version: "POSTGIS="2.2.1 r14555" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 1.11.2, released 2015/02/10" LIBXML="2.9.2" LIBJSON="0.11.99" TOPOLOGY RASTER" and I still get that error. Any idea why?

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Sandro Santilli
On Tue, Jun 14, 2016 at 02:52:52PM +0200, Birgit Laggner wrote: > ERROR: Splitting a Polygon by a MultiLineString is unsupported Support for this functionality was added in PostGIS-2.2.0 --strk; ___ postgis-users mailing list

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Birgit Laggner
Yes, this function will probably work - that's similar to what I meant with "looping the ST_Split with some function, DO block or pgScript after selecting all intersecting linestrings per polygon" in my original mail. If my current approach fails, too, I will revert to some sort of looping

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Marcin Mionskowski
I think I finaly understand what you have and what you want to achieve - take a look at polygon and multiline definitions :) If I'm right, this function should do the work: create table polygon ( id serial, geom geometry, done smallint default 0 ); create table multiline ( id serial, geom

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Birgit Laggner
Dear list, @Marcone: Unfortunately, the st_multi didn't change anything. The error message is still the same. Next, I will try some function from a user example from 2008 (https://trac.osgeo.org/postgis/wiki/UsersWikiSplitPolygonWithLineString). Maybe this will be a workaround. But I am

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Birgit Laggner
Hi Marcin, thanks for your reply. I don't think, that will provide the results I am looking for. I am deliberately aggregating all intersecting lines with ST_Union because otherwise the query would result in several collections per polygon, each collection containig the st_split result for

Re: [postgis-users] ST_Split with Multilinestring

2016-06-15 Thread Marcin Mionskowski
On Tue, 14 Jun 2016 15:37:40 +0200, Marcone wrote: 2016-06-14 9:52 GMT-03:00 Birgit Laggner : I would like to use the ST_Split function to split polygons from one table with all intersecting lines from another table. Unfortunately, I