PostGIS is a spatial database extender for the PostgreSQL Open Source Object-Relational database management system.
PostGIS follows the OGC/SQL-MM standards.
A lot in PostGIS has changed since we wrote the First Edition. PostGIS in Action,2nd Edition is a significant update to the first edition that covers new features in 2.0 and 2.1 as well as newer PostgreSQL 9.1-9.3 enhancements. The way you install in PostGIS 2+ is different and easier than PostGIS 1 series. The way you create spatial columns is also different
and in general easier. If that was not enough the PostGIS 2 series adds lots new features: raster functionality, 3D functionality, topology functionality, packaged Tiger geocoder, and many speed and function enhancements. In addition PostgreSQL has changed as well and has added many new speed improvements. We'll cover some of these in performance tuning, PL languages and the Appendixes. PostGIS in Action,2nd Edition will provide a guided tour of these new enhancements and things to watch out for when migrating from PostGIS 1.x to 2.x. 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. Special focus on PostGIS 2-2.1 series and PostgreSQL 9.1-9.4. For a quick primer on what's hot in PostgreSQL 9.3-9.4 or just getting up to speed with PostgreSQL, check out our PostgreSQL: Up and Running, 2nd Edition book.
We'll introduce you to both PostGIS as well
as PostgreSQL, the powerful DBMS that PostGIS spatially extends. You will learn:
- The basics of Geographic Infomation Systems (GIS), spatial data processing,and how these extend the kinds of questions you can answer with a relational database
- How to load both vector and raster data into the database and working with topology.
- How spatial reference systems play a role in GIS
- The power of Spatial SQL to simplify and expand the possibilities of location aware applications, statistical analysis based on location, and raster analysis.
- How PostGIS/PostgreSQL fits into the standard body of GIS and relational databases. Also check out our related comparison article comparing the big common 3 spatially enabled OGC compliant relational databases Oracle, SQL Server, PostGIS
- What workflows PostGIS is good for and how to perform them efficiently
- How to view PostGIS data in desktop applications
- How to integrate PostGIS in your web applications
The appendices cover topics germane to PostGIS and PostgreSQL:
- Helpful resources for learning more about PostgreSQL, GIS, Free tools and Commerical tools that work with PostGIS
- Getting free GIS data
- Getting up and running with PostgreSQL and PostGIS
- The fundamentals of Structured Query Lanuage (SQL)
- PostgreSQL unique features, backup and restore, and security management
This website is a companion to the PostGIS in Action books. 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. You will also see the download link on each chapter page.
Note the E-Book version is half the price of the hard-copy and Manning will reimburse you the price you paid for E-Book if you choose to later buy the hard-copy.
UPDATE: PostGIS in Action, 2nd Edition has reached MEAP and available from purchase now from Manning and pre-order from Amazon. Buy PostGIS in Action in hard-copy from various distributors or the e-Book from Manning.
We are working on second edition of PostGIS in Action 2ed for availability sometime in Early 2015. Early purchase review (MEAP) is now available for Second Edition: All 17 chapters now available on MEAP with code and data download on PostGIS In Action Edition 2 Chapters. With MEAP you can get chapter updates as we write/update them and get the final polished copy at release time in both E-Book and Hard-copy form. Each purchase includes all E-Book versions including E-book version of 1st edition.
PostgreSQL: Up and Running, 2nd addition just came out in late December 2014 in Print (both Hardcopy and E-Book). It is also available on Amazon
. The focus of 2nd edition is PostgreSQL 9.3-9.4 and the content has increased by about 60 pages from first edition.
PostgreSQL: Up and Running, 1st Edition is our older edition that focuses on PostgreSQL 9.1 and 9.2 You can order hard-copy or Kindle from Amazon or Kindle
or hard-copy or e-Book from O'Reilly.