What political party does the person from San Diego belong to?
CREATE TABLE "former_members" (
  "name" text,
  "residence" text,
  "party" text,
  "years_in_assembly" text,
  "years_in_senate" text
);
SELECT "party" FROM "former_members" WHERE "residence"='san diego';