STFindOffset

STFindOffset — Compute smallest perpendicular offset from supplied point to the supplied linestring. Function Specification. Description. Given a point near @p_linestring, this function returns the perpendicular distance from it to the closest point on @p_linestring. Notes. Calls [lrs].[STInterpolatePoint] Srid of @p_linestring and @p_point must be the same. Parameters. Result. The function returns the perpendicular offsetRead More