GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Italy - Provinces  XML
Forum Index -> Administrative Divisions
Author Message
mcjennis



Joined: 06/04/2007 23:37:04
Messages: 14
Offline

There are a lot of problems with admin2 subdivision in Italy for example Piemonte has 8 "province" but the db dump show only 5. Is it possible to solve this problem using the wiki area or it is a privileged job?
I am reorganizing your database for the greater country in Europe for using that in a big web project, so I am finding a lot of errors.
I would like to provide my help for adjust that errors.
My database structure is

CREATE TABLE Zones (
id INT NOT NULL,
parent_id INT NOT NULL,
name VARCHAR(255) NULL,
country_code CHAR(3) NULL,
feature_class CHAR(1) NULL,
parent_code CHAR(2) NULL,
admin1name VARCHAR(255) NULL,
admin1code CHAR(2) NULL,
admin2name VARCHAR(255) NULL,
admin2code CHAR(2) NULL,
admin3name VARCHAR(255) NULL,
admin3code CHAR(2) NULL,
PRIMARY KEY(id),
INDEX Zones_FKIndex1(parent_id),
FOREIGN KEY(parent_id)
);

My objective is to create a hierarchical tree structure for the European bigger country.
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

It is true, our data base is missing some 'new' provinces for Italy. Geonames.org has 94 provinces for Italy, but there are now 110 provinces. 16 provinces are missing in the geonames data base. There was a restructure in Italy in 1995 and our database is missing these 'new' entries.

It would be fantastic if you could help us fix this problem. You can add the 16 missing provinces with the wiki interface. Only the assignment of the admincode2 is a bootstrapping effort and has to be done directly on the database. I will take care of this.

Next step will be admin level 3 for Italy. For adm3 we have as good as nothing (144 our of 8100 communes).

Marc

[WWW]
mcjennis



Joined: 06/04/2007 23:37:04
Messages: 14
Offline

You are slightly wrong. In Italy we have 107 Provinces:
http://www.comuni-italiani.it/province.html
not 110...
I did a few of corrections but how can I count all adm2 for italy?
this
http://www.geonames.org/search.html?q=adm2&country=IT
show me only 50 how about to see the others?
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

You are right, I have only read the first paragraph of the wikipedia entry :
Attualmente le province italiane sono territorialmente 110, cui corrispondono 109 Amministrazioni Provinciali, suddivise in 20 regioni. 

further down they write :
nel 2004 il Parlamento ha istituito le 3 province di Monza e della Brianza, di Fermo e di Barletta-Andria-Trani che diverranno operative nel 2009 portando il numero complessivo delle province a 110 (inclusa la Valle d'Aosta). 

It means now there are 107 Italian provinces and in 2009 they will be 110 provinces in Italy.


You can add the parameter maxRows to the search url to display more rows :
http://www.geonames.org/search.html?q=adm2&country=IT&maxRows=200

[WWW]
mcjennis



Joined: 06/04/2007 23:37:04
Messages: 14
Offline

How can you change all the cities from the previous province to the new one? Is it a manual procedure? Or do you have an automatic or semiautomatic procedure?
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

I have added the adminCode2 to all Italian provinces.

Normally we determine provinces with the use of boundary shape files. For the new provinces we don't have any shape files and we will have to find an other solution. If you know of some simple rules like 'everything north of this latitude is part of this new province' we can do a batch update directly on the database.

[WWW]
mcjennis



Joined: 06/04/2007 23:37:04
Messages: 14
Offline

I don't think it could be possible... to determine a rectangular shape, I think you have to insert the new province boundary file. And go batching.
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

Do you know where we can get the new province boundary file?

[WWW]
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team