Guidance aims to help local authorities weigh up renewable energy projects against other environmental concerns