[postgis-users] query example??

[AGT]

Hey man thanks

Only I need to do a query: how many points there are in a geological
unit (obviusly an irregular polygon, as in nature), what is the syntax;
Tried with your sentence and shows all the poinst, only need the points
INSIDE the irregular polygon how can I obtain that, give me patience
thanks




El vie, 23-07



-2004 a las 10:03, Tyler Mitchell escribió:
> 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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users