Transferring from BART to Amtrak is easy as others have mentioned. Depending on the time of day, you may have to transfer up to two times.
The are around the station is decent, but I wouldn't venture more than a few blocks out. If you are going to Santa Rosa, consider taking Golden Gate Transit from SF. (use 511.org to plan your trip).