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.
Stay tuned for our next book pgRouting: A Practical Guide published by Locate Press due out in hard-copy 4th quarter 2017. Content is now feature complete and can purchase e-Book draft and get final when goes to print.
© Leo Hsu and Regina Obe 2014