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 <tm...@s.netic.de> wrote: From: Torsten Mohr <tm...@s.netic.de> Subject: [postgis-users] Query: find the country of a location / city To: postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users