Gaps and investment portfolio in water and climate resilience