[postgis-users] newbie WITHIN query

[Mark Fenbers]

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)