PostGIS and ArcSDE/ArcGIS Articles

Issues Gotchas

The biggest problem with using PostGIS in ArcSDE is that you are forced to use older versions of PostGIS and PostgreSQL.

• If you are running ArcGIS 10.0 then only PostGIS 1.4 and PostgreSQL 8.3/8.4 are supported. Details: ​ArcSDE 10 PostgreSQL/PostGIS system requirements

• If you are running ArcGIS 9.3 then only PostGIS 1.3 and PostgreSQL 8.3 are supported.

Details: ​ArcSDE 9.3 PostgreSQL/PostGIS Database Requirements

Case Studies

These are Case Studies of using ArcSDE with PostGIS or moving away from ArcSDE:

• ​Moving from ESRI Oracle ArcGIS to PostgreSQL/PostGIS Foss4G 2010 Barcelona Case Study of Natural Resources Canada move from an ESRI ArcGIS Oracle platform to PostGIS/PostgreSQL

Tutorials

These are blogs and tutorials detailing use of PostGIS/PostgreSQL with ESRI ArcGIS 9.3+ and experiences

Bill Dollins has a great series on using ArcSDE 9.3 with PostGIS/PostgreSQL

• ​http://geobabble.wordpress.com/2008/05/28/using-arcsde-93-with-postgresql-part-1/

• ​http://geobabble.wordpress.com/2008/06/02/using-arcsde-93-with-postgresql-part-2/

• ​http://geobabble.wordpress.com/2008/07/01/using-arcsde-93-with-postgresql-part-3/

• ​http://geobabble.wordpress.com/2008/08/21/using-arcsde-93-with-postgresql-part-35/

• ​http://geobabble.wordpress.com/2008/03/18/postgresql-support-in-arcgis/

Paolo Corti

• ​http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/

Dave Bouman

• ​http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx

ESRI Articles and White Papers

• ​Introducing ArcSDE Implementation for PostgreSQL Transcript

• ​Introducing ArcSDE Implementation for PostgreSQL MP3 Video

• ​Working with Geodatabases - this is not specific to PostgreSQL/PostGIS, but covers sampling of Oracle, SQL Server 2008, IBM DB2, PostgreSQL SDE ST_Geometry, PostGIS

• ​Installing HowTo: Install PostgreSQL 8.3.0, ArcSDE 9.3, and PostGIS 1.3.2 on Windows