select city view logic done