Science Hill Pedestrian Bridge to be demolished