FUNCTION fGetNearbySpecObjAllXYZ

Returns table of all spectrum objects within @r arcmins of an xyz point (@nx,@ny, @nz).

There is no limit on the number of objects returned.
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)
mode tinyint NOT NULL, -- mode of photoObj
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 SpecObj within 0.5 arcminutes of xyz -.0996,-.1,0
select * from dbo.fGetNearbySpecObjAllXYZ(-.996,-.1,0,0.5)
see also fGetNearbySpecObjEq, fGetNearestSpecObjXYZ, fGetNearestSpecObjXYZ

Input and output parameters

name type length inout pnum

@nx float 8 input 1

@ny float 8 input 2

@nz float 8 input 3

@r float 8 input 4

plate int 4 output 2

mjd int 4 output 3

fiberID int 4 output 4

zWarning int 4 output 7

sciencePrimary int 4 output 8

z real 4 output 5

zErr real 4 output 6

cx float 8 output 9

cy float 8 output 10

cz float 8 output 11

distance float 8 output 13

specObjID bigint 8 output 1

htmID bigint 8 output 12

name	type	length	inout	pnum
@nx	float	8	input	1
@ny	float	8	input	2
@nz	float	8	input	3
@r	float	8	input	4
plate	int	4	output	2
mjd	int	4	output	3
fiberID	int	4	output	4
zWarning	int	4	output	7
sciencePrimary	int	4	output	8
z	real	4	output	5
zErr	real	4	output	6
cx	float	8	output	9
cy	float	8	output	10
cz	float	8	output	11
distance	float	8	output	13
specObjID	bigint	8	output	1
htmID	bigint	8	output	12