The places you described are full of people who would reject the term "liberal" in favor of "leftist". But if you mean most far-left, absolutely Portland, Seattle, and parts of the Bay Area. Cambridge more than Boston itself. Also the gentrifying part of Brooklyn and any community with an elite private liberal arts college.
Basically, if you see a high concentration of non-binary people, Palestinian protests, or people who need to take a shower, there's your answer.
On that note, Berkeley is certainly further left than San Francisco.