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.


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 2 by Jose Carlos Martinez spanish book covering new features of PostGIS 2.  Table of Contents
  •  PostGIS in Action 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



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.