I've gained some ground on this and have a partially working st_aspgdb and st_geomfrompgdb function set. I am having snags in getting ArcMap to query the "upsized" data in PostgreSQL. Is anyone out there using ArcMap with an Access Personal Geodatabase upsized/linked to PostgreSQL?
Right now I'm running into "Item not found in this collection" when attempting to preview a layer. I'm not finding any failed queries in the ODBC connector log files, so I'm guessing a field isn't being returned properly to ArcMap. I have the Shape data stored as a bytea field which is presented to ODBC as a LO (Access sees OLE Object). Sorry for the non-postgis questions, but the goal here is transparent PGDB to EWKB bridging, which I'm hoping is of moderate interest. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Sufficool, Stanley > Sent: Monday, December 01, 2008 10:34 AM > To: PostGIS Users Discussion > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import > > > Before I get too far on this and run into a roadblock > (legally or technically), has anyone tried the Personal > Geodatabase linked to a PostgreSQL view? > > My general plan is to create a view using a function to > translate WKB to the ESRI personal geodatabase format and > then have an update trigger take the submitted pgeo shapefile > record from ArcMAP and translate it to the geometry type for > updating the underlying table. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > > Behalf Of Paragon Corporation > > Sent: Wednesday, November 26, 2008 6:32 PM > > To: 'PostGIS Users Discussion' > > Subject: RE: [postgis-users] Arc catalog (Arc GIS) import > > > > > > > > > > > > > > > 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. > > > > Having 3 heads I imagine is more useful than having one > > assuming they are not all fighting with each other :) > > > > <SNIP> > _______________________________________________ > 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
