click to
look inside
Look inside
Manning Early Access Program (MEAP) Read chapters as they are written, get the finished eBook as soon as it’s ready, and receive the pBook long before it's in bookstores.
FREE
You can see any available part of this book for free.
Click the table of contents to start reading.

PostGIS in Action, Third Edition

Leo S. Hsu and Regina O. Obe
  • MEAP began August 2019
  • Publication in August 2021 (estimated)
  • ISBN 9781617296697
  • 615 pages (estimated)
  • printed in black & white

placing your order...

Don't refresh or navigate away from the page.
print book Receive a print copy shipped to your door + the eBook in Kindle, ePub, & PDF formats + liveBook, our enhanced eBook format accessible from any web browser. $59.99 pBook + eBook + liveBook
includes previous edition eBook
Additional shipping charges may apply
FREE domestic shipping on orders of three or more print books
PostGIS in Action, Third Edition (print book) added to cart
continue shopping
go to cart

eBook Our eBooks come in Kindle, ePub, and DRM-free PDF formats + liveBook, our enhanced eBook format accessible from any web browser. $47.99 3 formats + liveBook
includes previous edition eBook
FREE domestic shipping on orders of three or more print books
PostGIS in Action, Third Edition (eBook) added to cart
continue shopping
go to cart

Free previous edition eBook included! An eBook copy of the previous edition of this book is included at no additional cost. It will be automatically added to your Manning Bookshelf within 24 hours of purchase.

I thought PostGIS was used for mapping, this book showed me how much PostGIS is actually able to do, and how easy it is to work with it.

Mike Haller
Look inside
PostGIS in Action, Third Edition teaches readers of all levels to write spatial queries for PostgreSQL. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. This fully updated third edition covers key changes in PostGIS 3.0 and PostgreSQL 12, including parallelization support, partitioned tables, and new JSON functions that help in creating web mapping applications.

about the technology

Processing location and topology data requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on nearly any geodata task. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort.

about the book

PostGIS in Action, Third Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-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. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools. Fully updated to the latest versions of PostGIS and PostgreSQL, this Third Edition covers new PostGIS features including Foreign Data Wrappers, Database as a Service, parallelization of queries, and new JSON and Vector Tiles functions that help in creating web mapping applications.

what's inside

  • An introduction to spatial databases
  • Geometry, geography, raster, and topology spatial types, functions, and queries
  • Applying PostGIS to real-world problems
  • Extending PostGIS to web and desktop applications
  • Updated for PostGIS 3 and PostgreSQL 12

about the reader

For readers familiar with relational databases and basic SQL. No prior geodata or GIS experience required.

about the author

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

FREE domestic shipping on orders of three or more print books

A great introduction for any Postgres user that wants to start doing more advanced spatial analysis on their data.

Alvin Scudder

A very clear, concise, and hands on intro to the world of spatial databases.

Dhivya Sivasubramanian

A comprehensive reference for database preparation and manipulation for GIS applications.

Daniel Tomás Lares

A good reference to the functionality provided in PostGIS that also highlights gotchas to look out for.

Billy O'Callaghan

The most valuable book on GIS and PostGIS around.

Jesus Manuel Lopez Becerra

I'm not new to postGIS, but this book has given me several hints to improve my skills.

Daniele Andreis

A very deep dive into PostGIS and related technologies.

Philip Patterson

A comprehensive reference book for the topic. Helpful for beginners as well as advanced users.

Biswanath Chowdhury
RECENTLY VIEWED