Table: local_gov_data
Columns: local_government_area
type
major_town
land_area_km
pop_2006
density_km_2
towns
est

Question: On what year was the local government area with a surface of 4563 square kilometers established?
SQL: SELECT "est" FROM local_gov_data WHERE "land_area_km" = '4563'

Question: Which major town is located within the Outback Areas Community Development Trust?
SQL: SELECT "major_town" FROM local_gov_data WHERE "local_government_area" = 'Outback Areas Community Development Trust'

Question: How many towns exist on the government area with a surface of 110 square kilometers?
SQL: SELECT MIN("towns") FROM local_gov_data WHERE "land_area_km" = '110'

Question: What type of local government area is Yalata?
SQL: SELECT "type" FROM local_gov_data WHERE "local_government_area" = 'Yalata'

Question: What was the 2006 population count of the local government area where Coober Pedy is located?
SQL: SELECT "pop_2006" FROM local_gov_data WHERE "major_town" = 'Coober Pedy'