In the article Scott says he lives in a Republican district in a state with a Republican Governor, so he wasn't in San Francisco at the time he wrote this. I live in a Democrat district in a state with a Democrat governor so I can't imagine the political demographics of where we live are that divergent.
San Fran is a city, midwest is a region.
If you took San Fran and Chicago, metro Detroit, Minneapolis, they would probably be similar.
Not to mention San Francisco and the very-nearby Central Valley are likely quite different.
As someone who has lived in most of those places and is familiar with all of them... no.