PostGIS
Name
ST_3DLineInterpolatePoint — Returns a point interpolated along a 3D line at a fractional location.
Description
Returns a point interpolated along a 3D line at a fractional location. First argument must be a LINESTRING. Second argument is a float between 0 and 1 representing the point location as a fraction of line length. The M value is interpolated if present.
|
Availability: 3.0.0
This
function supports 3d and will not drop the z-index.
Examples
Return point 20% along 3D line
SELECT ST_AsText(
ST_3DLineInterpolatePoint('LINESTRING(25 50 70, 100 125 90, 150 190 200)',
0.20));
st_asetext
----------------
POINT Z (59.0675892910822 84.0675892910822 79.0846904776219)