FUNCTION  fRegionContainsPointXYZ

Returns 1 if specified region contains specifed x,y,z point, else returns zero.

There is no limit on the number of objects returned, but there are about 40 per sq arcmin.


  • regionid bigint, -- Region object identifier
  • cx float NOT NULL, -- x,y,z of unit vector to this object
  • cy float NOT NULL,
  • cz float NOT NULL,
    Sample call to find if regionID 345 contains the North Pole

    select dbo.fRegionContainsPointXYZ(7,0,0,1)

    see also fRegionContainsPointEq
  • Input and output parameters