[postgis-users] Polygon from point query

[David Fawcett]

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
<POYNTER at adeq.state.ar.us> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>