[postgis-users] St_within problem

[Sufficool, Stanley]

Use save results to file in pgadmin. It's the icon with arrow by the
floppy.

> -----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 9:11 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] St_within problem
> 
> 
> 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 
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>