Substirng from a linestring

[Jim]

I have a LINESTRING representing a road.

I need to extract a LINESTRING substring of that original LINESTRING.

I vaguely remember an ST_SUBSTRING function in Spatialite but I can't find it in the documentation.

For example,   something like ST_SUBSTRING(LINESTRING, POINT1, POINT2);

So my question is how do I do this or did I miss it in the documentation.

Regards,

Jim

[a.fu...@lqt.it]

Hi Jim,

you are spoiled for choice, because SpatiaLite supports several
functions of this kind. please read the doc about:

ST_Line_Substring()
ST_LinesCutAtNodes()
ST_Split() and related friends

bye Sandro

[Jim]

Sandro,

Sorry about that.  I just kept looking for ST_SUBSTRING.

I guess after doing the compute stuff for 60+ years and too many programming languages, I might want to think about not doing it any more.

Regards,

Jim

[a.fu...@lqt.it]

On Tue, 7 Nov 2023 10:41:40 -0800 (PST), Jim wrote:
> Sandro,
>
> Sorry about that.  I just kept looking for ST_SUBSTRING.
>
> I guess after doing the compute stuff for 60+ years and too many
> programming languages, I might want to think about not doing it any
> more.
>

Jim,

with your 60 years of experience you definitely make me look like
a novice kid, given that I can boast only 40+ years of programming
experience.

May the Lord keep you healthy and with a well-functioning brain
for as long as possible, I wish you all my sincere best wishes.

bye Sandro