Prepositions and places: IN, AT, ON

The U.S. president lives in The White House at number 1600 on Pennsylvania Avenue in the city of Washington in the District of Columbia in the United States on Earth. If these are all places, why does English need three different prepositions (in, at and on) to introduce them? Fortunately, the answer follows from general rules about when each of these prepositions should be used.