FUNCTION fGetNearbyObjEq

Given an equatorial point (@ra,@dec), returns table of primary objects within @r arcmins of the point. There is no limit on @r.

ra, dec are in degrees, r is in arc minutes.
There is no limit on the number of objects returned, but there are about 40 per sq arcmin.
returned table:
objID bigint, -- Photo primary object identifier
run int NOT NULL, -- run that observed this object
camcol int NOT NULL, -- camera column that observed the object
field int NOT NULL, -- field that had the object
rerun int NOT NULL, -- computer processing run that discovered the object
type int NOT NULL, -- type of the object (3=Galaxy, 6= star, see PhotoType in DBconstants)
cx float NOT NULL, -- x,y,z of unit vector to this object
cy float NOT NULL,
cz float NOT NULL,
htmID bigint, -- Hierarchical Trangular Mesh id of this object
distance float -- distance in arc minutes to this object from the ra,dec.
Sample call to find all the Galaxies within 3 arcminutes of ra,dec 185,0
select * from Galaxy as G, dbo.fGetNearbyObjEq(185,0,3) as N where G.objID = N.objID
see also fGetNearestObjEq, fGetNearbyObjXYZ, fGetNearestObjXYZ

Input and output parameters

name type length inout pnum

@ra float 8 input 1

@dec float 8 input 2

@r float 8 input 3

run int 4 output 2

camcol int 4 output 3

field int 4 output 4

rerun int 4 output 5

type int 4 output 6

cx float 8 output 7

cy float 8 output 8

cz float 8 output 9

distance float 8 output 11

objID bigint 8 output 1

htmID bigint 8 output 10

name	type	length	inout	pnum
@ra	float	8	input	1
@dec	float	8	input	2
@r	float	8	input	3
run	int	4	output	2
camcol	int	4	output	3
field	int	4	output	4
rerun	int	4	output	5
type	int	4	output	6
cx	float	8	output	7
cy	float	8	output	8
cz	float	8	output	9
distance	float	8	output	11
objID	bigint	8	output	1
htmID	bigint	8	output	10