[postgis-users] ESRI 9.3 & PostGIS

[Havard Tveite]

I think FME Extension for ArcGIS has support for PostGIS.

Håvard

Obe, Regina wrote:
> 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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] 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 <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-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: 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