PostGIS in Action, 2nd Edition

PostGIS in Action, 2nd Edition

Language: English

Pages: 600

ISBN: 1617291390

Format: PDF / Kindle (mobi) / ePub


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

  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
  11. Proximity analysis
  12. Geometry and geography processing
  13. Raster processing
  14. Building and using topologies
  15. Organizing spatial data
  16. Query performance tuning
  18. Extending PostGIS with pgRouting and procedural languages
  19. Using PostGIS in web applications

Bayesian Reasoning and Machine Learning

Network Information Theory

Introduction to Reversible Computing

Intelligent Networks: Recent Approaches and Applications in Medical Systems

Evolvable Hardware (Genetic and Evolutionary Computation)















We’ll cover these more complex objects including the currently available PostGIS raster functionality in the later chapters of this book. Introducing PostgreSQL and PostGIS 1.3 9 Introducing PostgreSQL and PostGIS In the rest of this chapter, we’ll talk more about PostgreSQL and PostGIS. PostGIS is a free and open source (FOSS) library that spatially enables the free and open source PostgreSQL object-relational database management system (ORDBMS). What is an object-relational database? An.

Constraints don’t pass to child tables, though check constraints do. In our D.C. example, if we place a primary key constraint on the parent feature table, dictating that each place name must be unique, we can’t expect the child tables to abide by the constraint. Even if we were to assign primary key constraints to the children, we still couldn’t guarantee unique results when querying multiple child tables or querying the parent table together with its child tables. To maintain hierarchy when.

Is the antithesis of Intersects. It means the two geometries have no interiors or boundaries shared. In the case of invalid geometries, it’s possible for the ST_Intersects and ST_Disjoint functions to both return false. If you see such a thing, you know your geometry is invalid. The disjoint relationship is supported by the function ST_Disjoint, and it too is an OGC/SQL-MM–defined function. Now that we’ve covered all the many facets of intersects and intersection, in the next section we’ll take a.

The content added to the author’s online website for the book, located at You may also visit the authors at the PostgreSQL and Open Source GIS companion sites: and About the title By combining introductions, overviews, and how-to examples, the In Action books are designed to help learning and remembering. According to research in cognitive science, the things people remember are things they discover during.

Generated from code in chapter 8. Table 6.4 List of different areas in different regions of the world City utm_sm geog_sm wm_sm diff_utm_wm diff_utm_g Honolulu 312 312 362 0.13 49.48 San Francisco 312 312 500 0.22 188.03 Boston 312 312 572 0.02 260.22 Paris 312 312 722 0.24 409.54 Oslo 312 312 1240 0.18 927.74 Saint Petersburg 312 312 1241 0.09 929.03 Helsinki 312 312 1260 0.15 947.76 Bergen 312 312 1272 0.11 959.40 Arkhangelsk 312 312.

Download sample