PostGIS in Action, 2nd Edition

PostGIS in Action, 2nd Edition


Summary

PostGIS in motion, moment Edition teaches readers of all degrees to jot down spatial queries that clear up real-world difficulties. It first offers a historical past in vector-, raster-, and topology-based GIS after which speedy strikes into reading, viewing, and mapping facts. This moment version covers PostGIS 2.0 and 2.1 sequence, PostgreSQL 9.1, 9.2, and 9.3 beneficial properties, and exhibits you the way to combine with different GIS tools.

Purchase of the print ebook features a unfastened e-book in PDF, Kindle, and ePub codecs from Manning Publications.

About the Book

Processing info tied to situation and topology calls for really good knowledge. PostGIS is a loose spatial database extender for PostgreSQL, each piece pretty much as good as proprietary software program. With it, you could simply create location-aware queries in precisely a couple of strains of SQL code and construct the again finish for a mapping, raster research, or routing software with minimum effort.

PostGIS in motion, moment Edition teaches you to resolve real-world geodata difficulties. It first offers a heritage in vector-, raster-, and topology-based GIS after which speedy strikes into examining, viewing, and mapping information. you are going to how to optimize queries for max pace, simplify geometries for larger potency, and create customized features on your personal purposes. you are going to additionally the best way to observe your current GIS wisdom to PostGIS and combine with different GIS tools.

Familiarity with relational database and GIS techniques is beneficial yet now not required.

What's Inside

  • An advent to spatial databases
  • Geometry, geography, raster, and topology spatial varieties, capabilities, and queries
  • Applying PostGIS to real-world problems
  • Extending PostGIS to internet and laptop applications
  • Updated for PostGIS 2.x and PostgreSQL 9.x

About the Authors

Regina Obe and Leo Hsu are database experts and authors. Regina is a member of the PostGIS middle improvement workforce and the venture steerage Committee.

Table of Contents

    PART 1 advent TO POSTGIS
  1. What is a spatial database?
  2. Spatial info types
  3. Spatial reference method considerations
  4. Working with genuine data
  5. Using PostGIS at the desktop
  6. Geometry and geography functions
  7. Raster functions
  8. PostGIS TIGER geocoder
  9. Geometry relationships
  10. PART 2 placing POSTGIS TO WORK
  11. Proximity analysis
  12. Geometry and geography processing
  13. Raster processing
  14. Building and utilizing topologies
  15. Organizing spatial data
  16. Query functionality tuning
  17. PART three utilizing POSTGIS WITH different TOOLS
  18. Extending PostGIS with pgRouting and procedural languages
  19. Using PostGIS in internet applications

Show sample text content

Download sample