For crime, check out this website: http://www.crimereports.com
A map of the best performing schools in San Francisco shows most of them to be in the western part of the city where you're more likely to encounter fog. You may have to do a balancing act between weather and school quality. Central neighborhoods such as Noe, Bernal Heights, Glen Park would be good starting points.
You might also want to consider Marin County -- in particular the communities immediately north of the Golden Gate Bridge such as Sausalito, Mill Valley, Corte Madera, Tiburon, Larkspur, Kentfield, Greenbrae.. Although this will obviously increase your commute time to Millbrae (and as a practical matter it will have to be by car), Marin has consistently very high performing schools.
Prudential California Realty
1715 Polk St., San Francisco, CA 94109
Millbrae is know for its good school district, will be very close to your work! Home quality is great. Sunny all the time. Bart and train will take you to the whole bay area. Twenty minutes to the city of San Francisco. Half hour to Standford university, 40 minutes to Silicon Valley