PostGIS in Action
PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. This second edition covers PostGIS 2. Processing data tied to location and topology requires specialized know-how. 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. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. Regina Obe and Leo Hsu are database consultants and authors.
PostGIS in Action , 3rd Edition will be a significant update to the second edition that covers new features in 2. In addition PostgreSQL has changed as well and has added many new speed improvements, new datatypes jsonb , and newer constructs introduction of partitioned tables. We'll cover some of these in performance tuning, PL languages and the Appendixes. For new users, you'll get a good primer on basic functionality of PostGIS as well as a growth path to take advantage of its more unique and gourmet features. You will learn:. We provide PostGIS and PostgreSQL resources, code downloads, data downloads used in the book as well as providing chapter summaries of what is covered in each chapter. On the chapter listing page you will see a paper clip to download code and data for that chapter.