You can use the astext function to get the WKT ("well known text".)
E.g. you could do something like:SELECT astext(the_geom) FROM library.dgm_process which would return a textual representation of the geometries. ST_GeomFromText is the opposite of astext- it'll convert the text to a geometry object. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bob Pawley Sent: Tuesday, October 20, 2009 8:09 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] St_within problem The geometry comes up true for st_isvalid and yes the points are covering the geometry and beyond. I'm curious as to how I could retrieve the geometry in order to include them in an e-mail. As a shapefile perhaps?? Bob ----- Original Message ----- From: "Maxime van Noppen" <[email protected]> To: "PostGIS Users Discussion" <[email protected]> Sent: Monday, October 19, 2009 9:55 AM Subject: Re: [postgis-users] St_within problem > Bob Pawley wrote: >> Funny this does work when I include st_box2d as in - >> >> st_within( graphics.point_grid.the_geom, >> st_box2d(library.dgm_process.the_geom)) >> >> However, this will include points within the box yet outside of the >> actual geometry. > > It's hard to help without some additionnal data. Did you check that your > geometry is valid (ST_IsValid) ? Did you manually check that it actually > contains points ? > > -- > Maxime > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
