[postgis-users] query example??

[Tyler Mitchell]

You probably want to also use a Distance() function in your where clause, 
in addition to &&.

...WHERE points.geom_column && units.geom_column 
AND distance(points.geom_column, units.geom_column) = 0;

Of source, continue adding to the where clause to isolate the single unit 
you are interested in.

Hope that helps.
Tyler

postgis-users-bounces at postgis.refractions.net wrote on 07/23/2004 07:40:47 
AM:

> Hi
> 
> I have a lot of points with coordinates in one shapefile and in another
> shapefile have a geological map right?; how can I do a query for
> instance: how many points are in a geological unit, I use && and ~= but
> the result is a box, but I need only the points that are inside one
> polygon(a geological unit) what I do??? what's the correct syntax???
> help 
> 
> regards
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users