Import/Catalogue/Sondrio House Numbers Street Import

From OpenStreetMap Wiki
Jump to navigation Jump to search

This project is an import of the address dataset provided by Comune di Sondrio which is of type shapefile covering hamlets in the municipal area.

Goals

Add address data for Sondrio.

Schedule

This import has been made on Feb 27th, 2023: changeset #133097017.

Import Data

Background

Address format in Sondrio's hamlets

Example of metric numbering

The assignment of the house number was made following the metric method. This method provides that the access of the house is connected to the circulation area named by the Municipality (via-avenue-alley ...) on which the house stands. The circulation area is defined with a continuous and single line with a previously defined direction. The house will then be assigned the linear meter number of the traffic area to which it connects, with an approximation to the nearest even meter, in the case of access coming from the right side; or an approximation to the nearest odd meter in the case of access coming from the left side. The connection between the access to the house and the circulation area, depending on the case, can be unique or can be shared with other accesses. In the latter case, the house number of each house, in addition to the meter number, will also have a letter of the alphabet.

Legal

Data source site: https://wikimediaitalia.nws.netways.de/index.php/s/HZ2P6KSMF2mf94X
Data license: https://istanze.comune.sondrio.it/openweb/portal/getDoc.php?f=documenti/1155_allegato_a_licenza_cc_by_4_1651049846.pdf.p7m&CSRF=b8f6b26a696e891d0a21889958be6c1f
Type of license (if applicable): CC-BY 4.0 with ODbL addendum
Link to permission (if required): https://istanze.comune.sondrio.it/openweb/pratiche/dett_registri.php?id=1155&codEstr=P_OP&CSRF=b8f6b26a696e891d0a21889958be6c1f
OSM attribution (if required): https://wiki.openstreetmap.org/wiki/Contributors#Sondrio
ODbL Compliance verified: yes

OSM Data Files

See #Data Transformation Results.

Import Type

This is a one-time import. The dataset will be imported as a single changeset using JOSM.

Data Preparation

Data Reduction & Simplification

N/A

Tagging Plans

The source data is presented as a shapefile.

This shapefile consists in a collection of punctual elements, one for each housenumber.

Each node has the following keys:

  • ID_VIA: id of the street referring to the street book
  • CIVICO: housenumber with subordinate
  • NOME_VIA: street name
  • LATO: road side
  • ID_VIA_OLD: id of the old street referring to the street book
  • CIVICO_OLD: old housenumber with subordinate
  • NOMEVIAOLD: old street name
  • CAP: zip code
  • NOME_COM: municipality name

The shapefile will be converted to OSM XML using ogr2osm. The projection must be specified as “EPSG:32632 (WGS 84 / UTM zone 32N)”.

The tags that will be used in the final upload are addr:housenumber, addr:street, addr:postcode, addr:city, old_addr:housenumber and old_addr:place.

The tags will be as follows:

  • addr:housenumber will contain the number in CIVICO converted to lowercase (for subordinates).
  • addr:street will contain the street name in NOME_VIA but normalized to follow Italian conventions.
  • addr:postcode will contain the zip code in CAP.
  • addr:city will contain the municipality name in NOME_COM.
  • old_addr:housenumber will contain the number in CIVICO_OLD converted to lowercase (for subordinates).
  • old_addr:place will contain the place name in NOMEVIAOLD.

Changeset Tags

Changeset will be tagged with:

  • source=Comune di Sondrio
  • source:license=CC-BY
  • type=import
  • url=https://wiki.openstreetmap.org/wiki/Import/Catalogue/Sondrio_House_Numbers_Street_Import

Data Transformation

ogr2osm will be used to convert the shapefile to OSM XML format using the above tagging plan.

ogr2osm translation file can be found at https://github.com/SeTesrl/osm/blob/main/civici.py

Data Transformation Results

OSM XML file: https://wikimediaitalia.nws.netways.de/index.php/s/5Ctm2GRrKGm52yE

Data Merge Workflow

Addresses already in OSM will be extracted using the following Overpass query:

[out:json][timeout:250];
area["boundary"="administrative"]["admin_level"=8]["name"="Sondrio"]->.searchArea;
nwr[~"^addr:.*$"~"."](area.searchArea);
(._;>;);
out meta;

There are just a few housenumbers.

In Italy, address data must be placed exclusively on nodes because the housenumber identifies the external access that leads from the street to the housing units (houses, stores, offices, etc). Therefore addresses placed on buildings will be removed.

Addresses already present will be merged using the JOSM Conflation Plugin.

Team Approach

The import will be one time import done by:

With the technical support of users:

References

List all factors that will be evaluated in the import.

Workflow

Step by step instructions:

  1. Run ogr2osm to export the data in OSM XML: ogr2osm -e 32632 -t civici.py -f Civici_OSM.shp
  2. Open this file in JOSM
  3. Run above overpass query to export the existing addresses in another layer
  4. Merge these addresses, with the help of the JOSM Conflation Plugin
  5. Download OSM data for the same area
  6. Run JOSM validator and solve related issues
  7. Upload the changeset in OSM

The changeset will be small enough to be uploaded at once.

In case of import problem the changeset will be reverted using the JOSM Reverter Plugin

Conflation

See #Data Merge Workflow.

QA

Street names

After the import, addr:street names could be slightly different than current street names.

These differences should be caught using OSM Inspector.

Unmarked streets

The result can be used to locate areas where streets are missing.

Missing roads will be created in JOSM using PCN 2012 areal images.

Unnamed streets

The result can be used to derive street names for unnamed streets when all the nodes along the street has the same addr:street value.

Missing road names will be identified using the OpenStreetMap NoName Map Overlay:tms:http://tile3.poole.ch/noname/{zoom}/{x}/{y}.png

OSM Inspector can also be used to find these streets.

See also

This import has been discussed with the local community in the mailing lists talk-it and talk-it-lombardia starting on Oct 13th, 2022.

The email to the Imports mailing list was sent on Jan 12th, 2023 and can be found in the archives of the mailing list talk-import.