[postgis-users] from EWKB to WKB

[Worth Lutz]

SELECT
<http://postgis.refractions.net/documentation/manual-1.4/ST_AsBinary.html>
ST_AsBinary(
<http://postgis.refractions.net/documentation/manual-1.4/ST_GeomFromEWKB.htm
l> ST_GeomFromEWKB('01 01000020 04000000
000000000000F03F0000000000000000'));

 

 

Just a guess!  I haven't tried it.

 

Worth

 

 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Denis Rouzaud
Sent: Thursday, April 25, 2013 5:59 AM
To: PostGIS Users Discussion
Subject: [postgis-users] from EWKB to WKB

 

Hi all,

I have a EKWB string, and I'd like to transform it to WKB.

Can I do this by removing the characters from position 3 to 10, like:


SELECT 'SRID=4;POINT(1 0)'::geometry
01 01000020 04000000 000000000000F03F0000000000000000

'POINT(1 0)'::geometry;
01 01000000          000000000000F03F0000000000000000

Thanks a lot,

Denis

  _____  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3272 / Virus Database: 3162/6270 - Release Date: 04/24/13

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130425/920f4c15/attachment.html>