The “Great City” in Revelation is Jerusalem.  The identification is apparent when the author says it’s the city in which the Lord was crucified (Revelation 11:8). (Though some identify this city as named in other verses in Revelation as either Rome or Babylon).