15.10 - ST_Line_Interpolate_Point - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns a point interpolated along an ST_Geometry type that represents an ST_LineString or GeoSequence value, given a proportional distance along that line.

 

Argument …

Specifies …

proportion

a FLOAT value between 0 and 1 that represents the fraction of the total 2-dimensional length of the ST_LineString where the point must be located.

Returns an ST_Point value.

ST_LineString and GeoSequence

   SELECT streetShape.ST_Line_Interpolate_Point(3E-1)
   FROM sample_streets
   WHERE skey = 1331;