[postgis-users] ESRI 9.3 & PostGIS

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users