6.1.  Area function #

The area function returns the area of a spherical object in square radians. Supported data types are: scircle, spolygon, sbox, smoc. The polygon should be convex, otherwise the behaviour is undefined.

Example 6.1. Area of a spherical circle as a multiple of π

sql> SELECT area( scircle '<(0d,90d),60d>' ) / pi() AS area;
 area
------
 1
(1 row)
              

Example 6.2. Area of a Multi-Order Coverage (MOC) object

sql> SELECT area(smoc '0/1-3');
       area
-------------------
 3.141592653589793
(1 row)