I can't really follow, what your requirements are: You wrote initially: > A colleague told me that ArcGIS could import postgis layers directly, without > using Ziggis.
So, you have an ArcGIS accessing datasource through ArcSDE, and now want to access PostGIS datasources (read-only)? General note: I'm trying to be very careful with ESRI's product names as I think their naming conventions are very confusing (from a recent 'ArcNews': "ArcSDE 8/9 and ArcInfo 8/9 are designed to work together very closely. ArcSDE 8/9 is available in two editions: ArcSDE 8 Enterprise (formerly known as SDE) and ArcSDE 8 Extension to ArcInfo 8 (formerly known simply as ArcSDE)". See this diagram here: http://www.esri.com/news/arcnews/spring04articles/arc9-special/arcgis9-expands.html) Now, as you may know: ArcSDE 9.3 supports PostgreSQL 8.3.0/PostGIS 1.3.2 on Windows. Isn't this part of a solution? An as you wrote initially, isn't it about importing PostGIS layer data (i.e. no writing back)? -- Stefan 2008/12/13 Sufficool, Stanley <[email protected]>: > Well after much head banging, it looks like this would only work for > viewing the features since linking even to an MSSQL database won't let > you edit the features. > > Looks like zigGIS is still the best avenue for now for a non SDE > interconnect. > >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On >> Behalf Of Sufficool, Stanley >> Sent: Monday, December 08, 2008 8:28 AM >> To: PostGIS Users Discussion >> Subject: RE: [postgis-users] Arc catalog (Arc GIS) import >> >> >> 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: [email protected] >> > [mailto:[email protected]] 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: [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 >> > >> _______________________________________________ >> 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
