Open source geocoding in PostGIS



We will explore the basics of "geocoding" (finding latitude/ longitude from an address string) and "reverse geocoding" (vice-versa) using the PostGIS TIGER geocoder.


Geocoding is the black art of associating a latitude / longitude point with an address, and reverse geocoding is finding the closest address to a given lat/ long. Geocoding is extremely important in geographic applications, as it allows us to use the usual representation of place — the address — with a coordinate that can be processed in a geographic information system. Using the PostgreSQL/ PostGIS command line, this tutorial-style presentation will show how to install the geocoder, how use the geocoder to generate locational point information, and how to generate polygons from these newly geocoded address points. Then we will use explore an extended example dataset, like finding vegan restaurants near my aunt’s house in Cleveland using addresses, boundary polygons, and distances.

Speaking experience


  • Biography

    Webb is a demographer who likes database programming and using open source tools.