Managing climate risks: new evidence from integrated analysis at the basin scale