[postgis-users] newbie WITHIN query

[Robert Burgholzer]

I would try to verify the following:

- the geometrys have been loaded, and have the coords you think they
should:
   SELECT extent([geom Column name]) FROM [table name];

- the geometry has been set to the correct SRID
   SELECT getsrid(the_geom) FROM [table name] limit 1;


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Alec
Brecher
Sent: Thursday, December 01, 2005 9:35 AM
To: PostGIS Users Discussion
Subject: [postgis-users] newbie WITHIN query

I have searched the docs and am still a bit confused....

I have successfully (I think) loaded a set of Washington State polygons 
into a table with SRID 2285 (NAD83 ftUS Washington North).

When I try to test WITHIN with a point which I know is within one of the

polygons:
SELECT district,
   WITHIN( pointFromText('POINT(-122.916725 47.046528)',2156), the_geom)
FROM dist

all districts return false. I have tested this point in MapInfo with the

same projections and find the point within district 22.

Any help would be greatly appreciated.  -Alec
-- 
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