GeoNames Forum

Code:

 ----------------------------------------------------------------------------------
 | GEONAMEID   | COUNTRY | ADM1 | ADM2 | ADM3  | ADM4 |   NAME    | ENABLE | USER |
 ----------------------------------------------------------------------------------
 | 7114227	  |		CL	|  12  |  -	  |  -	  |  -   | Santiago  |   0    | 100K |
 | 3871336	  |		CL	|  12  | 131  | 13101 |  -   | Santiago  |   1    | 0K   |
 ----------------------------------------------------------------------------------

We have 100K users from (old) 7114227 geonameid area. We want to move all these users to new geonameid (3871336).
Chile Santiago example is not so difficult. How do we determine if some of big cities are deleted and other new is created?
What is the relationship between oldGeonameID and new one.

Our last update was in 2011. We compared our database with new update. Result: Deleted Admins
ADM1: 16 | ADM2: 190 | ADM3: 369 | ADM4: 45 | ADMD: 1806 | Other admin (ADM5?..): 7
If we do not find new places for that ones lost, we will lose a lot of user’s locations.

My questions:

- How to find new geonameid from old (and deleted) one? (or reverse)
- How to find new places for our users if is deleted?
- What's the hierarchy for example Chile?
- How to download older version of geonames database?
- How to solve our problem in a proper way?

Have anyone ideas how to solve it?