How to know the ADM1 parent place fom some ADM2 register on allCountries.txt

aurium — GMT

Hi, i had downloaded allCountries CSV dump from http://download.geonames.org/export/dump/ and i'm trying to find some places, like on this example: Code:

egrep 'Salvador.*\sADM2\sBR\s' allCountries.txt

I get 4 city registers from Brazil, but i can't be sure in what brazilian state (ADM1) that is. There is a way to know that, only with allCountries.txt data? If not, how about to extend this CSV with more one column with lower level related place?

Latest posts for the topic "How to know the ADM1 parent place fom some ADM2 register on allCountries.txt"

How to know the ADM1 parent place fom some ADM2 register on allCountries.txt