Text this: Reconciling multiple uses of water resources: a case study of the megacities of São Paulo and Shanghai