[postgis-users] newbie WITHIN query

[strk at refractions.net]

On Thu, Dec 01, 2005 at 10:10:49AM -0500, Alec Brecher wrote:
> Mark: Thanks for your suggestion. I tried your WITHIN syntax and still 
> have the same result - all are false.  -Alec

I don't understand why didn't within() return an error since you are
trying to operate with geoms in diferent SRS
(postgis_full_version() output again?)

You need to operate in a single SRS.
Your point as a negative X value, while your district 22 extent
is full positive. So, is your point really intended to
be in 4326 ?

Try Within(transform(pointFromText('..', 4326), 2285), the_geom)

--strk;



> 
> Mark Fenbers wrote:
> >Why are your SRIDs different?  2285 vs 2156.  You need to make a 
> >transform()ation first.
> >
> >You can also try an alternate method...
> >
> >WITHIN(SetSRID(MakePoint(-122.916725,47.046528),2285),the_geom)
> >
> >Mark
> >
> >
> >>I have successfully (I think) loaded a set of Washington State 
> >>polygons into a table with SRID 2285 (NAD83 ftUS Washington North).
> >>
> >>  WITHIN( pointFromText('POINT(-122.916725 47.046528)',2156), the_geom)
> >
> >
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> -- 
> Alec Brecher
> AtomD / E Research Resources
> office: 802 253-8908
> http://www.atomd.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email