I'm currently playing with the PostGIS Queries, too. I tried sth. like
SELECT osm_id, name
FROM planet_osm_polygon
WHERE boundary='administrative' AND
ST_Within(way, (SELECT way FROM planet_osm_polygon WHERE
boundary='administrative' AND admin_level='2' AND name='Deutschland'
LIMIT 1) )
to get all boundaries in germany but i only get Aachen [1] and
Deutschland [2] back. Any idea?
Peter
[1] http://www.openstreetmap.org/?relation=62665
[2] http://www.openstreetmap.org/?relation=51477
Jon Burgess schrieb:
> On Fri, 2009-08-21 at 10:50 +0000, John Smith wrote:
>> --- On Fri, 21/8/09, Peter Körner <osm-li...@mazdermind.de> wrote:
>>
>>> If you have some kind of database anyway (e.g. postgis for
>>> mapnik-rendering on cassini, it shouldn't be the problem.
>> I have a suitable query, I just don't know how to turn the query into kml
>> data, such as lines.
>>
>> select way from planet_osm_polygon where boundary='administrative' and
>> "admin_level"='10'
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
