FUNCTION fRegionAreaPatch

Returns the area of a patch, defined by its regionid, convexid and patch

First computes the area of the spherical polygon of the same vertices, using Girard's formula of spherical excess. Then adjusts the area with the signed areas of the semilunes formed by the arcs.
Parameters:
@regionid -- pointer to the region
@convexid -- id of the convex
@patch -- patch identifier
Return area in square degrees SELECT dbo.fRegionAreaPatch(123456,0,1)

Input and output parameters

name type length inout pnum

@patch int 4 input 3

float 8 input 0

@regionid bigint 8 input 1

@convexid bigint 8 input 2

name	type	length	inout	pnum
@patch	int	4	input	3
	float	8	input	0
@regionid	bigint	8	input	1
@convexid	bigint	8	input	2