[postgis] ESRI client (ODBC issues)

[Searle Ross]

David,

Any chance of getting a copy of your avenue script as I would love to be
able to implement this functionality.

Regards
Ross

-----Original Message-----
From: David Graham [mailto:dgraham at i3.com]
Sent: Thursday, 23 August 2001 12:41 AM
To: postgis at yahoogroups.com
Subject: Re: [postgis] ESRI client (ODBC issues)


Dear vorelon:

It is possible to use PostGis with ESRI ArcView.  We are currently using

ArcView as a front end for our automated processing system.  We wrote a 
little Avenue script to retrieve GEOMETRY from the PostGis table column 
and then create a polygon theme.  You need to have the Database Access 
extension loaded into AvcView and the Postgres ODBC driver installed oun

your machine and configured to point at your server. In theory it will 
work with any GEOMETRY but currently we are only using Boxes.

The big problem with going this route is that there is a bug between the

Postges ODBC driver (built on the postges library) and Windows (Win32 
kernal) that causes the maximum size of one single line of SQL to be 
16K.  You can see that a complicated polygon will blow that away.  It 
may be only an insert problem (have not tested it with retrieval). We 
are manly trying to insert jobs into our database from ArcView although 
we built the retrieval script to view the jobs that we have inserted.

The nature of the problem is that Windows C socket libraries function 
differently than Unix C socket libraries.  To some extent the required 
fix is understood, but the Postgres developer most suited to fix this 
problem does not have Windows environements to test any kind of fix.  It

has been dropped to the bottom of the bug list (6/2001) until someone 
with a windows environment has the initive to dig through the Postgres 
library code and install and test a fix.  I have not been back reciently

to check if any progress has been made.

There may be a work around if you install a UnixODBC driver on the 
PostGis database machine.  Something we are likely to look into.

As far as ArcIMS I have no experience.

David Graham
Information Integration and Imaging, LLC.
dgraham at i3.com
http://www.i3.com

vorelon at fa.cvut.cz wrote:

> Hi
> Can anybody help me. I need to use PostGis with ESRI products. Is it 
> posible?
>  I convert same shp file into PostGis database, it's fine..... but.
> 
> I am looking for something like ArcSDE from ESRI, full compatible for 
> their clients, like ArcView and ArcIms.
>  Is PostGis the right journey for me? 
> 
> 
> 
> To unsubscribe from this group, send an email to:
> postgis-unsubscribe at yahoogroups.com
> 
>  
> 
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ 




To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ 



************************************************************************
The information in this e-mail together with any attachments is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.

Any form of review, disclosure, modification, distribution
and/or publication of this e-mail message is prohibited.  

If you have received this message in error, you are asked to
inform the sender as quickly as possible and delete this message
and any copies of this message from your computer and/or your
computer system network.  
************************************************************************

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of VeriSign's FREE Guide, "Securing Your Web
site for Business" and learn all about serious security. Get it Now!
http://us.click.yahoo.com/aihfLB/oT7CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/