pgSphere 1.1.5
pgSphere development team
pgSphere provides spherical data types, functions, and operators for PostgreSQL.
The project is hosted at pgfoundry.org and https://github.com/akorotkov/pgsphere
This document describes installation and usage of this module.
- Table of Contents
- 1. What is pgSphere?
- 2. Installation
- 2.1. Download
- 2.2. Installation
- 2.3. Creating a database with pgSphere
- 3. Data types
- 3.1. Overview
- 3.2. Point
- 3.3. Euler transformation
- 3.4. Circle
- 3.5. Line
- 3.6. Ellipses
- 3.7. Path
- 3.8. Polygon
- 3.9. Coordinates range
- 3.10. smoc: HEALPix Multi-Order Coverage map
- 4. Constructors
- 4.1. Point
- 4.2. Euler transformation
- 4.3. Circle
- 4.4. Line
- 4.5. Ellipse
- 4.6. Polygon
- 4.7. Path
- 4.8. Coordinates range
- 4.9. smoc
- 5. Operators
- 5.1. Casting
- 5.2. Equality
- 5.3. Contain and overlap
- 5.4. Crossing of lines
- 5.5. Distance
- 5.6. Length and circumference
- 5.7. Center
- 5.8. Change the direction
- 5.9. Turn the path of a line
- 5.10. Transformation
- 5.11. smoc operators
- 6. Functions
- 6.1. Area function
- 6.2. spoint functions
- 6.3. strans functions
- 6.4. scircle functions
- 6.5. sellipse functions
- 6.6. sline functions
- 6.7. spath functions
- 6.8. spoly functions
- 6.9. sbox functions
- 6.10. smoc functions
- 6.11. Epoch propagation
- 7. Create an index
- 7.1. Spherical index
- 7.2. smoc index
- 8. Usage examples
- 8.1. General
- 8.2. Geographical
- 8.3. Astronomical
- 9. FAQ
- 10. Appendix