[postgis-users] newbie WITHIN query

Alec Brecher alec at eresearchresources.com
Thu Dec 1 07:10:49 PST 2005


Mark: Thanks for your suggestion. I tried your WITHIN syntax and still 
have the same result - all are false.  -Alec

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



More information about the postgis-users mailing list