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

[Stefan Keller]

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 <ssufficool at rov.sbcounty.gov>:
> 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: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] 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: 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
>> >
>> _______________________________________________
>> 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
>