<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD><TITLE>RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS Server 9.3</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR><!--[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]-->
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle19 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
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 vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>Rob,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>That's unfortunate that they took away the direct connect
feature. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><EM>I also wanted to try
a direct connection - I stopped the ArcSDE service. Worked just fine - note the
"service" name.</EM></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=203521320-23052008><EM></EM></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008>Although now thinking
about it maybe he meant - can use uDig (not necessarily
ArcMap). What exactly <EM>Worked just fine</EM>
means seems kind of vague.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=203521320-23052008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Rob
Tester<BR><B>Sent:</B> Friday, May 23, 2008 1:48 PM<BR><B>To:</B> 'PostGIS Users
Discussion'<BR><B>Subject:</B> RE: [postgis-users] PostgreSQL/PostGIS and ArcGIS
Server 9.3<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Regina,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 10pt; COLOR: black; FONT-FAMILY: 'Arial','sans-serif'">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: 10pt; 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: 10pt; 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: 10pt; 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: 10pt; 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: 10pt; 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: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Thanks,</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; 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 style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 10pt">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 style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=1>
</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 style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=1>
</DIV>
<P><STRONG><SPAN style="FONT-SIZE: 10pt; 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>