FUNCTION  fGetNearbySpecObjAllXYZ

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
zStatus	int	4	output	8
specClass	int	4	output	9
zWarning	int	4	output	10
sciencePrimary	int	4	output	11
z	real	4	output	5
zErr	real	4	output	6
zConf	real	4	output	7
cx	float	8	output	12
cy	float	8	output	13
cz	float	8	output	14
distance	float	8	output	16
specObjID	bigint	8	output	1
htmID	bigint	8	output	15