[postgis-users] St_within problem

Bob Pawley rjpawley at shaw.ca
Tue Oct 20 09:11:26 PDT 2009


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" <Michael.Smedberg at redfin.com>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
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: 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users 




More information about the postgis-users mailing list