Paragon Corpoation PostGIS Spatial Database Engine OSGeo.org The Open Source Geospatial Foundation UMN Mapserver    PostGreSQL Object Relational Database Management System
Home   GIS Books   About Boston GIS   Consulting Services  Boston GIS Blog  Postgres OnLine Journal

We offer books about Geographic Information Systems(GIS) and managing spatial databases.We focus on Open Source GIS, OGC standard compliant books, Geometric and Geographic theory bools and spatial database books. No spatial database understanding would be complete without good solid database understanding. In our database section, we offer books on the fundamentals of SQL, Good database design, and specifics on using PostgreSQL, Oracle, SQL Server, MySQL, and SQLite. We also offer a selection of GPS devices and Accessories for the Neo-Geographer.

PostGIS in Action   GIS Books   Web Mapping Books

PostGIS in Action, 2nd Edition
 
Amazon Price: $40.74    Lowest Used Price: $31.01 Lowest New Price: $36.73

Summary

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.0 and 2.1 series, PostgreSQL 9.1, 9.2, and 9.3 features, and shows you 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.

About the Book

Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. 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.

PostGIS in Action, Second 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.

Familiarity with relational database and GIS concepts is helpful but not required.

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 2.x and PostgreSQL 9.x

About the Authors

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.

Table of Contents

    PART 1 INTRODUCTION TO POSTGIS
  1. What is a spatial database?
  2. Spatial data types
  3. Spatial reference system considerations
  4. Working with real data
  5. Using PostGIS on the desktop
  6. Geometry and geography functions
  7. Raster functions
  8. PostGIS TIGER geocoder
  9. Geometry relationships
  10. PART 2 PUTTING POSTGIS TO WORK
  11. Proximity analysis
  12. Geometry and geography processing
  13. Raster processing
  14. Building and using topologies
  15. Organizing spatial data
  16. Query performance tuning
  17. PART 3 USING POSTGIS WITH OTHER TOOLS
  18. Extending PostGIS with pgRouting and procedural languages
  19. Using PostGIS in web applications
Boston GIS      Copyright 2018      Paragon Corporation