[postgis-users] Query: find the country of a location / city

[pcreso at pcreso.com]

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 <tmohr at s.netic.de> wrote:

From: Torsten Mohr <tmohr at s.netic.de>
Subject: [postgis-users] Query: find the country of a location / city
To: postgis-users at postgis.refractions.net
Date: Monday, November 7, 2011, 4:49 AM

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 list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111106/2122d3eb/attachment.html>