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 <[EMAIL PROTECTED]> 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: [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 > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users