Re: [OSM-talk] Weather overlay

[Peter Körner]

Peter Körner schrieb:
> The second should fetch the border of Germany and the first one all 
> boundaries in that. At least that's what I want it to do :)

Okay, it works with smaller relations like the landuse of my town:

SELECT osm_id, name
FROM planet_osm_point
WHERE
ST_Within(way, (
   SELECT way
   FROM planet_osm_polygon
   WHERE osm_id = 37655353
   LIMIT 1
)) AND
name != ''
LIMIT 25

returns all POIs in Gau-Odernheim and

SELECT osm_id, name
FROM planet_osm_polygon
WHERE ST_Within(way, (
   SELECT way
   FROM planet_osm_polygon
   WHERE osm_id = 37655353
   LIMIT 1
))
LIMIT 25

all places, but it won't work with the relation that makes up the German 
border (51477).

Peter

_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk