[postgis-users] Problems with making own shape dumper

[Paul Ramsey]

Дорофеев А.В. wrote:

> "Is there any method to get feature coords without ASTEXT() function?"

Let me give you the easy one: to get relatively compact coordinates, in 
an easy-to-parse form, use Encode(AsBinary(the_geom),'base64') on the 
database side. On the client side, run a base 64 decoder to get a byte 
array and then the byte array is a standard well-known-binary array of 
coordinates, as described in the SFSQL standard.

P

-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632