Is city capitalized in the of San Francisco?

Yes, "city" should be capitalized in "the City of San Francisco." It's a proper noun in this case because it's part of the official name of the city, and proper nouns are always capitalized in English.