<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=899210715-20072007><FONT face=Arial size=2>Hello
All,</FONT></SPAN></DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial size=2>Can any one tell
what I am doing wrong with the following select.</FONT></SPAN></DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial size=2>select
geometry('\\005\\000\\000\\000\\010\\247\\033\\113\\056\\263\\053\\101\\213\\236\\223\\165\\164\\062\\046\\101\\006\\377\\131\\025\\172\\266\\053\\101\\350\\300\\323\\152\\241\\067\\046\\101\\001\\000\\000\\000\\006\\000\\000\\000\\000\\000\\000\\000\\010\\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\\234\\067\\046\\101\\205\\364\\147\\256\\134\\266\\053\\101\\350\\300\\323\\152\\241\\067\\046\\101\\006\\377\\131\\025\\172\\266\\053\\101\\230\\025\\330\\025\\171\\062\\046\\101\\034\\227\\351\\330\\331\\263\\053\\101\\366\\105\\154\\104\\165\\062\\046\\101\\136\\376\\167\\260\\113\\263\\053\\101\\213\\236\\223\\165\\164\\062\\046\\101\\010\\247\\033\\113\\056\\263\\053\\101\\376\\053\\330\\300\\234\\067\\046\\101\\000'::bytea);<BR></FONT></SPAN></DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial size=2>I am trying to
convert a ESRI shape which is stored as a blob in SQL Server 2000 to postgis. I
am using Npgsql to connect to postgis. This is the out I got from Npgsql. I know
this is a valid shape and when I imported the data using shp2pgsql from the
shape file it imported fine.</FONT></SPAN></DIV>
<DIV><SPAN class=899210715-20072007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=899210715-20072007></SPAN><FONT face=Arial size=2><SPAN
class=899210715-20072007>Thank you,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=899210715-20072007></SPAN></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Murali K. Maddali</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>UAI, Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>(256) 705-5191 (W)</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:murali.maddali@uai.com">murali.maddali@uai.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2><I>"Always bear in mind that your own
resolution to succeed is more important than any one thing." - Abraham
Lincoln<BR></I></DIV></FONT>
<DIV> </DIV>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.</BODY></HTML>