Hurricane Sandy provides ‘wake-up call’ for cities at risk of flooding