Database Reference
In-Depth Information
To translatethese 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 functions that are not yet part of the
PostGIScore.Thesefunctionscanbedownloadedfrom
https://github.com/smather-
We will use patched versions of
ST_RotateX
and
ST_RotateY
(
ST_RotateX.sql
and
ST_RotateY.sql
), which allow us to rotate geometries
around an input point, as well as a function for calculating our field of view—
pyr-
amidMaker.sql
. Future versions of PostGIS will include these versions of
ST_RotateX
and
ST_RotateY
builtin.Wehaveanotherfunction,
ST_RotateXYZ
,
which is built upon these and will also simplify our code by allowing us to specify
three axes at the same time for rotation.