Re: Get part of a 3D line based on Z value

2025-06-03 Thread Paul Ramsey
If instead of putting your value on the Z, you put it on the M, you could have recourse to the https://postgis.net/docs/ST_LocateBetween.html function. Maybe that? P > On Jun 3, 2025, at 8:50 AM, Richard Huesken wrote: > > Hi, > > I have a 3D line, which represents the track of a ship. > The

Re: Get part of a 3D line based on Z value

2025-06-03 Thread Komяpa
https://postgis.net/docs/ST_LocateBetweenElevations.html should just do the trick. On Tue, Jun 3, 2025 at 7:58 PM Paul Ramsey wrote: > If instead of putting your value on the Z, you put it on the M, you could > have recourse to the https://postgis.net/docs/ST_LocateBetween.html function. > Maybe

Get part of a 3D line based on Z value

2025-06-03 Thread Richard Huesken
Hi, I have a 3D line, which represents the track of a ship. The Z value is set to a an OADate value (see e.g. https://learn.microsoft.com/en-us/dotnet/api/system.datetime.tooadate?view=net-8.0 ). In this way, I have the date time of each point in the line. I need get the first part of the line un