[postgis-users] Re: POLYGON from MULTIPOLYGON

[Paul Ramsey]

None of the above. The fastest way is to use

encode(asbinary(the_geom),'base64')

when pulling the geometry, use Java's own base64 decoder and then the 
JTS WKB reader.

Paul

Dylan Lorimer wrote:
> Thanks Paul!
> 
> Last followup question:
> 
> Do you think, in your experience, that it is faster to go from PostGIS 
> to JTS object via:
> 
> 1) casting binary PostGIS object to  PGgeometr and then parsing it to 
> create a JTS object
> 2) Using the JTS WKT Reader on the AsText(...) from the Spatial SQL?
> 
> Cheers,
> -dylan
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users