What was the 2006 population count of the local government area where Coober Pedy is located?
create table table_23685890_2 (pop_2006 varchar, major_town varchar, PRIMARY KEY (pop_2006))
select pop_2006 from table_23685890_2 where major_town = "coober pedy"