The outcome has been unpopular with most leaders, despite claims it will improve local services