Well I was off with my guess that it was related to the Westhaven marina works.  It's temporarily holding the pipe which is going to be installed off to the west of the harbour bridge/curran street: https://ourauckland.aucklandcouncil.govt.nz/articles/news/2021/02/another-piece-of-the-stormwater-puzzle-arrives-in-auckland/
