PostGIS in Action (3rd)
Where the adventure begins

PostGIS in Action: (ed. #3) Chapter 10 - Geocoding with tiger geocoder

PostGIS In Action 3rd Edition Chapters    PostGIS In Action 2nd Edition Chapters    1st Edition Chapters
Download chapter code and data

This chapter covers:
  • Address Standardization
  • Geocoding
  • Reverse Geocoding

The tiger geocoder is a suite of SQL functions packaged with PostGIS 2.0+ that utilize Topologically Integrated Geographic Encoding and Referencing (TIGER) U.S. Census data. The tiger geocoder not only makes it easy to batch geocode US data with SQL update statements but also provides geocoding functionality to applications via simple SQL statements. Although the tiger geocoder is specific to the TIGER U.S. data structure, its concepts are useful when creating your own custom geocoder for specialized data sets.

In this chapter you’ll learn how to standardize addresses for geocoding preparation using both built in functions and the PAGC address standardizer, load TIGER data, geocode data, and reverse geocode US data using PostGIS tiger geocoder.

Save 50% off on Third Edition of PostGIS In Action enter mlobe3 in the Promotional Code box when you check out. Offer ends November 25th, 2021

pgRouting: A Practical Guide is now available in Hardcopy from Hardcopy from Amazon. E-Book or Bulk discounts on Hard-copy from Locate Press.

PostGIS in Action,3rd edition MEAP    PostgreSQL: Up and Running       D3.js in Action 2nd Edition   PostGIS Cookbook 2nd edition