[postgis-users] Arc catalog (Arc GIS) import

[Clay, Bruce]

Eric:
  You said "not possible with ArcObjects".  Just out of curiosity have
you tried a mixture of ArcObjects and GDAL/OGR?  I have that on my list
of things to do but I don't want to go down that path if it has been
tried and doesn't work.

Bruce


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Randall, Eric
Sent: Wednesday, November 26, 2008 9:55 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Arc catalog (Arc GIS) import

Hi John,


You could create a custom menu/toolbar in ArcMap or ArcCatalogue and
then using VBA:

1. use the "Shell" command to pass pgsql2shp (or ogr2ogr) command and
it's arguments to the database (or .bat doing the same).

2. add the shape(s) to your project (or "Refresh" if already there).

It's not very beautiful but I use this method to pass arguments from
ArcMap to PostGIS functions to do their work and then
write updated shapes back out.  A pretty "loose coupling" to PostGIS
admittedly.  Two reasons I do this are:

1. To do things that are easier, less agravating, or not possible (for
me anyway) with Modelbuilder,Toolbox,ArcObjects.

2. If you need to showcase some PostGIS functionality and people don't
see an ESRI frontend, they tend to look at you like you have three
heads. 


I look forward to using ZigGIS. That will eliminate the shape writing
stuff.  That's still a month away though (new year, new budget).


-Eric

Eric Randall
GIS DB Admin/Analyst
County of Erie
140 W 6th St
Room 119
Erie, PA 16501

ph. 814-451-6063
fx. 814-451-7000


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of John
Abraham
Sent: Tuesday, November 25, 2008 7:00 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Arc catalog (Arc GIS) import


A colleague told me that ArcGIS could import postgis layers directly, 
without using Ziggis.  I've been googling around and playing with ArcMAP

and ArcCatalog trying to figure it out, but no luck so far.

I know I could use pgsql2shp.  And I know I could use Ziggis commercial 
(2.x) or Ziggis open source (1.x). But for our needs a direct import 
menu item within ArcMAP or ArcCatalog would be best, as they would like 
to frequently view snapshots of the data. 

Any other suggestions also appreciated, thanks.

--
John Abraham
jabraham at ucalgary.ca


_______________________________________________
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



This message and any enclosures are intended only for the addressee.  Please  
notify the sender by email if you are not the intended recipient.  If you are  
not the intended recipient, you may not use, copy, disclose, or distribute this  
message or its contents or enclosures to any other person and any such actions  
may be unlawful.  Ball reserves the right to monitor and review all messages  
and enclosures sent to or from this email address.