Joined: 08/12/2005 07:39:47
The admin hierarchy is encoded in the adminX structure of the gazetteer file (allCountries.txt). You combine the countrycode and all available admin codes to find the entry in the dame table with the feature type ADMx and the same combination of codes.
Example you have countrycode XX and admincode1 01 then you search for a feature with feature code ADM1 and countrycode=XX and admincode1='01', this is the highest admin division, then you do the same for the ADM2 as a combination of countrycode, admincode1 and admincode2, etc till you have used all admX codes filled out for your feature. Normally you may want to fill a table with the entire hierarchy info encoded in the admX codes.