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

[Sufficool, Stanley]

It looks like ODBC is taking care of the casing issues. On MSSQL, the
fields are quoted, but on PostgreSQL they are passed as unquoted lower
case.

It looks like the returned row(s) aren't parsed correctly by ArcMap.
This may be where the case sensitivity issue is (row['shape'] vs
row['Shape']). I'm recreating all the datasets with quoted proper case
field names to see what happens. Looks like they partially abstracted
the database layer ;)


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paragon Corporation
> Sent: Saturday, December 06, 2008 8:06 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] Arc catalog (Arc GIS) import
> 
> 
> 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
> 
> 
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>