FUNCTION  fPolygonsContainingPointXYZ

Returns regions containing a given point

The parameters
  • @x, @y, @z are unit vector of the point on the J2000 celestial sphere.
  • @buffer_arcmin

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

    Input and output parameters

    nametypelengthinoutpnum
    @xfloat8input1
    @yfloat8input2
    @zfloat8input3
    @buffer_arcminfloat8input4
    RegionIDbigint8output1