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

[Paragon Corporation]

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