Padova house numbers import

This page refers to the import of house numbers of the city of Padova in Italy. The data used is provided by the municipality of Padova.

Goals

As of August 2022 many addresses in the city of Padova are missing in OSM. There are only ca. ~4k addresses present, while there are ca. ~57k numbers (assigned to property entrances) registered in the database of municipality of Padova.

The goal of the import is to add the missing addresses to the OSM database.

Legal

Data source site (as at April 2023): https://dati.veneto.it/content/numeri-civici-del-comune-di-padova-2020

Type of license: CC BY 4.0

Dedicated upload account: https://www.openstreetmap.org/user/szydzio-imports

The import has been discussed on the Italian OSM mailing list.

Dataset

The dataset is available at the opendata of Veneto regional portal, precisely at this page .

The data is presented in different formats, the format used for the import is csv.

That csv has a collection of punctual elements, one for each house number (property entrance).

Each node has the keys:

• Codice Via - the identifier for the street;
• Esponente - the letter of the house number;
• Civico - the house number;
• Nome Via - the name of the street of the house number;
• Latitudine - the latitude of house number;
• Longitudine - the longitude of house number.

Import process

Basically 4 steps will be made for the import of the data:

1. cleaning of the useless information of dataset;
2. changing dataset key names in valid OSM key names;
3. adding other keys,
4. importing all the punctual elements of the dataset in points in OSM using opendata plug-in.

The first two steps will be made with Excel, the others with JOSM.

In the first step:

• the column Codice Via will be deleted;
• rows with empty Nome Via will be deleted;
• for each point the dots and the digits in the column Civico will be deleted leaving a plain number;
• or each point the value of Nome Via will be changed to the name of the street currently preexistenting in OSM (e.g. VIA ABBA GIUSEPPE CESARE will be changed to Via Giuseppe Cesare Abba) in order not to produce addresses unable to be found later by Nominatim (the house number attached to an existing street nearby should have exactly the same name as the street in addr:street)

In the second step, for each point:

• the column Civico will be changed in addr:housenumber , the letter from the column Esponente will (when having a value different than "-") be merged with the house number;
• Nome Via will be changed in addr:street;

In the third step, for each point, the keys will be added:

• addr:city with value "Padova" (Padua in Italian);
• source:addr with value "Comune di Padova" (Padua municipality in Italian).

In the fourth step an upload of the points will be executed in bunches of no more than 500 elements in order to carefully cope with the data and revert them easily using JOSM's Reverter plug-in, should something go wrong.

Problems and improvements

I expect some problems with the import like e.g.:

1. some address may already be present in the OSM database - they will be left unchanged, the data will be filtered with JOSM's validator in order not to produce duplicated numbers with this import,
2. if the address already present in OSM are not correct (e.g. have a typo in addr:street or missing addr:street) they will be corrected ,
3. some house number may correspond to a road that is currently missing in OSM - it will be mapped later separately with the help of local mappers, who offered their support.

After the import possible errors will be checked with Nominatim QA.

Schedule

The first changeset was uploaded on 14th August 2022.

Next changesets will be uploaded successively.