[postgis-users] ESRI 9.3 & PostGIS

[MarkW]

Thanks for setting up that page on the wiki - that's a help.

I have some very basic questions, from the perspective of a non-ArcSDE
user. I understand the zigGis and QGIS, etc options, but having just
installed Arc9.3, I hoped to view/edit PostGIS data via ArcMap. I
think what I want is closest to Paolo's scenario #3:
http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/

I have read various posts indicating that if I want to access PostGIS
data at all in ArcMap, I should be running (ArcGIS server and ?)
ArcSDE. I cannot easily separate the help on using Postgres SDE vs
PostGIS; it sounds, first of all, that either requires Postgres ArcSDE
be installed, and that my spatial data be in a database called "sde".
Correct? I've only been reading through the help for an hour or two,
so I may have missed something.

All the help at ESRI on PostGIS data is under the ArcGisServer help -
do I also have to run ArcGIS server, or is it just listed there
because that's the main target audience/intended use?

Thanks in advance,
Mark


On Wed, Oct 8, 2008 at 7:02 PM, Paragon Corporation <lr at pcorp.us> wrote:
> 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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] 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: 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
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>