FUNCTION  fGetNearestFrameEq

Returns table with a record describing the nearest frame to (@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:

  • 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.fGetNearestFrameEq(185,0,10)
  • Input and output parameters

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