[postgis-users] ESRI 9.3 & PostGIS

Thu Oct 9 14:14:25 PDT 2008

Mark et al,

I found some interesting white papers and MP3 transcript on ESRI's site and
added it to the Wiki.  It seems to provide a good overview detailing
difference between using PostGIS vs. PostgreSQL ESRI ST_Geometry.

http://postgis.refractions.net/support/wiki/index.php?Postgisarcgis

I particularly like the slides since it covers writing spatial sql in
Oracle, PostgreSQL ESRI ST_Geometry, PostGIS Geometry (PG_Geometry), SQL
Server 2008.

http://gis.esri.com/library/userconf/devsummit08/papers/working_with_the_geo
database_effectively_using_sql.pdf (differences summed up on page 20.  I
assume this is still valid though I have some gripes.  e.g. PostGIS isn't
quite WKB storage).  Interesting they didn't try to make another geometry
for SQL Server 2008 to compete with SQL Server 2008 built-in (or at least it
seems they didn't).

I think I misspoke about the versioning.  I think you can use ESRI SDE
versioning with PostGIS geometry, but not a good idea if you will be using
your PostGIS with non-ESRI products (?).  I'm not sure which version an open
source product will see or if it will see all.  But yet all seems everything
runs under the umbrella of SDE regardless of if you choose PostGIS Geometry
(PG_Geometry) or ESRI PostgreSQL ST_Geometry

hmm I guess there equivalent of PostGIS ST_DWithin is ST_Buffer_Intersects
(is that an OGC function? or is that just for Oracle?)

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 Obe,
Regina
Sent: Thursday, October 09, 2008 12:29 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] ESRI 9.3 & PostGIS

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
> _______________________________________________
> 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
>
_______________________________________________
postgis-users mailing list
postgis-users at 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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users