Reddit reviews Birds of the Sierra Nevada: Their Natural History, Status, and Distribution

This is a decent site for Lake Merritt. Most of the parks have a page on iNaturalist (like this); they're not super accurate, but make an okay entry point to identification.

For ID'ing individual birds in the field, the Sibley app is popular with birders.

For more in-depth info, Birds of the Sierra Nevada is very good--there is a ton of overlap between our local birds and birds in the mountains and foothills, so most of the birds you'd see around town are addressed in great detail.