O'Reilly logo

PostGIS Cookbook by Bborie Park, Stephen Vincent Mather, Thomas J. Kraft, Paolo Corti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Geocoding with geopy and PL/Python

In this recipe, you will geocode addresses using a web geocoding API such as Google Maps, Yahoo! Maps, geocoder.us, GeoNames, and so on. Be sure to read the Terms of Services of these APIs carefully before using them in production.

The geopy Python library (http://code.google.com/p/geopy/) offers a convenient, uniform access to all of these web services. Therefore, you will use it to create a PL/Python PostgreSQL function that can be used in your SQL commands to query all of these engines.

Getting ready

  1. Install geopy globally. (You cannot use a virtual environment in this case, as the user running the PostgreSQL service needs to access it on its Python path.)

    In a Debian/Ubuntu box, it is as easy as typing the following: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required