PostGIS In Action PostGIS Case Studies

We are working on second edition of PostGIS in Action 2ed for availability sometime in late 2013/early 2014. Early purchase review (MEAP) is now available for Second Edition. With MEAP you can get chapter updates as we write them and get the final polished copy at release time.

Our most recent book PostgreSQL: Up and Running is out in both E-book and hard-copy. You can order hard-copy now from Amazon or Kindle or hard-copy or e-Book from O'Reilly .

PostGIS in Action: PostGIS Case Studies

PostGIS is used by organizations large and small and has garnered a lot of commercial support. Its ease of use, unmatched performance, feature set, scalability, ease of deployment, and ability to integrate in most any environment makes it a no-brainer solution for most GIS work involving high end analytics and integration with other business processes.

These are sites using PostGIS that are publically accessible

CartoDb is a PostGIS cloud service offering a REST-like API for doing spatial queries. The code for the platform is open source. You can check out some descriptions of publically available examples in CartoDb Blog
National Oceanagraphic and Atmospheric Administration (NOAA) Hosting Environment utilizing PostGIS and GeoServer.
Sharding Postgres with Instagram Instagram chose to build on PostgreSQL because of PostGIS - check out page 39 of the slides. Instagram is selling to Facebook for 1 billion dollars.
Ride the City - New York City
This uses pgRouting (which means PostGIS as well), OpenStreetMap
FCC National Broadband map. This is an OpenGeo case study write-up.
Portland Trimet Transit system This another OpenGeo write-up.
FourSquare mapping and reverse geocoding

Below we have a list of links to case studies on how it's currently used.

Buy PostGIS in Action direct from Manning and qualify for volume discounts

Direct from O'Reilly

PostgreSQL: Up and Runnning Kindle Edition

PostGIS in Action
Where the adventure begins
Translate:

Book Spots

PostGIS Related Sites