PostGIS in Action
Second edition of this book is now available

Regina O. Obe and Leo S. Hsu
Foreword by Paul Ramsey

April 2011 | 520 pages | B&W
ISBN: 9781935182269

$49.99 pBook + eBook (includes PDF, ePub, and Kindle)
$39.99 eBook only (includes PDF, ePub, and Kindle)
Browse all our mobile format eBooks.


 Look Inside Resources Downloads


PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing you to create location-aware queries with just a few lines of SQL code, and provides a back-end for mapping applications with minimal effort.

PostGIS in Action teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. The book covers PostgreSQL 8.4, 9.0, and 9.1 features and shows you how to integrate with other GIS tools.


Familiarity with relational database concepts is helpful but not required.

About the Author

Regina Obe and Leo Hsu are database consultants. Regina is a member of the PostGIS core development team and the Project Steering Committee. They are hosts of and


“After spending a couple weeks looking through the book, I have to say that I am very impressed with the quality and completeness. Indeed, this is the book that I wish would have been available when I was starting out with PostGIS. The authors do an excellent job of promoting the idea that a relational database and SQL are well suited for spatial data modeling and analysis.”
Dylan Beaudette, California Soil Reserve Lab

“What truly unifies this book is the clarity and purpose of writing. Wherever the subject matter becomes abstract or difficult to grasp the authors have gone to great lengths to break the problem down into attainable steps, providing clear and patient guidance throughout.”
Mark Leslie, Software Architect, LISAsoft Pty Ltd

“This book addresses a problem I have run into repeatedly in my consulting work: educating database professionals (DBAs, developers, etc.) on working with spatial data in a manner that they are familiar with. The authors are extremely knowledgeable about database technologies of all kinds and it comes through here.”
William Dollins, Senior Vice President, Zekiah Technologies, Inc.