That appears to be part of the water supply plan (makes a lot of sense to use the water they've got there), and the cistern system appears to have partially functioned: http://www.sfmuseum.net/quake/revawss.html
> The upper zone of the AWSS, however, functioned normally through the earthquake period, and was used to suppress earthquake-caused fires.
