[postgis-users] searching a valid query to return the borders of a country

[Torsten Mohr]

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