The residential area of Bristol, where two people died in the explosion, has been declared safe by the police.