When the mayor of New York took a helicopter to Manhattan Beach , Brooklyn , for a three-hour walking tour , one of his photo opportunities was at the sea wall along Sheepshead Bay , which officials told him was pockmarked by dangerous holes and sections on the verge of collapse .