FUNCTION fGetNearestSpecObjEq

Returns nearest scienceprimary specobj within @r arcminutes of an equatorial point (@ra,@dec).

returned table:
specObjID bigint, -- unique spectrum ID
plate int NOT NULL, -- spectroscopic plate number
mjd int NOT NULL, -- MJD of observation
fiberID int NOT NULL, -- fiber number on plate
z real NOT NULL, -- final spectroscopic redshift
zErr real NOT NULL, -- redshift error
zConf real NOT NULL, -- redshift confidence
zStatus int NOT NULL, -- redshift status
specClass int NOT NULL, -- spectral classification
zWarning int NOT NULL, -- warning flags
cx float NOT NULL, -- x of normal unit vector in J2000
cy float NOT NULL, -- y of normal unit vector in J2000
cz float NOT NULL, -- z of normal unit vector in J2000
htmID bigint, -- 20-deep HTM ID
distance float -- distance in arc minutes
Sample call to find the nearest SpecObj within 1/2 arcminute of ra,dec 180.0, -0.5, 0.5
select * from dbo.fGetNearestSpecObjEq(180.0,-0.5,0.5)
see also fGetNearbySpecObjEq, fGetNearestSpecObjAllEq, fGetNearbySpecObjXYZ,

Input and output parameters

name type length inout pnum

@ra float 8 input 1

@dec float 8 input 2

@r float 8 input 3

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

z real 4 output 5

zErr real 4 output 6

zConf real 4 output 7

cx float 8 output 11

cy float 8 output 12

cz float 8 output 13

distance float 8 output 15

specObjID bigint 8 output 1

htmID bigint 8 output 14

name	type	length	inout	pnum
@ra	float	8	input	1
@dec	float	8	input	2
@r	float	8	input	3
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
z	real	4	output	5
zErr	real	4	output	6
zConf	real	4	output	7
cx	float	8	output	11
cy	float	8	output	12
cz	float	8	output	13
distance	float	8	output	15
specObjID	bigint	8	output	1
htmID	bigint	8	output	14