[postgis-users] Exporting to ESRI's ArcGIS

Thu Sep 14 07:49:48 PDT 2006

Marco

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.  

Bruce

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of marco
vieira
Sent: Thursday, September 14, 2006 6:32 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Exporting to ESRI's ArcGIS

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
http://www.esri.com/software/arcgis/extensions/datainteroperability/about/de
mos.html
and evaluate the extension downloading from
http://www.esri.com/software/arcgis/extensions/datainteroperability/evaluate
.html

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
http://www.nabble.com/ESRI-Data-Interoperability---ArcGIS-%2B-PostGIS-tf1854
58.html#a516819 posts.

Another problem is the read only capabilities when directed access (can be
write with import/export tool).
When I tested, the support for schemas was not good and I felt some
frustration about performance also. 

Regards.

2006/9/13, P Kishor <punkish at eidesis.org>:

On 9/13/06, alex bodnaru <alexbodn at 012.net.il> wrote:
..
>
> i might be wrong, but if i remember correctly, mapserver may masquerade
> as imsserver.

Perhaps, but that is another complication, another layer to run.
Although Bruce's comments make it seem that it might be difficult,
even impossible, to make ArcGIS recognize PostGIS as a datasource, it
would be superbly fantastic if it were possible. As I said earlier, 
existing ArcGIS shops would generally have no problem with where the
data are coming from, and that would allow PostGIS to infitrate and
exist in such environments. After a decade or so of being away from
ArcGIS, I have been using it once again for the past few months. The 
backend stinks, but the frontend is actually pretty darn nice. That is
something the open source world would have to spend a lot of effort to
recreate, and it may simply not be worth doing so (well, it may be
worth doing so, however, you know what I mean...).

Hopefully, in time...

>
> P Kishor wrote:
> > On 9/13/06, Bruce Rindahl <rindahl at lrcwe.com > wrote:
> >
> >> There is an extension called pgarc that that has most of the
> >> functionality
> >> you might be looking for.  See:
> >> http://pgarc.sourceforge.net/
> >> I have taken the code and made some changes.  I ported it to the new
code
> >> for 9.x.  It will load the extent of the display view and defines the
> >> projection for the resultant shapefile that is loaded on the local 
> >> machine.
> >> It can write to a PostGIS database but the functionality is limited - I
> >> haven't really needed it.
> >> I have had limited success in contacting the authors of pgarc to see 
> >> if they
> >> are interested in updating the project.
> >>
> >>
> >
> > Well, if you have managed to make it work with ArcGIS 9.x, that is
> > indeed very sweet. Poking around in the pgarc website, I see that one 
> > of the project managers is 'spatialguru' or Tyler Mitchell. I am
> > pretty sure he is on this list, if not, he is certainly on the
> > MapServer list. He will readily respond to any queries/offers to help. 
> >
> > Unfortunately I know nothing about coding ArcGIS, so I am only a very
> > keen and eager user of such a utility.
> >
> > That said, it seems to extend ArcGIS -- I would much rather prefer to 
> > extend PostGIS so it emulates (something like imsemu) an ArcGIS
> > compatible dsn. That way, an existing ArcGIS installation need not be
> > disturbed, but can happily use PostGIS data, and PostGIS gets a really 
> > nice, albeit neither free nor open source, viewer for its data. Great
> > for existing ArcGIS shops that might want to incorporate PostGIS for
> > backend data management instead of putting up with SDE (I know of one 
> > such shop personally).
> >
> >>
> >>
> >>
> >> -----Original Message-----
> >> From: postgis-users-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of P
> >> Kishor 
> >> Sent: Wednesday, September 13, 2006 3:25 PM
> >> To: PostGIS Users Discussion
> >> Subject: Re: [postgis-users] Exporting to ESRI's ArcGIS
> >>
> >> Sorry, no help here (am curious about this meself), but I have a 
> >> related question -- anyone figured out how to view PostGIS data in
> >> ArcGIS?
> >>
> >> On 9/13/06, Michael de Armas (Micotan) < michael.dearmas at micotan.com
<mailto:michael.dearmas at micotan.com> >
> >> wrote:
> >> >
> >> >
> >> > Thanks, for the suggestion.
> >> >
> >> > Is that the only way? Let's say that, for some reasons, I cannot 
> >> install
> >> > PostGIS in the PC where the app will run and/or I don't want to call
an
> >> > external program to do the job.
> >> >
> >> > I was thinking something like saving the geometry to a GML file, but
I 
> >> don't
> >> > know if ESRI could read the GML that PostGIS generates.
> >> > _______________________________________________
> >> > postgis-users mailing list
> >> > postgis-users at postgis.refractions.net
> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users 
> >> >
> >> >
> >> >
> >>
> >>
> >> --
> >> Puneet Kishor http://punkish.eidesis.org/ 
> >> Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/
> >> Open Source Geospatial Foundation https://edu.osgeo.org/ 
> >> _______________________________________________
> >> 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
> >>
> >
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (GNU/Linux)
> Comment: Using GnuPG with Debian - http://enigmail.mozdev.org
>
> iQCVAwUBRQievtpwN1sq38njAQJjRQP/cfTfO65zgmeMSs4hVUYB0vCWpyLcrYj6
> Gk/RowI0X/hbFahlAiV4Kx3WeQJU930j0caFWSuzTwo02KJOCJ24EPfMnpBmIsDo 
> RNlVqrd0Fs0V+ZG07LQnSPg1zuHZhL5zxi5WZmypFftWeS2MX2Ka5CkIWE9v3YjN
> WW80b2tg3Rk=
> =ZxK5
> -----END PGP SIGNATURE-----
> _______________________________________________
> postgis-users mailing list 
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users 
>

--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ 
Open Source Geospatial Foundation https://edu.osgeo.org/
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Marco Vieira
+55 21 9499-6800
e-mail: maovieira at gmail.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060914/d677b693/attachment.html>