CREATE TABLE table_47249 ("Barangay" CLOB, "Urban/rural" CLOB, "Geographic character" CLOB, "Population  ( 2007 ) " FLOAT, "Population  ( 2010 ) " FLOAT)

WHAT IS THE TYPE OF LAND WITH A 2010 POPULATION GREATER THAN 2539, A RURAL AREA, AND A 2007 POPULATION OF 2572?
SELECT "Geographic character" FROM table_47249 WHERE "Population (2010)" > '2539' AND "Urban/rural" = 'rural' AND "Population (2007)" = '2572'
SELECT "Geographic character" FROM "table_47249" WHERE "Population (2007)" = '2572' AND "Population (2010)" > '2539' AND "Urban/rural" = 'rural'