WHAT IS THE TYPE OF LAND WITH A 2010 POPULATION GREATER THAN 2539, A RURAL AREA, AND A 2007 POPULATION OF 2572?
CREATE TABLE table_47249 (
    "Barangay" text,
    "Urban/rural" text,
    "Geographic character" text,
    "Population (2007)" real,
    "Population (2010)" real
)
SELECT "Geographic character" FROM table_47249 WHERE "Population (2010)" > '2539' AND "Urban/rural" = 'rural' AND "Population (2007)" = '2572'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: WHAT IS THE TYPE OF LAND WITH A 2010 POPULATION GREATER THAN 2539, A RURAL AREA, AND A 2007 POPULATION OF 2572? ### Input: CREATE TABLE table_47249 (
    "Barangay" text,
    "Urban/rural" text,
    "Geographic character" text,
    "Population (2007)" real,
    "Population (2010)" real
) ### Response: SELECT "Geographic character" FROM table_47249 WHERE "Population (2010)" > '2539' AND "Urban/rural" = 'rural' AND "Population (2007)" = '2572'