[postgis-users] Test a point in a geomety...

[Paul Ramsey]

In brief, yes. The Contains() predicate should be sufficient.

Nick Ton wrote:
> 
> Hi David,
> 
> My apology, so does that mean that truly_inside() will be deprecated by
> another function?
> 
> nick
> 
> -----Original Message-----
> From: David Blasby [mailto:dblasby at refractions.net]
> Sent: Wednesday, June 11, 2003 4:46 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Test a point in a geomety...
> 
> 
> 
>>SELECT name from airport_tbl where
>>truly_inside(the_geom,GeomtryAsText('BOX3D( -99 50.2, -99 50.2)',-1)) =
>>true;
> 
> 
> Dont you use truly_inside! I'm going to delete it from postGIS so noone 
> ever uses it again.
> 
> You can use:
> SELECT  name FROM airport_tbl WHERE the_geom && GeomtryAsText('POINT(-99 
> 50.2)',-1)) and distance(the_Geom,GeomtryAsText('POINT(-99 50.2)',-1))) ==0;
> 
> This uses the spatial index, so it should be fast.
> 
> NOTE: if the point is very very close to the boundary, the distance() 
> function may not return 0.
> 
> If you are using the GEOS enhanced postgis, you can do this calculation 
> robustly with the contains() function.
> 
> 
>>It would be great if someone would teach a class on just creating
> 
> effective
> 
>>queries on PostGIS. There's so much
>>that you can do with it.
> 
> 
> Yes - I'd love to write more documentation and examples for postGIS, but 
> I dont have the time.  Does anyone out there have time?
> 
> 
> dave
> 
> 
> _______________________________________________
> 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


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_