Edit– Code may be flawed, testing—– testing. Please wait to use… . In PostGIS, ST_RotateZ has a couple forms: a version that rotates around 0,0 and a version that rotates around a point of origin: ST_RotateX and ST_RotateY have had no equivalents– until now. These equivalents are dumb versions– they use a transformation/rotation/reverse-transformation to do their magic, which is maybe not as efficient as using … Continue reading Aaargh! No: geometry ST_RotateX(geometry geomA, float rotRadians, geometry pointOrigin)

Thinking out load (and hoping I’m right), but with the classic flight dynamics of roll, pitch, yaw for flight dynamics relative to PostGIS concepts of rotation: Pitch Axis = ST_RotateX Bearing (instead of yaw) = ST_RotateZ using 90-minus the angle for NSEW coordinates from Cartesian angles Roll = ST_RotateY Continue reading Roll, Pitch, Yaw, ST_Rotate