http://forum.geonames.org/gforum/posts/listByUser/401.page JForum - http://www.jforum.net British Columbia --> Vancouver Island --> Victoria I'm looking for a heirarchy of Country --> Province --> Sub Region/Territory (for lack of a better term) --> City I can make the releationship work for Country, Province and City, but adding in the extra layer is the trick I need. The data records for this example are: 5909050 British Columbia 6173336 Vancouver Island 6174041 Victoria This is just one example, and with all the global data available, I'm hoping this could be a feature for any ADM1 and Populated Place (if I properly understood the relationship)? I'm not after a webservice, just need an understanding of the data relationship and I can write the query to make it work. If this is not possible, where can I turn to find what I'm after? Thank you very much for the help! Cheers. Michael.]]> http://forum.geonames.org/gforum/posts/preList/82/2319.page#2319 http://forum.geonames.org/gforum/posts/preList/82/2319.page#2319 GMT