[postgis-users] Exporting to ESRI's ArcGIS

[Bruce Rindahl]

The problem is ArcGIS does not respond to a "spatial" dsn.  All of the
spatial functions are buried in the ArcGIS code.  SDE connections simply
grab the binary blob in the database and ArcGIS grabs is from there.  Pgarc
created a SQL command for the data and parses the WKT format into a
shapefile.
By the way, there is a great PostGIS interface for ArcView 3.x that works
great.  It is at:
http://sourceforge.net/projects/avpgcon/
Bruce Rindahl

-----Original Message-----
From: punk.kish at gmail.com [mailto:punk.kish at gmail.com] On Behalf Of P Kishor
Sent: Wednesday, September 13, 2006 3:40 PM
To: rindahl at lrcwe.com; PostGIS Users Discussion
Subject: Re: [postgis-users] Exporting to ESRI's ArcGIS

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


-- 
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/