OSGeo Project Logo

Welcome to the Users PostGIS Wiki!

Everybody is welcome to contribute to this wiki.

  • You must login to create new pages and modify existing ones. You can create your own  OSGEO Userid or use your existing one or you can use the generic one (login:wiki;password:wiki).
  • Please prefix every new page names in this section with "UsersWiki" in order to easily distinguish them from other Wiki Trac pages.
  • For a quick overview of how to format page's content see this page.

What is PostGIS?

PostGIS is an extension to the  PostgreSQL object-relational database system that allows  GIS (Geographic Information System) objects to be stored in the database. PostGIS does for PostgreSQL what Oracle Spatial does for Oracle, ArcSDE does for Microsoft SQL Server/Oracle.

Overview

Contrast / Compare / Port Guides

Don't know if PostGIS is right for you or if another spatial db is more suited or you are porting from another/going to another and not sure the gotchas

Compilation and Installation Guides

PostGIS Books

  •  PostGIS official manuals for all versions and for PostGIS JDBC driver.
  •  PostGIS in Action (2nd Edition) by Regina Obe and Leo Hsu - Covers PostGIS 2.1. Feature complete and available from Manning in draft form. With early purchase you get draft updates and final (e-Book/Hardcover?) when complete. E-book is generally 1/2 price of full. All code and data downloads available for free on the book site even if you don't buy the book.  Chapter 1 (a primer on PostGIS ) are free downloads.
  •  PostGIS cookbook Covers PostGIS 2.0 and 2.1. Common real-world recipes for getting things done in PostGIS.
  •  PostGIS 2 by Jose Carlos Martinez spanish book covering new features of PostGIS 2.  Table of Contents
  •  PostGIS in Action (1st Edition) by Regina Obe and Leo Hsu - It's out and available via various distributors including Manning Publications and Amazon. If you want just the E-Book, purchase directly from Manning. The E-book is about 50% off the hard-copy price. With the purchase of Hard-copy, there is a free-coupon to get the E-Book version. Book includes PostGIS 1.3-1.5, PostgreSQL 8.3-9.0 (with upcoming highlights of PostgreSQL 9.1 and PostGIS 2.0). All code and data downloads available for free on the book site even if you don't buy the book.  Chapter 1 (a primer on PostGIS ) and  Appendix C (a primer on SQL) are free downloads.

Examples of Spatial SQL

Extending PostGIS

Newbie Common Problems and Questions

Extras

Notes

Useful Additional PL/PGSQL Functions

What is GEOS

 GEOS is a C++ port of the  JTS Topology Suite. It is used by PostGIS to implement Topological functions.