SF has plenty of money for transportation. It's just used very ineffectively.
Where is the money going, and/or where should it be going?
What % of people who work in San Francisco also live there?
http://www.sfweekly.com/sanfrancisco/the-worst-run-big-city-...
As for people living vs. working in SF, this comment does an excellent job explaining it, with sources:
https://news.ycombinator.com/item?id=10875936
tl;dr: The increase in population due to daily workers commuting in from outside is vastly smaller than in NYC.