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

[Sufficool, Stanley]

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: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] 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: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>