Thanks to Weebl, I have found out the name and what is going on with this ship I saw the other day. It is the USS Holland, one of the first Ballistic Missile Submarine tenders, launched in 1963 in Mississippi and decommissioned in 1996 in Guam. It is being readied at Mare Island for its journey via the Panama Canal to Galveston TX where it will be scrapped. It was named for John Phillip Holland, considered the father of the modern submarine.
20130710-_MG_7619 by
lennycarl08, on Flickr