GeoNames Forum

Hello,

I have a similar question / problem that I hope you can help me with:

I have downloaded the CA.zip file to study the data and see if Geonames has what I need, and I can't figure out if this releationship exists in the data (for example):

Canada --> 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.