CREATE TABLE table_1847180_4 (district VARCHAR, vacator VARCHAR)

Which district did Ralph Harvey (r) vacated when he resigned?
SELECT district FROM table_1847180_4 WHERE vacator = "Ralph Harvey (R)"
SELECT "district" FROM "table_1847180_4" WHERE "Ralph Harvey (R)" = "vacator"