Manning Early
Access Program
PostGIS in Action
EARLY ACCESS EDITION

Regina O. Obe and Leo S. Hsu

MEAP Began: May 2009
Softbound print: Summer 2010 | 425 pages
ISBN: 9781935182269

Pre-Order options*
Order today and start reading PostGIS in Action today through MEAP
  MEAP + Ebook only - $29.99
  MEAP + Print book (includes Ebook) when available - $49.99
* For more information, please see the MEAP FAQs page.
  About MEAP Release Date Estimates    

Table of Contents, MEAP Chapters & Resources

Table of Contents         Resources 
PART I - Learning PostGIS
 1. What is a spatial database? - FREE
 2. Geometry types - AVAILABLE
 3. Data modeling - AVAILABLE
 4. Geometry functions - AVAILABLE
 5. Relating two or more geometries - AVAILABLE
 6. Special reference system considerations - AVAILABLE
 7. Working with real data - AVAILABLE

Part 2 Putting PostGIS to work
 8. Techniques to solve spatial problems - AVAILABLE
 9. Performance tuning - AVAILABLE

Part 3 Using PostGIS with other tools
10. Enhancing SQL with add-ons - AVAILABLE
11. Using PostGIS in web applications
12. Using PostGIS in a desktop environment - AVAILABLE
13. First look at WKT Raster

Appendix A Additional resources - AVAILABLE
Appendix B Installing, compiling, and upgrading - AVAILABLE
Appendix C SQL primer - AVAILABLE
Appendix D PostGreSQL features - AVAILABLE
 

DESCRIPTION

Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code.

PostGIS in Action is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS.

WHAT'S INSIDE:

About the Author

Regina Obe and Leo Hsu are a wife and husband team of database specialists who have been actively involved in the PostGIS community since 2002. Regina is a member of the PostGIS core development team and the Project Steering Committee. Their company, Paragon Corporation, was founded in 1997 and has provided database and GIS solutions for a broad range of clients. They also host two sites: BostonGIS.com and PostgresOnline.com.

About the Early Access Version

This Early Access version of PostGIS in Action enables you to receive new chapters as they are being written. You can also interact with the authors to ask questions, provide feedback and errata, and help shape the final manuscript on the Author Online

Want to learn More?

Sign up to read more content when it is released and to receive news about this book.