Hello, thanks a lot for your answer. I'll have a look at the web page you suggested.
Sorry, if my mail was off-topic here, i was not aware of that. You mentioned that before, related to another mail, that it was off-topic here. For the issue related to this mail it was not obvious to me that it is off- topic here as i was not aware of the dependency on the OSM data structure. Best regards, Torsten. Am Sonntag, 5. Dezember 2010, 18:26:58 schrieb Frederik Ramm: > 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
