[postgis-users] can not get st_split to work.

[Regina Obe]

I don't see your blade CTE used at all and both a and b are roads which
wouldn't work with ST_Split, since the blade needs to be one dimension lower
than the thing you are splitting.

 

So the error you are getting  "Splitter line has linear intersection with
input SQL state: XX000"  

 

Is because your intersection literally is returning a line instead a point.

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of paul.malm at lfv.se
Sent: Monday, December 23, 2019 2:52 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] can not get st_split to work.

 

Hi ,

I've created a point-table (point) where I would like to split the lines in
table roads.

 

SQL:

CREATE TABLE  roads_splitted AS

WITH                    

blade AS (SELECT ST_Collect(the_geom) AS the_geom  FROM  point) 

 

SELECT fid, (ST_Dump

                           (ST_Split(

                                              a.the_geom, (SELECT
ST_Collect(b.the_geom) AS geom FROM 

 
roads AS b WHERE ST_Intersects(a.the_geom, b.the_geom)

                                                                           )

                                               )

                              )).geom 

FROM roads AS a 

UNION ALL SELECT fid, the_geom FROM roads AS a 

WHERE  NOT EXISTS (

           SELECT 1  FROM  point AS b WHERE  ST_Intersects(a.the_geom,
b.the_geom)

);

 

I'm getting this error message:

ERROR: Splitter line has linear intersection with input SQL state: XX000

 

 

Anyone who knows wat I'm doing wrong? Linear intersection with a point and a
line?

 

Kind regards,

Paul

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191223/f250b942/attachment.html>