[postgis-users] splitting a linestring with points

[Olivier Leprêtre]

Hi Martin

I hoped but it's doesn't with results from st_collectionExtract(st_Split())

Olivier

-----Message d'origine-----
De : postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] De la part de Martijn Meijers
Envoyé : vendredi 9 février 2018 09:15
À : postgis-users at lists.osgeo.org
Objet : Re: [postgis-users] splitting a linestring with points

st_dump would make it possible, no?

select st_astext((st_dump('MULTILINESTRING((0 0, 10 10), (20 20, 30 30))')).geom);
         st_astext
-------------------------
  LINESTRING(0 0,10 10)
  LINESTRING(20 20,30 30)
(2 rows)



On 08-02-18 21:48, Olivier Leprêtre wrote:
>
> Hi,
>
> I want to break a linestring into linestrings by breaking it with a 
> set of points along this line. This appeared easy at first but 
> finally, I tried using st_split(line, set of points) but this returns 
> multilinestrings when I just wants linestrings. I tried several 
> functions like st_dump, st_geometryN, stcollectionextract and so on 
> after st_split but did not find how could I get only rows of 
> linestring splitted by the points acting like blades on the first 
> linestring.
>
> Thanks for any help,
>
> Olivier
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> 
> 	Garanti sans virus. www.avast.com 
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> 
>
>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus