[postgis-users] decode geometry

[Paul Ramsey]

Geoserver has had some success in using encode(asbinary 
(the_geom),'base64') as a means of encoding geometries in a 7-bit  
clean wrapper for WKB.  Spares one having to futze around with binary  
cursors.  Then you use a base64 decode on your client to get the byte  
array and then write a wkb decoder in your client.  Fun fun.

Note that this is hardly a "solution" to your problem, since even if  
you reduce your overhead by 50%, Murphy's Law says there will still  
be the occasional geometry large enough to break your application.

P

On May 9, 2006, at 8:11 AM, Bruce Rindahl wrote:

> The project PgArc uses Visual  Basic to parse WKT format into a  
> shapefile for ArcGIS so this would not help.  If you are successful  
> in decoding WKB please post and I will try to include it into PgArc.
>
> Thanks
>
> Bruce Rindahl
>
>
>
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis- 
> users-bounces at postgis.refractions.net] On Behalf Of Miguel de la  
> Fuente
> Sent: Tuesday, May 09, 2006 8:53 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] decode geometry
>
>
>
> Hello, we're trying to view PostGis data from Visual Basic using a  
> binary cursor
> (trough ODBC) because features in some tables has too many points  
> and the
> function astext() returns strings unacceptably large (about 400  
> KBytes).We
> think that receiving it as binary will decrease size and increase
> performance. Does anybody know how can we decode geometry data from  
> wkb or
> any documentation about it?
> Thanks.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users