Charting the green and climate-adaptive city