[postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Fri May 23 13:25:18 PDT 2008

Rob,

Hadn't really given much thought to what metrics would be useful.  For
the most part most of the editing I do on spatial data are massive edits
to push things one way or another (not individual edits).  Can't really
see where something like ArcGIS would play in that that I couldn't do
with SFSQL statements.  Although I would be more worried about ArcSDE
getting in my way more than anything else.

I guess I was thinking of looking at an overview of a 500,000 polygons
layer or something of that sort.  Or doing spatial and attribute filter
queries.

That's unfortunate that they took away the direct connect feature.  

From Dave Bouman's test - I was under the impression he could connect to
PostGIS when turning the SDE service off.  What exactly does that mean?

I also wanted to try a direct connection - I stopped the ArcSDE service.
Worked just fine - note the "service" name.

Although now thinking about it maybe he meant - can use uDig  (not
necessarily ArcMap).  What exactly  Worked just fine means seems kind of
vague.

Thanks,
Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Rob
Tester
Sent: Friday, May 23, 2008 1:48 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Regina,

From my talks with ESRI both developers and sales if you want PostgreSQL
as a storage medium then you need SDE. If you want SDE, you need ArcGIS
server. I have gone many rounds with all of them trying not to pull what
is left of my hair out.  Because, we needed a single desktop solution
that allows us to connect a single user to a single instance of postgres
without all the versioning that SDE adds, we really needed the direct
connect,  but according to everyone that I have talked to (as of today)
we have to get SDE.

It has become such a sticking point that our sales rep is trying to get
us "special" pricing for SDE as a standalone product without all the
server components we don't need (or an agreement not to use it in a
multi-user environment). But as I also said it is easier for us (and
probably more economical) to go the route of writing a drawing layer
(like zigGIS) and then handling the updates ourselves writing directly
to the database using the transactions that PostgreSQL gives us. 

As far as what license you would need (i.e. can you use your SQLServer
license) you would have to ask ESRI, but I am sure I know their answer
already (cha-ching!).

I could run the metrics if one of the Zig developers would like to loan
me a professional license to do it.  Also, would have to know what
metrics you would be interested in.

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
Regina
Sent: Friday, May 23, 2008 10:24 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Rob,

Suddenly my warm and fuzzy feeling is not so warm and fuzzy anymore.

Does the Direct connect require ArcGIS server as well (thought it came
with ArcGIS Client API).  I always thought from reports that Direct
connect was a sucky implementation, but at least you could get away
without paying the ArcGIS SDE license and you didn't have to have
another ugly service running on your system.

Also if you are running ArcGIS SDE for SQL Server, do you need yet
another license for ArcGIS SDE for PostGIS.  I presume you need an
ArcGIS license for any server you have that is running SDE, but if you
have a server running both SQL Server SDE and PostGIS, do you need 2
licenses? (one for each SDE implementation).

You can tell I'm a big fan of ArcGIS can't you :).  I guess if I have to
live with ArcGIS fanboys I'll try to make the best of it.  

Would be interesting to see some metrics between ZigGIS, SDE whatever
and Direct Connect or are such metrics not allowed?

Thanks,

Regina

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Rob
Tester
Sent: Fri 5/23/2008 12:52 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Yes, an SDE license is required and that is now only available with
ArcGIS
server (cha-ching!).

We plan to create our own display layer (similar to ZigGIS) and then
create
our own backend solution to maintain the database. This is easier for us
since we use ArcGIS Engine for development and create our own tools
outside
of Arc desktop.

The 'economical' route for those that want to use PostGIS and have edit
capabilities inside ArcGIS desktop would be to use the ZigGIS
professional
which (from my understanding) implements an editable PostGIS layer in
ArcGIS
desktop.

Rob.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sufficool, Stanley
Sent: Friday, May 23, 2008 9:40 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Does all of this wonderful functionality require an SDE connector
license?

Does "direct connect" function without the SDE license?

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Rob
Tester
Sent: Friday, May 23, 2008 9:14 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

Okay, I have the current 9.3 rc1 with the SDE and PostGIS. I also have
talked with some of the developers at ESRI and can tell you the
following.

Yes the support for PostGIS does exist. The geometries can be in WKB or
SDE (we keep ours in WKB). According to the developers of SDE for
PostGIS there isn't a large difference in the type anyway. But you can't
use both at the same time, so you have to pick your poison.

I have also patched ZigGIS so that it works with just the ArcGIS Engine
which is what we use to develop our applications.

Rob.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Chris Hermansen
Sent: Friday, May 23, 2008 8:17 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3

What I find immediately puzzling about this whole SDE - PostGIS thing is

a comment that Someone Knowledgeable (Paul?  Martin?) made a few weeks
ago about an incompatibility between SDE's geometry and OGC or at least
PostGIS's implementation of OGC.

Sorry I can't provide more details, but does anyone recall this, and
have a comment on the matter?

Tim Bowden wrote:
> On Fri, 2008-05-23 at 09:29 -0500, Stephen Woodbridge wrote:
>  
>> Tim Bowden wrote:
>>    
>>> Hi all,
>>>
>>> I've read bits and pieces about PostgreSQL/PostGIS and ArcGIS Server

>>> 9.3 and how they (might) inter-operate.  Can anybody point me to a
>>> concise summation of what's happening there?  I understand ArcGIS
>>> Server will be able to use PostGIS geometries, but at what cost
>>> (performance and functionality)? Does this mean we can have ArcGIS
>>> and open source clients editing the same geometries?
>>>
>>> ArcGIS Server 9.3 beta is in the wild, and I've read that the final
>>> release is due "soon".  Anyone have any idea if soon is measured in
>>> weeks or months?
>>>      
>> Tim,
>>
>> You might be interested in this link:
>> http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual.
>> aspx
>>
>> -Stephen Woodbridge
>>   http://imaptools.com/
>>    
>
> Hot stuff, thanks Stephen.  Looks very promising.  With a bit of luck
> it will ease the transition to PostgreSQL/PostGIS for those wanting to

> go down that route.  I can think of a few who will be looking at this
> over the next few years.
>
> Regards,
> Tim Bowden
>
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>  

--
Regards,

Chris Hermansen         mailto:chris.hermansen at timberline.ca
tel+1.604.714.2878 . fax+1.604.733.0631 . mob+1.778.232.0644
Timberline Natural Resource Group . http://www.timberline.ca
<http://www.timberline.ca/>  401 . 958
West 8th Avenue  . Vancouver BC . Canada . V5Z 1E5

_______________________________________________
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. 

________________________________

Help make the earth a greener place. If at all possible resist printing
this email and join us in saving paper. 

-----------------------------------------
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080523/fabe3673/attachment.html>