Where do the most lesbians live?

Everywhere. There is no magical, hidden place or island of lesbians.

San Francisco in California is well known for it's high gay population.

San Francisco is just one place that has a high population of gay people. There are many other cities like Chicago, Seattle, NYC, Atlanta etc.