Is the word "mayor" capitalized when it follows the city name? As in, San Francisco Mayor John Doe or San Francisco mayor John Doe?
Regardless of the fact that a location or other proper noun precedes it, you do capitalize a title if it precedes a name.
Capitalize a person's title when it precedes the name. Do not capitalize when the title is acting as a description following the name.
Examples: Chairperson Petrov Ms. Petrov, the chairperson of the company, will address us at noon.