I'm really struggling to get my head around how to replicate the basic functionality of an existing site I'm trying to port over to Drupal.
Basically the main pages are locations. These are within regions that are within countries that are within continents:
continent->country->region->location (each level has associated descriptions)
The original site just has a DB with foreign keys in the lower level referencing the ID of the parent - e.g. country will have a continent field referencing the ID of the relevant continent.
I've had some success importing the data and setting up entity references to reflect the above structure. So I now have a country content type with a continent entity reference field pointing to the relevant continent.
What I would like to be able to do is create a view for each continent which lists all the countries below it. And the same for countries and regions etc. These would also be dynamically accessible via the URL, e.g. mysite.com/europe/france/paris
Any suggestions on what I need to do would be hugely appreciated.