<div dir="ltr"><div>Hello Paul,</div><div><br></div>It seems that, at least, one geometry in the data table is not correctly defined.<div><br></div><div>Use this to confirm:<br><br></div><div>SELECT geom, ST_Geometrytype(geom)<br>FROM data;</div><div><br></div><div>Best regards,</div><div><br></div><div>Alexandre Neto</div><div>QGIS/PostGIS Support</div><div><a href="http://www.cooperative.net">www.cooperative.net</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Oct 27, 2020 at 9:40 AM <<a href="mailto:paul.malm@lfv.se">paul.malm@lfv.se</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="SV">
<div class="gmail-m_5857468837741246622WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US">Hi I would like to break lines in intersections of polygons, but without erasing anything.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I have used this (but now suddenly, it does not work) :<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">Create table tmpint2 as</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">WITH</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">data AS (</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> SELECT * FROM public."linesToBeCut" AS t(id, geom)</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">),</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">cutter AS (</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> SELECT * FROM "cutterPolygons" AS t(geom)</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">)</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">SELECT id,</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> CASE WHEN cutting IS NULL THEN geom</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> ELSE st_collectionExtract(ST_Split( geom, cutting ),2) END AS geom</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black">FROM (SELECT id, d.geom geom,
</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> (SELECT ST_Collect(c.geom) geom</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> FROM cutter c WHERE ST_Intersects(d.geom, c.geom)</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> ) AS cutting</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:black"> FROM data d) AS t;</span><span lang="EN-US" style="font-size:10pt;font-family:Consolas"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">The error code I get is :<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10pt;font-family:Consolas;color:red">st_intersects(integer, geometry) does not exsits</span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Can anyone please tell me what I’m doing wrong here. I’m not to bright in SQL.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">/Paul<u></u><u></u></span></p>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>