Chabot Space and Science Center is in Oakland. When I took my CSET exam (which was difficult), I celebrated afterward with a trip to a Science center, of course!
It was very astronomy focused, but they did have a large section on sustainability with Bill Nye specifically for kids. We watched two planetarium shows: Many Moons and Tales of the Mayan Sky.
Here are some photos from that trip: