You are looking for st_intersects() http://postgis.refractions.net/documentation/manual-1.5/ST_Intersects.html
David. On Tue, Dec 28, 2010 at 1:49 PM, Poynter, David <[email protected]> wrote: > This is probably an easy one, but being a PostGIS newb I've been spinning my > wheels and haven't the google fu to locate an answer, so here goes... > > > > I have a table of counties from the state (county) and I'm creating a point > to insert in another table and I would like to find the county the point > falls in. > > I think I should be able to do it in one query rather than looping thru > county by county, but I can't seem to put it together. > > > > SELECT county_nam FROM county WHERE ? > > > > I've been looking at ST_Within() and think the answer lies with it somehow, > thanks for any clues... > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
