FUNCTION  fRegionOverlapId

Returns the overlap of a given region overlapping another one

The parameters
  • @regionid is the region we want to intersect with
  • @otherid is the region of interest
  • @buffer is the amount the regionString is grown in arcmins.

  • Returns a blob with the overlap region,
    NULL if there are no intersections,
    NULL if input params are bad. SELECT * from fRegionOverlapId(1049,6078,0.0)

    Input and output parameters

    nametypelengthinoutpnum
    @bufferfloat8input3
    @regionidbigint8input1
    @otheridbigint8input2
     varbinary-1input0