<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Regina,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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!).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>Obe,
Regina<br>
<b>Sent:</b> Friday, May 23, 2008 10:24 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div id=idOWAReplyText89071>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Rob,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Suddenly
my warm and fuzzy feeling is not so warm and fuzzy anymore.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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).</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>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. </span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Would
be interesting to see some metrics between ZigGIS, SDE whatever and Direct
Connect or are such metrics not allowed?</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thanks,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Regina</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>
postgis-users-bounces@postgis.refractions.net on behalf of Rob Tester<br>
<b>Sent:</b> Fri 5/23/2008 12:52 PM<br>
<b>To:</b> 'PostGIS Users Discussion'<br>
<b>Subject:</b> RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3</span><o:p></o:p></p>
</div>
<div>
<p><span style='font-size:10.0pt'>Yes, an SDE license is required and that is
now only available with ArcGIS<br>
server (cha-ching!).<br>
<br>
We plan to create our own display layer (similar to ZigGIS) and then create<br>
our own backend solution to maintain the database. This is easier for us<br>
since we use ArcGIS Engine for development and create our own tools outside<br>
of Arc desktop.<br>
<br>
The 'economical' route for those that want to use PostGIS and have edit<br>
capabilities inside ArcGIS desktop would be to use the ZigGIS professional<br>
which (from my understanding) implements an editable PostGIS layer in ArcGIS<br>
desktop.<br>
<br>
Rob.<br>
<br>
-----Original Message-----<br>
From: postgis-users-bounces@postgis.refractions.net<br>
[<a href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of<br>
Sufficool, Stanley<br>
Sent: Friday, May 23, 2008 9:40 AM<br>
To: PostGIS Users Discussion<br>
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3<br>
<br>
Does all of this wonderful functionality require an SDE connector<br>
license?<br>
<br>
Does "direct connect" function without the SDE license?<br>
<br>
-----Original Message-----<br>
From: postgis-users-bounces@postgis.refractions.net<br>
[<a href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of Rob<br>
Tester<br>
Sent: Friday, May 23, 2008 9:14 AM<br>
To: 'PostGIS Users Discussion'<br>
Subject: RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3<br>
<br>
<br>
Okay, I have the current 9.3 rc1 with the SDE and PostGIS. I also have<br>
talked with some of the developers at ESRI and can tell you the<br>
following.<br>
<br>
Yes the support for PostGIS does exist. The geometries can be in WKB or<br>
SDE (we keep ours in WKB). According to the developers of SDE for<br>
PostGIS there isn't a large difference in the type anyway. But you can't<br>
use both at the same time, so you have to pick your poison.<br>
<br>
I have also patched ZigGIS so that it works with just the ArcGIS Engine<br>
which is what we use to develop our applications.<br>
<br>
Rob.<br>
<br>
<br>
-----Original Message-----<br>
From: postgis-users-bounces@postgis.refractions.net<br>
[<a href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of<br>
Chris Hermansen<br>
Sent: Friday, May 23, 2008 8:17 AM<br>
To: PostGIS Users Discussion<br>
Subject: Re: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3<br>
<br>
What I find immediately puzzling about this whole SDE - PostGIS thing is<br>
<br>
a comment that Someone Knowledgeable (Paul? Martin?) made a few weeks<br>
ago about an incompatibility between SDE's geometry and OGC or at least<br>
PostGIS's implementation of OGC.<br>
<br>
Sorry I can't provide more details, but does anyone recall this, and<br>
have a comment on the matter?<br>
<br>
Tim Bowden wrote:<br>
> On Fri, 2008-05-23 at 09:29 -0500, Stephen Woodbridge wrote:<br>
> <br>
>> Tim Bowden wrote:<br>
>> <br>
>>> Hi all,<br>
>>><br>
>>> I've read bits and pieces about PostgreSQL/PostGIS and ArcGIS
Server<br>
<br>
>>> 9.3 and how they (might) inter-operate. Can anybody point me
to a<br>
>>> concise summation of what's happening there? I understand
ArcGIS<br>
>>> Server will be able to use PostGIS geometries, but at what cost<br>
>>> (performance and functionality)? Does this mean we can have ArcGIS<br>
>>> and open source clients editing the same geometries?<br>
>>><br>
>>> ArcGIS Server 9.3 beta is in the wild, and I've read that the
final<br>
>>> release is due "soon". Anyone have any idea if
soon is measured in<br>
>>> weeks or months?<br>
>>> <br>
>> Tim,<br>
>><br>
>> You might be interested in this link:<br>
>> <a
href="http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual">http://blog.davebouwman.net/2008/05/12/PostGISRound2ReadingTheManual</a>.<br>
>> aspx<br>
>><br>
>> -Stephen Woodbridge<br>
>> <a href="http://imaptools.com/">http://imaptools.com/</a><br>
>> <br>
><br>
> Hot stuff, thanks Stephen. Looks very promising. With a bit of
luck<br>
> it will ease the transition to PostgreSQL/PostGIS for those wanting to<br>
<br>
> go down that route. I can think of a few who will be looking at this<br>
> over the next few years.<br>
><br>
> Regards,<br>
> Tim Bowden<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list postgis-users@postgis.refractions.net<br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
> <br>
<br>
<br>
--<br>
Regards,<br>
<br>
Chris Hermansen <a
href="mailto:chris.hermansen@timberline.ca">mailto:chris.hermansen@timberline.ca</a><br>
tel+1.604.714.2878 . fax+1.604.733.0631 . mob+1.778.232.0644<br>
Timberline Natural Resource Group . <a href="http://www.timberline.ca/">http://www.timberline.ca</a>
401 . 958<br>
West 8th Avenue . Vancouver BC . Canada . V5Z 1E5<br>
<br>
_______________________________________________<br>
postgis-users mailing list postgis-users@postgis.refractions.net<br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
_______________________________________________<br>
postgis-users mailing list postgis-users@postgis.refractions.net<br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@postgis.refractions.net<br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></span><o:p></o:p></p>
</div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p><strong>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. </strong><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p><strong><span style='font-size:10.0pt;color:#339900'>Help make the earth a
greener place. If at all possible resist printing this email and join us in
saving paper. <o:p></o:p></span></strong></p>
</div>
</body>
</html>