--- On Sat, 22/8/09, Peter Körner <[email protected]> wrote:
> Thank you for the hint :)
I really shouldn't be emailing when tired...
> 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 :)
I just ran that query on my database and used name='Australia' and it works as
you thought it should.
SELECT count(osm_id)
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='Australia'
LIMIT 1))
I'm still waiting for it to finish counting, but I ran it with a limit 10 and
it worked fine.
_______________________________________________
talk mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/talk
