Stan, I would be interested if you get this working. As far as your error, I haven't played with geodatabase upsized or ArcMap for that matter, but I'm suspecting your issue may be a casing one.
When you upsized your table are all your fields upper case or they are in the geodatabase (as I recall I think geodatabase structure has all uppercase fields). Or are they lowercase. My guess is your query goes thru okay but when ArcGIS tries to pull it it is making an assumption about the casing of the fields or no assumption and those 2 are not in agreement. Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sufficool, Stanley Sent: Friday, December 05, 2008 5:55 PM To: PostGIS Users Discussion Subject: RE: [postgis-users] Arc catalog (Arc GIS) import 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
