It was the NCC-1701 E USS Enterprise Sovereign Class Ship. Kirk's Enterprises, the Constitution class & Constitution class refit were also built in the San Francisco yards according to their dedication plaques. See http://memory-alpha.org/wiki/Enterprise_dedication_plaque for more information. However, none of them were constructed in the CITY of San Francisco. They were constructed in a space-dock that either was above SF or was named after SF.
- However, to say they were built in San Francisco would be incorrect, SF fleetyards is the orbital facility we see in Star Trek: The Motion Picture and Star Trek II. -Cpthunt 19:35, May 26, 2011 (UTC)
It should also be noted that starship construction on any particular ship often occurs both on the ground AND in space. As Utopia Planitia Fleet Yards had facilities in space and on the ground. This link shows the components of a Galaxy Class starship being built on the ground: http://memory-alpha.org/wiki/Utopia_Planitia_Fleet_Yards