FUNCTION  fGetNearbyFrameEq

Returns table with a record describing the frames neareby (@ra,@dec) at a given @zoom level.


ra, dec are in degrees. Zoom is a value in Frame.Zoom (0, 10, 15, 20, 30).
this rountine is used by the SkyServer Web Server.

returned table is sorted nearest first:

  • fieldID bigint, -- field identifier
  • a float NOT NULL , -- abcdef,node, incl astrom transform parameters
  • b float NOT NULL ,
  • c float NOT NULL ,
  • d float NOT NULL ,
  • e float NOT NULL ,
  • f float NOT NULL ,
  • node float NOT NULL ,
  • incl float NOT NULL ,
  • distance float NOT NULL distance in arc minutes to this object from the ra,dec.
    Sample call to find frame nearest to 185,0 and within one arcminute of it.

    select *
    from dbo.fGetNearbyFrameEq(185,0,1)

    see also fGetNearestFrameEq
  • Input and output parameters

    nametypelengthinoutpnum
    @zoomint4input4
    @rafloat8input1
    @decfloat8input2
    @radiusfloat8input3
    afloat8output2
    bfloat8output3
    cfloat8output4
    dfloat8output5
    efloat8output6
    ffloat8output7
    nodefloat8output8
    inclfloat8output9
    distancefloat8output10
    fieldIDbigint8output1