[OSM-talk] Weather overlay

[Peter Körner]

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-lists at 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'