From global trends to local realities: A multi-scale scenario-building methodology for community infrastructure planning