Prioritising Sustainable Development Goals, characterising interactions, and identifying solutions for local sustainability