Jon Burgess wrote:
> On Sun, 2009-08-09 at 21:27 +0200, Stephan Knauss wrote:
>> I want to get for example all airport nodes that miss a name.
I think I figured it out. There is a keyword "EXCEPT" that was unknown
to me. I think it's providing the functionality I was looking for.
Can someone query the whole planet? I currently only have an excerpt.
The result should be the same 454 nodes Jon got out of the mapnik table.
select airports.node_id from
(select node_id from node_tags where v='aerodrome') as airports except
(select distinct name.node_id from node_tags as name, node_tags as a
where a.node_id=name.node_id and a.v='aerodrome' and (name.k='name'))
Stephan
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
