[postgis-users] geometry(bytea)

[Paul Ramsey]

What is the format of your bytea?  If it's the ESRI shape file  
record, untranslated, you're out of luck.  If it's a WKB byte array,  
then use GeomFromWKB.

P

On 20-Jul-07, at 8:17 AM, Murali Maddali wrote:

> Hello All,
>
> Can any one tell what I am doing wrong with the following select.
>
> 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);
> 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.
>
> Thank you,
>
> Regards,
> Murali K. Maddali
> UAI, Inc.
> (256) 705-5191 (W)
> murali.maddali at uai.com
>
> "Always bear in mind that your own resolution to succeed is more  
> important than any one thing." - Abraham Lincoln
>
> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users