I'm having a hard time figuring out how to get parent features. I've got the administrative features figured out but how do you get that Mount Everest(geonameid=1283416) has a parent feature of Nepal (geonameid=128298
I've looked and it's definitely not coming from the hierarchy table which is a table I still don't understand since it seems to mostly duplicate the administrative hierarchy that's available from geonames table with some other random junk in there.
There is a single adm2 division but I can't figure out how to find that. It says it's Burleson which is goenameid 4677551 but that has fclascode P.PPL not ADM2 and there is no entry with country = TX and admin2 = '051'
It can't come from the cc2 column because it's not a country.
12110882 doesn't appear as a child in any entry in the hierarchy table.
So after looking at it I'm really not sure how you're supposted to find the adm2 if the adm1 is null. Adm2 isn't unique within a hierarchy. You can have multiple adm1's for any given adm2. There are 36 adm2's (051). How did you figure out that 12110882's was the one in TX?