3D, Database, PostGIS, PostgreSQL, SQL

Roll, Pitch, Yaw, ST_Rotate

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:
Diagram of jet liner with roll, pitch, yaw

  • Pitch Axis = ST_RotateX
  • Bearing (instead of yaw) = ST_RotateZ using 90-minus the angle for NSEW coordinates from Cartesian angles
  • Roll = ST_RotateY

    • Leave a comment

    This site uses Akismet to reduce spam. Learn how your comment data is processed.