What was the 2006 population count of the local government area where Coober Pedy is located?
CREATE TABLE "table1_23685890_2" (
  "local_government_area" text,
  "type" text,
  "major_town" text,
  "land_area_km" text,
  "pop_2006" real,
  "density_km_2" real,
  "towns" real,
  "est" real
);
SELECT "pop_2006" FROM "table1_23685890_2" WHERE "major_town"='Coober Pedy';