[postgis-users] ArcGIS Data Interoperability Extension

[RIBOT, Nicolas]

Hi Guy,

Thanx for this review.
I discovered the same as you did concerning the OleDB Postgis Connection:
able to connect, but no access to the postgis tables or views.

What you say makes me think that some improvements to the PgArc module could
still be interesting for postgis users. (partial data download, WKB
reading/writing to speed up object retrieval, possibilty to download data
from a SQL query, improved postgis writing by tracking data that have
changed, etc.)

I will try to see how these developments could be done in an acceptable
schedule.

Regards

Nicolas Ribot

> -----Original Message-----
> From: Guy Carpenter [mailto:guyc at atgis.com.au]
> Sent: Thursday, October 28, 2004 7:37 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] ArcGIS Data Interoperability Extension
> 
> 
> > by the way, I understood that ArcGIS 9.0 was
> > supposed to read gis data from postgis.
> > Is it true ?
> 
> ArcGIS 9.0 does read from PostGIS, via
> wthe Data Interoperability Extension.
> 
> The extension can be trialled free for 30 days, although
> be warned that when I reinstalled ArcGIS my 30
> day trial was abruptly terminated at about day 2.
> 
> Some observations from my (brief) trial:
> 
> - Basic functionality works: I was able to view
> both tables and views defined in PostGIS
> and work with them as layers in ArcGIS.
> 
> - I could not get table browsing working in the extension,
> but specifying a table name explicitly when creating the
> connection in ArcCatalog worked fine.
> 
> - After defining a new PostGIS connection in ArcCatalog,
> and dragging and dropping it into ArcGIS, my polygon layers
> were incorrectly shown in ArcGIS as point layers, and
> appeared empty.  After restarting ArcGIS
> the layers were correctly seen as polygon files.  I had
> to restart ArcGIS each time I defined a new table
> or view.
> 
> - Once (in a few hours of experimenting) ArcGIS generated
> an exception and died.
> 
> - Performance seemed adequate - slower than a shape file,
> but certainly acceptable.
> 
> So in summary the extension works with PostGIS,
> with a few bugs that are not show stoppers.
> 
> I also spent some time examining the ole db
> provider with ArcGIS 9 + PostGIS.  I was able to make
> a connection through
> 	ArcCatalog->Database Connections->Add OLE DB Connection,
> but never able to get any data
> to flow.  The connection appeared to authenticate
> okay, but no tables are accessible.
> 
> After reading this thread, I think I'll
> have a look at PgArc.
> 
> Cheers,
> Guy.
> 
> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
> RIBOT, Nicolas
> Sent: Wednesday, 27 October 2004 1:32 AM
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] ArcGIS Data Interoperability Extension
> 
> 
> > I'm apologize. PgArc work fine with ArcGis 9, too: read/write
> > layer very
> > well!
> >
> 
> Hmm, always pleased to see that this program, developed to 
> learn ArcObject,
> is still useful for some people.
> 
> There are some improvements scheduled for the PgArc module, 
> but developers
> seem to lack time to do it, unfortunately.
> 
> (by the way, I understood that ArcGIS 9.0 was supposed to 
> read gis data from
> postgis.
> Is it true ?
> I never succeeded in setting a new working OleDB connection 
> to postgis.
> 
> Nicolas.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
-------------- next part --------------
---------------------------------------------------------

CE COURRIER ELECTRONIQUE EST A USAGE STRICTEMENT INFORMATIF ET NE SAURAIT ENGAGER DE QUELQUE MANIERE QUE CE SOIT EADS ASTRIUM SAS, NI SES FILIALES.

SI UNE ERREUR DE TRANSMISSION OU UNE ADRESSE ERRONEE A MAL DIRIGE CE COURRIER, MERCI D'EN INFORMER L'EXPEDITEUR EN LUI FAISANT UNE REPONSE PAR COURRIER ELECTRONIQUE DES RECEPTION. SI VOUS N'ETES PAS LE DESTINATAIRE DE CE COURRIER, VOUS NE DEVEZ PAS L'UTILISER, LE CONSERVER, EN FAIRE ETAT, LE DISTRIBUER, LE COPIER, L'IMPRIMER OU EN REVELER LE CONTENU A UNE TIERCE PARTIE.



This email is for information only and will not bind EADS Astrium SAS in any contract or obligation, nor its subsidiaries.

If you have received it in error, please notify the sender by return email. If you are not the addressee of this email, you must not use, keep, disseminate, copy, print or otherwise deal with it.

---------------------------------------------------------