[postgis-users] Re: POLYGON from MULTIPOLYGON

Dylan Lorimer edylan at google.com
Thu Nov 16 14:32:20 PST 2006


Do you mean to use JTS WKT reader...? As there doesn't appear to be  WKB
reader.
http://www.vividsolutions.com/jts/javadoc/index.html
-dylan

On 11/16/06, Paul Ramsey <pramsey at refractions.net> wrote:
>
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
E. Dylan Lorimer | Google Earth Enterprise
650.253.2459 (O) | 650.862.6810 (M) | 650.644.0182 (F)
--------------------------------------------------------------------------------
Earth Enterprise Support: fusion at google.com | 866.4GO.OGLE ext. 4
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061116/2747fec0/attachment.html>


More information about the postgis-users mailing list