Getting network data from the OSM

A popular data source for real-world routing applications is OpenStreetMap (OSM). This recipe shows you how to prepare OSM data for usage with pgRouting using the osm2po command-line tool to convert OSM data to an insert script for PostGIS. Finally, we will test the data import using the pgRoutingLayer plugin.

Getting ready

Download osm2po from http://osm2po.de and unpack the download. Note that osm2po requires Java to be installed on your machine.

You also need a pgRouting-enabled database to follow this recipe.

Additionally, you should have the pgRoutingLayer plugin installed and enabled because we will use this to test the OSM data import.

You can use the wake.pbf OSM file from our sample data, or download your own data from services such as http://download.geofabrik.de.

How to do it…

Open the command line to perform the following steps. If you are working on Windows, we recommend using the osgeo4W Shell:

1. Go to the osm2po folder and open osm2po.config in a text...