AltoAdige - Südtirol/OpenGisData HouseNumber Import2
About
On multiple occasions it was announced that a project called OpenGISData.eu is willing to import house numbers of South Tyrol into OSM.
The data to import originates from the autonomous province of Bolzano/Bozen, Italy. The data set (called WEGE) contains about 126.741 addresses and covers the province completely. OpenStreetMap data currently contains only 7666 house numbers.
| OpenStreetMap house numbers | South Tyrol WEGE house numbers |
|---|---|
For the previous, unsuccessful import attempt, see AltoAdige - Südtirol/OpenGISData House Number Import.
License
The province has communicated to be willing to publish most of its data as open data (CC-0).
The OpenGisData.eu project has a special permission to import the housenumbers data into OSM under the ODbL license
OpenGisData.eu mappers meeting
On Friday, 30.01.2014 there was a meeting to discuss this project with the mappers.
This is the presentation made by Mr. Pietro d'Orio about the project
Report of the meeting:
- The mappers and the OpenGisData director's have approved the job done.
- The proposal is to import at once all the new house numbers, using the changeset "OpenGisData.eu" (pending approval of the community)
- The *.osm files "to check" by municipality will be made available on this page. With this *osm files the mappers can do:
- the check of the existings house numbers
- the deletion of the obsolete house numbers
The proposal is to remove all tags addr:* from the buildings, and taking the point geometry (pending approval of the community) because of the following reasons:- The house number entity is by definition a point
- There are many cases where there is more house numbers for each building
- Would be a shame miss the information of the position of the house numbers
Other imports (eg Vienna) have entered the house numbers as pointsDeleted on the advice of the local community
The rules of import
The actions of import and all the rules will be agreed with the OSM community of South Tyrol on the mailing list Talk-it-southtyrol and during the OpenGisData Mappers meeting of December 2013
Finding a pilot town
To verify the analysis and test the import, the community has chosen the municipalities of Martell / Martello as the testing pilot town
| ! |
|---|
OSM tags
addr:country will be omitted, but if already present it will be fixed to 'IT' if incorrect.Deleted on the advice of the local community- addr:city will be inserted using the multi languages rules.
- addr:postcode postcodes actually can be different within municipalities in South Tyrol (e.g. Eppan has 39057 and 39050). The house numbers to be imported have the correct postcode.
- addr:street will be inserted using the multi languages rules, the tags addr:street:de, addr:street:it and addr:street:lld will be checked and updated.
- addr:place some house numbers in South Tyrol does not have an associated street, but are directly related to a place (e.g. a hamlet). For those, the tag addr:place will be used (also according to the multi languages rules).
- addr:hamlet will be used only for house number street-based with the place information.
- addr:housenumber
Multi language rules
South Tyrol is a multilingual region, where both German and Italian are official languages and in some of the municipalities Ladin is the third official language.
How to choose the correct language order for generic name fields
Generic names (such as addr:city) should be populated with every locally official language where the (locally) more commonly used name comes first.
In this import, these non-localized name tags (see above) will be filled using the order provided in this ASTAT table that contains relative percentages of Italian,German and Ladin native speakers for each municipality.
Ladins towns
The municipalities where the majority of people speak Ladin, will be tagged with *:lld at first, for example:
- Badia / Abtei (it and lld names are the same)
- Corvara / Corvara in Badia / Corvara
- La Val / Wengen / La Valle
- Mareo / Marebbe / Enneberg
- San Martin de Tor / St. Martin in Thurn / S. Martino in Badia
- Santa Cristina Gherdëina / S. Cristina Valgardena / St. Christina in Gröden
- Sëlva / Wolkenstein in Gröden / Selva di Val Gardena
- Urtijëi / St.Ulrich / Ortisei
The german attributes will inserted in the *:de tags The italian attributes will inserted in the *:it tags
The street names in Ladin towns are only signposted in Ladin, therefore the following rule is applied:
- the tag addr:street should be the same as addr:street:lld
- the tags addr:street:de and addr:street:it should be populated (if there are apporpriate translations of the respective street name)
Import Documentation
See /Technical Import Documentation about documentation of the software and tools used for transforming the data.
Preliminary analysis
Results of preliminary analysis
- WEGE house numbers: 127.624
- Find match with OSM: 8.331
- New inserts: 117.901
- OSM actual house numbers: 8.987
- Find match with WEGE : 8.331 92,7%
- Not matched with WEGE 656 (to check) 0,7%
Results of preliminary analysis on the pilot municipality Martell / Martello
Here you can download 3 osm files that contains the house numbers to check, to delete and to insert
- WEGE house numbers: 324
- Find match in OSM: 250
- New inserts: 65
- OSM actual house numbers: 259 (253)
- Find match with WEGE : 250 96,5%
- Not matched with WEGE 9 (to delete) 3,5%
- Duplicate data in OSM: some features have the same address tag, for example: 39020 Martell / Martello, Maiern 96
- The 9 house number that not found a match in WEGE are problem like 39020 Martell / Martello, Gand 65. This house number does not exists. Need to be deleted. 4 New house number will be inserted:
- 39020 Martell / Martello, Gand 65/A
- 39020 Martell / Martello, Gand 65/B
- 39020 Martell / Martello, Gand 65/C
- 39020 Martell / Martello, Gand 65/D
Pending questions
There are no more pending questions. See /Pending Questions for in previous issues.
IMPORT
The deadline for any suggestions on the following mailing was 13th February 2014
Import of the housenumbers that are missing in OSM
During the OpenGisData meeting of 1st January 2014 the people have decide to import in one step all the missing house numbers.
The import is announced on the international import mailing list on 7th February 2014 The import of the housenumbers that are missing in OSM (118.723 objects) has been completed 31th March 2014, with 118 requests (one for each municipality) OpenGISData
The tags of the changesets were:
- comment: Import of the housenumbers of South Tyrol - Name of municipality
- created_by: JOSM/1.5 (6502 en)
- source: Provincia Autonoma di Bolzano - Autonome Provinz Bozen (WEGE DB)
- url: https://wiki.openstreetmap.org/wiki/AltoAdige_-_S%C3%BCdtirol/OpenGisData_HouseNumber_Import2
- source:license: CC-0
- type: import
Import of the housenumbers that exist in OSM
Update the existing house numbers
For each municipality exists two files, for example martello_update.zip and martello_check.zip.
Everyone can download this files and do the update via JOSM
How to update the data in JOSM
- Download and install JOSM
- Download the *_update.osm for one municipality from here and load the file in JOSM
- Download the OSM data in a new layer
- Enable the *_update layer, and select one feature
- Copy all the keys/values of this feature
- Switch the editing to the download-data layer
- Select the feature that you want to update
- CTRL+SHIFT+V will paste the keys/values, updating the existing keys/values without losing the existing tags
- Repeat from 4 to 8 until you have finish
- Use the file *_check.osm file to find the corrensponent osm features. If the housenumbers does not exists, delete all the addr:* tags from those OSM features
- Upload the changes. Please use the correct changeset tags for fixing/updating!! (if is possible, do all with one changeset)
- Edit the Get Data table and replace the *_update and *_check link with the link of the changesets. Mark the column COMPLETE with YES when you have finish
The tag to use for the changeset:
- comment: Import of the housenumbers of South Tyrol - Name of municipality
- created_by: (is automatic in JOSM)
- source: Provincia Autonoma di Bolzano - Autonome Provinz Bozen (WEGE DB)
- url: https://wiki.openstreetmap.org/wiki/AltoAdige_-_S%C3%BCdtirol/OpenGisData_HouseNumber_Import2
- source:license: CC-0
- type: fix
Get the Data
In the next table you can find two files for each South Tyrol municipalities:
- TO UPDATE: OSM housenumbers with correspondence with the Province of Bolzano DB (WEGE). Please copy the tags (CTRL+MAIUSC+C) from the *_update.osm file, select the correspondent existing feature in OSM, and paste the tags (CTRL+MAIUSC+V)
- TO CHECK: OSM housenumbers without correspondence with the housenumbers of Public Administration (maybe to delete in OSM, or maybe miss in the WEGE DB)
When you have finished the editing of one municipality, please edit the COMPLETE column typing YES
A good suggestion is insert the Changeset number instead the link of the zipfile