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 postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
