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