Postgis in Action

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

PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.

Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.