Since this seems to be a very popular topic, I have posted the links I know about to the wiki
http://postgis.refractions.net/support/wiki/index.php?Postgisarcgis Anyone who comes up with more war/love stories, please feel free to put your links on the above page. Its linked from the front http://postgis.refractions.net/support/wiki/ (under PostGIS and ArcSDE/ArcGIS 9.3 Articles) Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paragon Corporation Sent: Wednesday, October 08, 2008 6:45 PM To: 'PostGIS Users Discussion' Subject: RE: [postgis-users] ESRI 9.3 & PostGIS Brent, Sorry I haven't tried this yet either. I still find the whole ArcGIS 9.3 environment a bit daunting to deal with, but if you haven't looked at other people's documentation of their experiences, you should take a gander. >From readings of blogs I gather you have the choice of making your self inextricably married to ESRI via their PostSDE ST_Geometry implementation or just chummy chummy using the PostGIS geometry. Benefits of PostSDE presumably you can take advantage of more of the versioning functionality in ArcSDE if that is important to you but lose ability to use these in a non-ESRI SDE FOSS aware tool. Anyrate I'm sure I posted these links before but can't find the post now, so let me see if I remember from memory and then maybe I'll or someone else will post these to the wiki for easier retrieval. 1) 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-pa rt-1/ http://geobabble.wordpress.com/2008/06/02/using-arcsde-93-with-postgresql-pa rt-2/ http://geobabble.wordpress.com/2008/07/01/using-arcsde-93-with-postgresql-pa rt-3/ http://geobabble.wordpress.com/2008/08/21/using-arcsde-93-with-postgresql-pa rt-35/ 2) QUICK NOTES http://geobabble.wordpress.com/2008/05/28/using-arcsde-93-with-postgresql-pa rt-1/ http://geobabble.wordpress.com/2008/03/18/postgresql-support-in-arcgis/ 3) Paolo Corti has some good stuff too http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgi s-users-how-to-choose/ Dave Bouman 4) http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.aspx Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent Wood Sent: Wednesday, October 08, 2008 4:29 PM To: PostGIS Users Discussion Subject: [postgis-users] ESRI 9.3 & PostGIS The institute I work for is a long term ESRI user, while I've been encouraging the use of FOSS GIS solutions for some years, with growing success. We are looking at replacing our Arc/Oracle setup with Arc/PostGIS when we upgrade to 9.3 and I'm interested in any experiences anyone may have with this. We are hoping that an Arc PostGIS geodtabase can be managed via Arc, but have the contents available as normal (read-only) PostGIS tables, etc via PostGIS client apps such as Geoserver, Mapserver, uDIG, QGIS, gvSIG, R-GDAL, etc. Has anyone here had any experience with PostGIS as a 9.3 Geodatabase and how open the data is in these, or whether the geodatabase is inherently tied up with non-standard structures that don't work well with typical PostGIS clients? Thanks, Brent Wood _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
