[postgis-users] PostGis to ArcCatalog

[Paul Ramsey]

Bruce,
The PgArc extension, which is a first-order attempt at connectivity,  
is the only working solution I am aware of. I have long wanted to  
attack OleDB, but with the knowledge that it is a lot of work and  
opaque code, have waited for someone to step up with funding to do  
the work. If you want to attempt it yourself, I would suggest the  
first thing to do would be turn on statement logging in your  
PostgreSQL database so you can see what ArcCatalog is asking of your  
database. That would clarify your problems relatively quickly.
For the record, I recently tried the PgOleDb libraries, and did not  
get any success in ArcCatalog, even with non-spatial tables. I think  
getting stuff truly working would involve a great deal of testing  
across every version and patch of the Arc* suite. What Arc* version  
were you testing? (I was trying Arc8)
Paul

On 7-Jun-05, at 5:24 AM, Clay, Bruce wrote:

> I am in the process of building a geo-spatial database using  
> PostgreSql
> 8.0.3 with PostGis.  While I seem to be able to build the database  
> ok, I
> don't seem to be able to use it with ArcGis once I have built it.
>
> I tried to use the PgOleDb interface.  This interface does connect
> ArcCatalog to the database and let me see generic tables it would not
> show any of the PostGis (POINT / POLYGON) data.
>
> I am trying to pin down the source of the problem but since there  
> are so
> many layers (PostgreSql, PostGis, PgOleDb, ArcCatalog), I don't know
> where to begin.  I have communicated with Shamchar (maintainer of
> PgOleDb) but he did not know of a fix for the problem.
>
> Does anyone know of any way to use PostGis data with ArcCatalog or
> ArcMap.
> The solution really needs to be an Open Source / free one to meet
> project requirements.
>
> Bruce
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>