San Vito di Cadore house numbers import

From OpenStreetMap Wiki
Jump to navigation Jump to search

This page refers to the import of house numbers of the Comune di San Vito di Cadore in Italy. The data used is provided by the Comune di San Vito di Cadore.

Goals

As of July 2023 many addresses in the Comune di San Vito di Cadore are missing in OSM. There are only less than 100 addresses present, while there are ca. ~1.5k numbers (assigned to property entrances) registered in the database of Comune di San Vito di Cadore.

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

Legal

Data source site (as at July 2023): https://innovationlabdolomiti.openpa.opencontent.io/Dataset/Numeri-civici-Comune-di-San-Vito-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:

  1. downloading the data
  2. cleaning of the useless information of dataset;
  3. changing dataset key names in valid OSM key names;
  4. adding other keys,
  5. importing all the punctual elements of the dataset in points 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 stored 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:

After step four the ready *.osm file would be as follows.

In the fifth 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.

People involved

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.

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:

  1. changeset 140691200
  2. changeset 140693995
  3. changeset 140710533
  4. changeset 140713265