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

[Randall, Eric]

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