Even with astext the geomery is so complex the text can not be deciphered
as shown in the Output pane.
And pgadmin doesn't have a copy feature (as far as I know).
Bob
----- Original Message -----
From: "Michael Smedberg" <[email protected]>
To: "PostGIS Users Discussion" <[email protected]>
Sent: Tuesday, October 20, 2009 8:29 AM
Subject: Re: [postgis-users] St_within problem
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
