FUNCTION fRegionsContainingPointEq

Returns regions containing a given point

The parameters
@ra, @dec the equatorial coordinats on the J2000 celestial sphere.

@types is a varchar(1000) space-separated string of the desired region types.
Possible types are: SEGMENT STRIPE TIGEOM PLATE CAMCOL RUN STAVE CHUNK TILE TILEBOX SECTOR SECTORLET SKYBOX WEDGE.

@buffer is the 'fuzz' in arcmins around that poiont.

Returns a table with the columns
Returns empty table if input params are bad.
regionid bigint NOT NULL PRIMARY KEY
type varchar(16) NOT NULL SELECT * from dbo.fGetRegionsContainingPointEq(195,2.5,'STAVE',0)

Input and output parameters

name type length inout pnum

@ra float 8 input 1

@dec float 8 input 2

@buffer float 8 input 4

@types varchar 1000 input 3

regionid bigint 8 output 1

type varchar 16 output 2

name	type	length	inout	pnum
@ra	float	8	input	1
@dec	float	8	input	2
@buffer	float	8	input	4
@types	varchar	1000	input	3
regionid	bigint	8	output	1
type	varchar	16	output	2