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 Reply

    Fill in your details below or click an icon to log in:

    Gravatar
    WordPress.com Logo

    You are commenting using your WordPress.com account. ( Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. ( Log Out /  Change )

    Cancel

    Connecting to %s

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