6 Geometry and geography functions

This chapter covers

  • Output functions
  • Constructor functions
  • Accessor and setter functions
  • Measurement functions
  • Composition and decomposition functions
  • Simplification functions

In previous chapters we’ve discussed PostGIS spatial types—how to create them and how to add them to your database. In this chapter we’ll introduce the core set of functions that work with the geometry and geography spatial types. This chapter concentrates on functions that work with single geometries and geographies.

PostGIS offers lots of functions and operators, and in this chapter we’ve grouped them by intent of use. This is by no means a rigorous classification, nor one that will neatly sort each function into a unique group without ...

Get PostGIS in Action, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.