FUNCTION fRegionConvexToArcs

Returns the ordered arcs of a spherical Convex

Parameters:
regionID bigint ID of the region
convexID bigint ID of the convex of the relevant HalfSpace
convexString varchar(8000) added to the convex Output is an array of the arcs of the spherical polygon defined by the convex:
regionid bigint
convexid bigint
patch int ID of the patch
state int 1:hole, 2:root, 3: bounding circle
draw int 1:draw, 0:hide
ra1, dec1,ra2,dec2 float equatorial coords of the two endpoints of the arc
x,y,z,c the equation of the halfplane of the arcs
length the length of the arc in arcmins select * from dbo.fRegionConvexToArcs(1457,0,'')

Input and output parameters

name type length inout pnum

@regionid bigint 8 input 1

@convexid bigint 8 input 2

@convexString varchar 8000 input 3

patch int 4 output 4

state int 4 output 5

draw int 4 output 6

ra1 float 8 output 7

dec1 float 8 output 8

ra2 float 8 output 9

dec2 float 8 output 10

x float 8 output 11

y float 8 output 12

z float 8 output 13

c float 8 output 14

length float 8 output 15

regionid bigint 8 output 1

convexid bigint 8 output 2

constraintid bigint 8 output 3

name	type	length	inout	pnum
@regionid	bigint	8	input	1
@convexid	bigint	8	input	2
@convexString	varchar	8000	input	3
patch	int	4	output	4
state	int	4	output	5
draw	int	4	output	6
ra1	float	8	output	7
dec1	float	8	output	8
ra2	float	8	output	9
dec2	float	8	output	10
x	float	8	output	11
y	float	8	output	12
z	float	8	output	13
c	float	8	output	14
length	float	8	output	15
regionid	bigint	8	output	1
convexid	bigint	8	output	2
constraintid	bigint	8	output	3