try something like
select placename from table where ST_Contains(geom,point);
This will return the placename for all polygons (geom) which contain the
specified point.
HTH,
Brent Wood
--- On Mon, 11/7/11, Torsten Mohr wrote:
From: Torsten Mohr
Subject: [postgis-users] Query: find the
Hope this helps
Phil
>
>From: Torsten Mohr
>To: postgis-users@postgis.refractions.net
>Sent: Sunday, 6 November 2011, 15:49
>Subject: [postgis-users] Query: find the country of a location / city
>
>Hello,
>
>i search for a SQL query tha
Hello,
i search for a SQL query that lets me find the country of a given location
(mercaator latitude / longitude) or a city name.
Can anybody give me a hint on how to formulate such a query?
Thanks for any hints,
Torsten.
___
postgis-users mailing l