[postgis-users] geometry(bytea)

[Murali Maddali]

This is a ESRI shape file record, untranslated. Can you suggest me how to
translate this. 

I am reading the blob from SQL Server 2000 using C# which return a Byte[]
and convert this Byte[] to bytea and pass this to Npgsql command object as a
parameter. 

Thank you,
Murali K. Maddali
256-705-5191
murali.maddali at uai.com

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Friday, July 20, 2007 6:10 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] geometry(bytea)

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
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.