Import/Catalogue/Montagna in Valtellina House Numbers Import
This project is an import of the address dataset provided by Comune di Montagna in Valtellina which is of type shapefile covering the municipal area. The import is currently completed.
Goals
Add address data for Montagna in Valtellina.
Schedule
The import happened in one changeset the 22 of June 2021. The changeset is the 106777493
Import Data
Background
Address format in Montagna in Valtellina
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/yNDToN8tgzaX4QT
Data license: https://wikimediaitalia.nws.netways.de/index.php/s/DZ44jW69aTGyWyn
Type of license (if applicable): CC-BY 4.0 with ODbL addendum
Link to permission (if required): http://www.comune.montagnainvaltellina.so.it/c014044/zf/index.php/atti-amministrativi/delibere/dettaglio/atto/GTVRZekU1VT0-H
OSM attribution (if required): https://wiki.openstreetmap.org/wiki/Contributors#Montagna_in_Valtellina
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
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 and addr:city.
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:poscode will cointain "23020".
- addr:city will contain "Montagna in Valtellina".
Changeset Tags
Changeset will be tagged with:
- source=Comune di Montagna in Valtellina
- source:license=CC-BY
- type=import
- url=https://wiki.openstreetmap.org/wiki/Import/Catalogue/Montagna_in_Valtellina_House_Numbers_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://raw.githubusercontent.com/musuruan/osm_imports/master/montagna_in_valtellina/civici.py
Data Transformation Results
OSM XML file: https://raw.githubusercontent.com/musuruan/osm_imports/master/montagna_in_valtellina/Civici_OSM.osm
Data Merge Workflow
Addresses already in OSM will be extracted using the following Overpass query:
[out:json][timeout:25];
{{geocodeArea:montagna in valtellina}}->.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:
- StefanoLosa (import account: StefanoLosa_import)
With the technical support of users:
References
List all factors that will be evaluated in the import.
Workflow
Step by step instructions:
- Run ogr2osm to export the data in OSM XML:
ogr2osm -e 32632 -t civici.py -f Civici_OSM.shp - Open this file in JOSM
- Run above overpass query to export the existing addresses in another layer
- Merge these addresses, with the help of the JOSM Conflation Plugin
- Download OSM data for the same area
- Run JOSM validator and solve related issues
- 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
The email to the Imports mailing list was sent on 2021-06-08 and can be found in the archives of the mailing list imports [1]. It has been discussed with the local community in the mailing lists talk-it [2] and talk-it-lombardia [3].