Wilson, Archibald, Commissioner for Queensferry