After a Plastic Swivel Spray Aerator was installed at the water faucet at my engineer/mathematician/computer scientist son François's place, a remarkable conical water flow with fascinating pattern sometimes shows up. The flow-phase change was triggered not by the change in mode from spray to stream but by the change in flow rate.
This ellipsoidal water flow is from a garden hose nozzle.