Oakland handles all the container ships, SFO is in unincorporated San Mateo County, and the public transit is objectively bad - terrible compared to New York, Boston, or Chicago (and possible other cities I haven't been to).