Hi,
Torsten Mohr wrote:
i'm searching for an SQL query that returns the borders of a country or
better, _all_ countries.
The correct SQL query depends on the data structure in your data base.
If your data has been imported from OpenStreetMap then the answer to
your question requires a lot of knowledge about the OpenStreetMap data
model and how osm2pgsql works.
You are on the wrong mailing list. I believe explained this to you already.
To solve your problem, I suggest to import one of the shape files from
http://www.naturalearthdata.com/downloads/10m-cultural-vectors/. The
first file in that list, "Admin 0 - Countries" will give you a nice
polygon for every country in the world.
Bye
Frederik
--
Frederik Ramm ## eMail frede...@remote.org ## N49°00'09" E008°23'33"
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
