Mark, Based on talking with people and reading their experiences, I think to use even the PostGIS geometry using ESRI's ArcGIS desktop support you need to have an ArcGIS server license similar to if you wanted to use Oracle Spatial SDE or SQL Server (minus express). But you can have the service turned off if you are just using the PostGIS geometry according to Dave Bouman's note, so then I'm not quite sure what you are paying for if you have to pay. I get the impression just the additional functions that ArcGIS installs into PostgreSQL to allow ArcGIS desktop to talk to PostGIS/PostgreSQL. I think they took away the direct connect thingy they use to have or rather you have to pay for it now under the umbrella of ArcSDE. I could be wrong though. All that licensing stuff is very confusing and I've been too busy with other things (like statistical analyse of data) to be bothered with figuring out how ArcGIS works or is licensed.
I could be wrong though, but that's the impression I have gotten. If you use something like ZigGIS, that works purely using ArcGIS apis and doesn't rely on SDE or the functions ESRI installs and will work for 9.1+ but then you are paying for per desktop instance install as opposed to a server install. Well maybe somebody who actually knows something will chime in :). Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MarkW Sent: Thursday, October 09, 2008 12:11 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] ESRI 9.3 & PostGIS 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-a rcgis-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-postgresq l-pa > rt-1/ > http://geobabble.wordpress.com/2008/06/02/using-arcsde-93-with-postgresq l-pa > rt-2/ > http://geobabble.wordpress.com/2008/07/01/using-arcsde-93-with-postgresq l-pa > rt-3/ > http://geobabble.wordpress.com/2008/08/21/using-arcsde-93-with-postgresq l-pa > rt-35/ > > 2) QUICK NOTES > http://geobabble.wordpress.com/2008/05/28/using-arcsde-93-with-postgresq l-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-a rcgi > s-users-how-to-choose/ > > Dave Bouman > > 4) http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.asp x > > 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 ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users