Auronzo di Cadore house number import
This page refers to the import of house numbers of the Comune di Auronzo di Cadore in Belluno (BL), Italy. The data used is provided by the Comune di Auronzo di Cadore.
Goals
As of December 2023 many addresses in the Comune di Auronzo di Cadore are missing in OSM. There are only ca. 350 addresses present, while there are ca. ~1,2k numbers (assigned to property entrances) registered in the database of Comune di Auronzo di Cadore.
The goal of the import is to add the missing addresses to the OSM database.
Legal
Data source site (as at December 2023): https://innovationlabdolomiti.openpa.opencontent.io/Dataset/Numeri-civici-Comune-di-Auronzo-di-Cadore
Type of license: Creative Commons CC0 1.0 Universal - Public Domain Dedication (CC0 1.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 InnovationLab Dolomiti portal, precisely at this page.
The data is presented in JSON format and this format will be used for the import.
That data has a collection of elements, one for each house number (property entrance).
Each element has the keys:
- name - the identifier for the street and the house number incl. the letter of the house number;
- address - the postcode of the house number;
- Latitudine - the latitude of house number;
- Longitudine - the longitude of house number.
Import process
Basically 5 steps will be made for the import of the data:
- downloading the data
- cleaning of the useless information of dataset;
- changing dataset key names in valid OSM key names;
- adding other keys,
- importing all the punctual elements of the dataset as nodes in OSM using opendata plug-in.
The first step will be made using Mozilla Firefox, next two steps will be made with Excel, the others with JOSM.
In the second step:
- the data will be filtered leaving only the street name, the house number, postcode and coordinates;
In the third step, for each point:
- for each point the street name will be changed to the name of the street currently preexistenting in OSM (e.g. VIA ROMA will be changed to Via Roma) 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)
- street names will be saved as addr:street, and the house numbers as addr:housenumber,
- the letter part of the addr:housenumber will be changed to lowercase (e.g. 30A => 30a)
In the fourth step, for each point, the keys will be added:
- addr:city with value "Auronzo di Cadore";
- addr:postcode with value "32041"
After step four the ready *.osm file would be as follows.
In the fifth step an upload of the points as nodes (according to the IT convention) 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.
People involved
- data preparing & import process - szydzio via import-account
- technical & legal consultation - Andrea Musuruane
Problems and improvements
I expect some problems with the import like e.g.:
- 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,
- 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 ,
- some house number may correspond to a road that is currently missing in OSM - it will be mapped later separately (possibly with the help of local mappers, who offered their support).
QA
After the import possible errors will be checked with Nominatim QA , particularly with the Suspicious addr:street tag layer and OSM Inspector.
Schedule
The changesets were uploaded as follows:
- changeset 149283603
- changeset 149525064
- changeset 149634263
- changeset 149897004
- cangeset 150253657