Burst water pipe leads to flooding on city streets