Managing civic facilities in metropolitan cities