<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="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 11 (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]-->
<style>
<!--
/* Font Definitions */
@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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Marco<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The other question is can the Data
Interoperability Extension write to a PostGIS database? I also tried the
extension and it did not work with PostGIS. This may have been fixed since
I tried it. I real issue I had was the cost. When I last checked it
was $1500. This was for the entire package to connect to 60+ data sources.
NEWS FLASH - I don’t need to connect to 60+ data sources. So if my
math is right, our 4 ArcGIS licenses + a floating license to connect to our
free database would run about $8000 (assuming $2000 for a floating). Not
to mention the ~$600 a year for maintenance. If they changed it to say
$1500 for a company license and $50 for each machine/database combo, we would
really think about it. However ESRI has a deal with FME software and they
are not about to kill that cash cow. Right now we do almost all of our
GIS work with ArcGIS. Large, official datasets are loaded into PostGIS
and accessed with the pgarc extension. The main one we use is a database
of all the wells in the state (400,000 +). Using the extension, any user
in the office pushes one button and all the wells in the ArcGIS display are
loaded (and projected) to a local shapefile copy. This is done in seconds
instead of several minutes to load the entire shapefile. Thus we don’t
really need the DIE from ESRI especially since our biggest use of PostGIS is
for internet web mapping with SVG. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Bruce<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=3 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>marco vieira<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, September 14, 2006
6:32 AM<br>
<b><span style='font-weight:bold'>To:</span></b> PostGIS Users Discussion<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [postgis-users]
Exporting to ESRI's ArcGIS</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>ArcMap/Catalog also can
read data from PostGIS in the same way as regular ArcGIS datasources using Data
Interoperability Extension (from Safe Software). You can found presentations on
<a
href="http://www.esri.com/software/arcgis/extensions/datainteroperability/about/demos.html">http://www.esri.com/software/arcgis/extensions/datainteroperability/about/demos.html</a><br>
and evaluate the extension downloading from <a
href="http://www.esri.com/software/arcgis/extensions/datainteroperability/evaluate.html">http://www.esri.com/software/arcgis/extensions/datainteroperability/evaluate.html</a><br>
<br>
One problem is the gap from postgis versions (very fast atualization from Open
Source Community) and DI supported versions (very slow from comercial company).
When I tried this extention I suffer a bit with postgis 0.9x to 1.x formats.
See <a
href="http://www.nabble.com/ESRI-Data-Interoperability---ArcGIS-%2B-PostGIS-tf185458.html#a516819">http://www.nabble.com/ESRI-Data-Interoperability---ArcGIS-%2B-PostGIS-tf185458.html#a516819</a>
posts.<br>
<br>
Another problem is the read only capabilities when directed access (can be
write with import/export tool).<br>
When I tested, the support for schemas was not good and I felt some frustration
about performance also. <br>
<br>
Regards.<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>2006/9/13, P Kishor <<a
href="mailto:punkish@eidesis.org">punkish@eidesis.org</a>>:</span></font></span><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On 9/13/06, alex bodnaru <<a href="mailto:alexbodn@012.net.il">alexbodn@012.net.il</a>>
wrote:<br>
..<br>
><br>
> i might be wrong, but if i remember correctly, mapserver may masquerade<br>
> as imsserver.<br>
<br>
Perhaps, but that is another complication, another layer to run.<br>
Although Bruce's comments make it seem that it might be difficult,<br>
even impossible, to make ArcGIS recognize PostGIS as a datasource, it<br>
would be superbly fantastic if it were possible. As I said earlier, <br>
existing ArcGIS shops would generally have no problem with where the<br>
data are coming from, and that would allow PostGIS to infitrate and<br>
exist in such environments. After a decade or so of being away from<br>
ArcGIS, I have been using it once again for the past few months. The <br>
backend stinks, but the frontend is actually pretty darn nice. That is<br>
something the open source world would have to spend a lot of effort to<br>
recreate, and it may simply not be worth doing so (well, it may be<br>
worth doing so, however, you know what I mean...).<br>
<br>
Hopefully, in time...<br>
<br>
<br>
<br>
><br>
> P Kishor wrote:<br>
> > On 9/13/06, Bruce Rindahl <<a href="mailto:rindahl@lrcwe.com">rindahl@lrcwe.com</a>
> wrote:<br>
> ><br>
> >> There is an extension called pgarc that that has most of the<br>
> >> functionality<br>
> >> you might be looking for. See:<br>
> >> <a href="http://pgarc.sourceforge.net/">http://pgarc.sourceforge.net/</a><br>
> >> I have taken the code and made some changes. I ported
it to the new code<br>
> >> for 9.x. It will load the extent of the display view
and defines the<br>
> >> projection for the resultant shapefile that is loaded on the
local <br>
> >> machine.<br>
> >> It can write to a PostGIS database but the functionality is
limited - I<br>
> >> haven't really needed it.<br>
> >> I have had limited success in contacting the authors of pgarc to
see <br>
> >> if they<br>
> >> are interested in updating the project.<br>
> >><br>
> >><br>
> ><br>
> > Well, if you have managed to make it work with ArcGIS 9.x, that is<br>
> > indeed very sweet. Poking around in the pgarc website, I see that one
<br>
> > of the project managers is 'spatialguru' or Tyler Mitchell. I am<br>
> > pretty sure he is on this list, if not, he is certainly on the<br>
> > MapServer list. He will readily respond to any queries/offers to
help. <br>
> ><br>
> > Unfortunately I know nothing about coding ArcGIS, so I am only a very<br>
> > keen and eager user of such a utility.<br>
> ><br>
> > That said, it seems to extend ArcGIS -- I would much rather prefer to
<br>
> > extend PostGIS so it emulates (something like imsemu) an ArcGIS<br>
> > compatible dsn. That way, an existing ArcGIS installation need not be<br>
> > disturbed, but can happily use PostGIS data, and PostGIS gets a
really <br>
> > nice, albeit neither free nor open source, viewer for its data. Great<br>
> > for existing ArcGIS shops that might want to incorporate PostGIS for<br>
> > backend data management instead of putting up with SDE (I know of one
<br>
> > such shop personally).<br>
> ><br>
> >><br>
> >><br>
> >><br>
> >> -----Original Message-----<br>
> >> From: <a
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
> >> [mailto:<a
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>]
On Behalf Of P<br>
> >> Kishor <br>
> >> Sent: Wednesday, September 13, 2006 3:25 PM<br>
> >> To: PostGIS Users Discussion<br>
> >> Subject: Re: [postgis-users] Exporting to ESRI's ArcGIS<br>
> >><br>
> >> Sorry, no help here (am curious about this meself), but I have a <br>
> >> related question -- anyone figured out how to view PostGIS data
in<br>
> >> ArcGIS?<br>
> >><br>
> >> On 9/13/06, Michael de Armas (Micotan) <<a
href="mailto:michael.dearmas@micotan.com"> michael.dearmas@micotan.com</a>><br>
> >> wrote:<br>
> >> ><br>
> >> ><br>
> >> > Thanks, for the suggestion.<br>
> >> ><br>
> >> > Is that the only way? Let's say that, for some reasons, I
cannot <br>
> >> install<br>
> >> > PostGIS in the PC where the app will run and/or I don't want
to call an<br>
> >> > external program to do the job.<br>
> >> ><br>
> >> > I was thinking something like saving the geometry to a GML
file, but I <br>
> >> don't<br>
> >> > know if ESRI could read the GML that PostGIS generates.<br>
> >> > _______________________________________________<br>
> >> > postgis-users mailing list<br>
> >> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><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>
> >><br>
> >> --<br>
> >> Puneet Kishor <a href="http://punkish.eidesis.org/">http://punkish.eidesis.org/
</a><br>
> >> Nelson Inst. for Env. Studies, UW-Madison <a
href="http://www.ies.wisc.edu/">http://www.ies.wisc.edu/</a><br>
> >> Open Source Geospatial Foundation <a href="https://edu.osgeo.org/">https://edu.osgeo.org/
</a><br>
> >> _______________________________________________<br>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><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>
> >> postgis-users mailing list<br>
> >> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> >> <a
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
> >><br>
> ><br>
> ><br>
> -----BEGIN PGP SIGNATURE-----<br>
> Version: GnuPG v1.4.5 (GNU/Linux)<br>
> Comment: Using GnuPG with Debian - <a href="http://enigmail.mozdev.org">http://enigmail.mozdev.org</a><br>
><br>
> iQCVAwUBRQievtpwN1sq38njAQJjRQP/cfTfO65zgmeMSs4hVUYB0vCWpyLcrYj6<br>
> Gk/RowI0X/hbFahlAiV4Kx3WeQJU930j0caFWSuzTwo02KJOCJ24EPfMnpBmIsDo <br>
> RNlVqrd0Fs0V+ZG07LQnSPg1zuHZhL5zxi5WZmypFftWeS2MX2Ka5CkIWE9v3YjN<br>
> WW80b2tg3Rk=<br>
> =ZxK5<br>
> -----END PGP SIGNATURE-----<br>
> _______________________________________________<br>
> postgis-users mailing list <br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><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>
Puneet Kishor <a href="http://punkish.eidesis.org/">http://punkish.eidesis.org/</a><br>
Nelson Inst. for Env. Studies, UW-Madison <a href="http://www.ies.wisc.edu/">http://www.ies.wisc.edu/</a>
<br>
Open Source Geospatial Foundation <a href="https://edu.osgeo.org/">https://edu.osgeo.org/</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Marco Vieira<br>
+55 21 9499-6800<br>
e-mail: <a href="mailto:maovieira@gmail.com">maovieira@gmail.com</a> <o:p></o:p></span></font></p>
</div>
</body>
</html>