O'Reilly logo

PostGIS in Action by Leo Hsu, Regina Obe

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

Chapter 10. Enhancing SQL with add-ons

 

This chapter covers
  • TIGER geocoder
  • pgRouting
  • PL/R
  • PL/Python

 

In this chapter, we’ll cover common open source add-on tools that are often used to enhance the functionality of PostgreSQL. What makes these tools special is that they unleash the power of SQL, so you can write much more powerful queries than you can with PostGIS and PostgreSQL alone. They also allow for greater abstraction of logic, because you can reuse these same functions and database triggers across all your application queries.

The tools we’ll be covering are as follows:

  • Topologically Integrated Geographic Encoding and Referencing (TIGER) geocoder— A geocoding toolkit with scripts for loading U.S. Census TIGER street data and approximating ...

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