<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Rémi,<br>
<br>
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:<br>
<br>
CREATE OR REPLACE FUNCTION ST_SplitPolygon(poly geometry, blade
geometry) RETURNS geometry AS<br>
$$<br>
declare<br>
out_geom geometry;<br>
begin<br>
begin<br>
out_geom := st_split(poly, blade);<br>
exception when internal_error then<br>
out_geom := ST_Collect((d).geom) FROM (SELECT
ST_Dump(ST_Polygonize(ST_Union(ST_Boundary(poly), blade))) AS d) f
WHERE ST_Area(ST_Intersection(poly, (d).geom)) / ST_Area((d).geom)
>= 1 - 1e-10;<br>
end;<br>
return out_geom;<br>
end;<br>
$$<br>
LANGUAGE plpgsql IMMUTABLE STRICT COST 100;<br>
<br>
But I will definitely give your function a try and compare the
results!<br>
<br>
Thanks again! Regards,<br>
<br>
Birgit<br>
<br>
<pre class="moz-signature" cols="72">
</pre>
Am 16.06.2016 um 10:18 schrieb Rémi Cura:<br>
</div>
<blockquote
cite="mid:CAJvUf_saoYMtxi6rj6wvs0QGrPOx=oFfpuAx86i0pv32F6TdOw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default"
style="font-family:monospace,monospace">Hey,<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">I wrote a
multi-friendly st_split a while ago.<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">Maybe it will help
you:<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace"><a
moz-do-not-send="true"
href="https://github.com/Remi-C/PPPP_utilities/blob/master/postgis/rc_split_multi.sql">https://github.com/Remi-C/PPPP_utilities/blob/master/postgis/rc_split_multi.sql</a><br>
<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">Cheers,<br>
</div>
<div class="gmail_default"
style="font-family:monospace,monospace">Rémi-C<br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-06-15 19:19 GMT+02:00 Birgit
Laggner, vTI <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:birgit.laggner@thuenen.de" target="_blank">birgit.laggner@thuenen.de</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Sandro,<br>
<br>
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?<br>
<br>
Regards,<br>
<br>
Birgit
<div class="HOEnZb">
<div class="h5"><br>
<br>
Am 15.06.2016 um 19:02 schrieb Sandro Santilli:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
On Tue, Jun 14, 2016 at 02:52:52PM +0200, Birgit
Laggner wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
ERROR: Splitting a Polygon by a MultiLineString is
unsupported<br>
</blockquote>
Support for this functionality was added in
PostGIS-2.2.0<br>
<br>
--strk;<br>
<br>
</blockquote>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/postgis-users">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>