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
