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

Torsten Mohr tmohr at s.netic.de
Sun Dec 5 01:32:08 PST 2010


i'm searching for an SQL query that returns the borders of a country or 
better, _all_ countries.

For testing i tried queries like:

select name, way from planet_osm_polygon where admin_level <> '' and 

This returns one Polygon that, when drawn, looks like Ireland.

Doing the same for "Deutschland" returns six polygons, of which none looks 
like "Deutschland", more like some of the islands around it.

What is the best way to get the borders of a country?

Best regards,

More information about the postgis-users mailing list