GeoNames Forum

we have some new ADM2 subs to add (like "Fermo").

When i try to bind existing ADM3 subs to new ADM2 it says:

"error while saving: no code defined for this admin division."

Example check "provincia di Fermo"..

And another question: how can i bind every 40 ADM3 subs to the new "provincia di Fermo" at one time

?

http://en.wikipedia.org/wiki/Province_of_Fermo

full ADM3 list of "Fermo" (that should already exists in db)

http://www.tuttitalia.it/marche/78-provincia-di-fermo/16-comuni/popolazione/

this is the sql that i used locally

UPDATE ..... set admin2='FM' where country='IT' and admin1='10' and name IN ('Altidona','Amandola','Belmonte Piceno','Campofilone','Falerone','Fermo','Francavilla d\'Ete','Grottazzolina','Lapedona','Magliano di Tenna','Massa Fermana','Monsampietro Morico','Montappone','Montefalcone Appennino','Montefortino','Monte Giberto','Montegiorgio','Montegranaro','Monteleone di Fermo','Montelparo','Monte Rinaldo','Monterubbiano','Monte San Pietrangeli','Monte Urano','Monte Vidon Combatte','Monte Vidon Corrado','Montottone','Moresco','Ortezzano','Pedaso','Petritoli','Ponzano di Fermo','Porto San Giorgio','Porto Sant\'Elpidio','Rapagnano','Santa Vittoria in Matenano','Sant\'Elpidio a Mare','Servigliano','Smerillo','Torre San Patrizio')

thanks

please help.........

The admin2 code was missing for Fermo. I have added 'FM' and also updated the 40 adm3.

Marc

ok so only you can edit an ADM division and add the admin2 code?!

So please check Italy->sicily->"siracusa" because i did a mistake and i think it lost the admin2 code.

Then there are some others ADMIN2 to add... i will post them here.

Thanks

I had already restored the adm2 code for Siracusa when i added the code for Fermo

There is no userinterface edit function to add the admincode for administrative divisions. It has to be modified directly on the database.

Marc

ok thanks

These are the other 2 new italy's provinces (ADM2):

----
http://it.wikipedia.org/wiki/Provincia_di_Barletta-Andria-Trani

NAME: Provincia di Barletta – Andria – Trani
ADM2 code: BT
parent ADM1 code: 13
list of 10 adm3 :

Andria, Barletta, Bisceglie, Canosa di Puglia, Margherita di Savoia, Minervino Murge, San Ferdinando di Puglia, Spinazzola, Trani, Trinitapoli

----

http://it.wikipedia.org/wiki/Provincia_di_Monza_e_della_Brianza

NAME: Provincia di Monza e della Brianza
ADM2 code: MZ
parent ADM1 code: 09
list of 50 adm3:

Agrate Brianza, Aicurzio, Albiate, Arcore, Barlassina, Bellusco, Bernareggio, Besana in Brianza, Biassono, Bovisio Masciago, Briosco, Brugherio, Burago di Molgora, Camparada, Carate Brianza, Carnate, Cavenago di Brianza, Ceriano Laghetto, Cesano Maderno, Cogliate, Concorezzo, Correzzana, Desio, Giussano, Lazzate, Lesmo, Limbiate, Lissone, Macherio, Meda, Mezzago, Misinto, Monza, Muggiò, Nova Milanese, Ornago, Renate, Ronco Briantino, Seregno, Seveso, Sovico, Sulbiate, Triuggio, Usmate Velate, Varedo, Vedano al Lambro, Veduggio con Colzano, Verano Brianza, Villasanta, Vimercate

Thanks. They have been added.

Marc