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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Abraham Sent: Tuesday, November 25, 2008 7:00 PM To: [email protected] 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 [EMAIL PROTECTED] _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
