PostGIS Cookbook - Second Edition

Getting started

The metadata or ephemeris we have for the flight includes the bearing, pitch, and roll of the UAS, in addition to its elevation and location:

To translate these ephemeris into PostGIS terms, we'll assume the following:

• 90 degrees minus the pitch is equivalent to ST_RotateX
• The negative roll is equivalent to ST_RotateY
• 90 degrees minus the bearing is equivalent to ST_RotateZ

In order to perform our analysis, we require external functions. These functions can be downloaded from https://github.com/smathermather/postgis-etc/tree/master/3D.

We will use patched versions of ST_RotateX, ST_RotateY (ST_RotateX.sql, and ST_RotateY.sql ...