Database Reference
In-Depth Information
Wewillwriteafunctiontocalculateourfootprintpyramid.Inputtothefunction,we'll
needthepositionoftheUASasgeometry(origin),thepitch,bearing,androll,aswell
as the field of view angle in x and y for the camera. Finally, we'll need the relative
height of the craft above ground.
CREATE OR REPLACE FUNCTION chp07.pbr(origin
geometry, pitch numeric, bearing numeric, roll
numeric, anglex numeric, angley numeric, height
numeric)
RETURNS geometry AS
$BODY$
Our pyramid function assumes that we know what the base size of our pyramid is.
Wedon'tknowthisinitially,sowe'llcalculateitssizebasedonthefieldofviewangle
of the camera and the height of the craft:
WITH widthx AS
(
