FUNCTION  fPolygonsContainingPointEq

Returns regions containing a given point

The parameters
  • @ra, @dec are the J2000 coordinates of the point.

  • Returns empty table if input params are bad.
    Returns a table with the columns
    RegionID BIGINT NOT NULL PRIMARY KEY SELECT * from fPolygonsContainingPointEq(180,-2,0)

    Input and output parameters

    nametypelengthinoutpnum
    @rafloat8input1
    @decfloat8input2
    @buffer_arcminfloat8input3
    regionidbigint8output1