[mkgmap-dev] How to add millions of addresses to your garmin maps of France

Mon Feb 2 07:06:31 GMT 2015

Hi map makers,

The french OSM community has recently created an address database for France, under the ODbL licence. By using this database, we can build Garmin maps with 6 times more addresses than only OSM data.

It's built from various sources besides OSM data. Thanks to the land tax administration, we french OSM mappers have access to the complete "cadastre" (i.e. building shapes, street names and addresses) covering the entire country.
This information, with OpenData adresses and OSM data on the side, is now mashed up into the "BANO" database. 11+ million addresses have been matched to a street name in OSM, 1.4 million addresses are gathered from the OpenData files of several cities, 2.6 million come from OSM. Those numbers will improve over time, as this DB is not complete yet.
See a map at [1], green dots are OSM addresses, blue ones addresses matched to a street name, yellow dots are from OpenData files and red are addresses not yet matched to an existing street name.

How to add the addresses when creating Garmin maps ?
The data is available in CSV format, geographically split following the "département" boundaries (admin_level 6). The steps are : 
Download a fresh .pbf Geofabrik file of France (admin_level 2) or one of its "région" (admin_level 4)
Download the BANO CSV files covering the previously downloaded area
Merge the CSV files. 
Filter address source to keep only matched addresses and OpenData addresses (blue and yellow dots).
Convert the CSV format to OSM format.
Merge the .osm file to the Geofabrik file.
Launch your usual map generation workflow with this new file.

I wrote a shell script that does all of the above. It's published on https://github.com/PacoTyson/bano2garmin/ and attached as a zip archive.

The prerequisites are awk, wget or curl and osmconvert ( http://wiki.openstreetmap.org/wiki/Osmconvert ). 

You'll have to edit the script to configure it to your installation : 
BANODIR=directory where the script will download and store the BANO files
PBFDIR=directory where the .pbf files are read and written
BINDIR=directory where osmconvert is stored
Usage : add-bano-addresses.sh region 
where region can be france or any of those listed on http://download.geofabrik.de/europe/france.html

 [1] : http://layers.openstreetmap.fr/?zoom=6&lat=46.4&lon=2.3508&layers=B0000FFFFFFFFFFFFFFFFFFFFFT

Cheers,
Paco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mkgmap.org.uk/pipermail/mkgmap-dev/attachments/20150202/3d3b6c7a/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bano2garmin.zip
Type: application/zip
Size: 10242 bytes
Desc: not available
URL: <http://www.mkgmap.org.uk/pipermail/mkgmap-dev/attachments/20150202/3d3b6c7a/attachment-0001.zip>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mkgmap.org.uk/pipermail/mkgmap-dev/attachments/20150202/3d3b6c7a/attachment-0003.html>