Schema Browser

FUNCTION fGetObjFromRectEq

Returns table of objects inside a rectangle defined by two ra,dec pairs.
Note the order of the parameters: @ra1, @dec1, @ra2, @dec2

This is a variant of fGetObjFromRect (actually calls it) that takes the input parameters in a more intuitive order rather than (ra1,ra2,dec1,dec2).
Assumes dec1Uses level 20 HTM.
returned fields:

objID bigint, -- id of the object

run int NOT NULL, -- run that observed the object

camcol int NOT NULL, -- camera column in run

field int NOT NULL, -- field in run

rerun int NOT NULL, -- software rerun that saw the object

type int NOT NULL, -- type of object (see DataConstants PhotoType)

cx float NOT NULL, -- xyz of object

cy float NOT NULL,

cz float NOT NULL,

htmID bigint -- hierarchical triangular mesh ID of object
sample call
select * from dbo.fGetObjFromRectEq(185,0,185.1,0.1)

Input and output parameters

name	type	length	inout	pnum
@ra1	float	8	input	1
@dec1	float	8	input	2
@ra2	float	8	input	3
@dec2	float	8	input	4
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
objID	bigint	8	output	1
htmID	bigint	8	output	10