pgSphere provides spherical data types for storing with PostgreSQL. Furthermore, there is a data type to do transformations.
Table 3.1. Data types
SQL type name | spherical type |
|---|---|
spoint
| point (position) |
strans
| Euler transformation |
scircle
| circle |
sline
| line |
sellipse
| ellipse |
spoly
| polygon |
spath
| path |
sbox
| coordinate range |
smoc
| HEALPix Multi-Order Coverage map |