English speaking use of at and in

USE OF AT AND IN :- At is used to show the small village ,small city
but IN is used to show the big city ,state ,country ,
  I live at ramnagar.
But my father live in Delhi.