[postgis-users] St_within problem

[Michael Smedberg]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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" <maxime at altribe.org>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
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
> 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