|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
|$49.99||Softbound print book - (includes free ebook)|
|$39.99||Ebook in PDF, epub and Kindle—your purchase includes all three formats!|
|Browse all our mobile format ebooks.|
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.
- An introduction to spatial databases
- Geometry types, functions, and queries
- Applying PostGIS to real-world problems
- Extending PostGIS to web and desktop applications
Familiarity with relational database concepts is helpful but not required.
About the Author
WHAT REVIEWERS ARE SAYING
“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.