On Wed, Sep 16, 2009 at 1:41 PM, Peter Körner <osm-li...@mazdermind.de>wrote:

> Ian Dees schrieb:
>
> Can a way assume that it uses the most recent version of a node until the
>> way is changed? Then, when a way's revision number increments, all of the
>> rev#'s for the nodes that make up that way are saved along with the way's
>> history.
>>
> But this wouldn't solve the problem of "give me all ways that used node
> #50, v3" as the last time way #10 was updated it only used node #50, v1 and
> so that's the last information that's saved.
>

What's the problem with that? If way 10 did not ever use node 50v3, then it
should not be included in the "give me all ways that use node 50v3" call,
right?

(semi-ASCII-art ahead, arm your fixed-width photos)

Here's way 10v1 (numbers are nodes):

50v1----51v1----52v2

...and a history table like this:
way_id  way_rev  node_id   node_rev
10      1        50        1
10      1        51        1
10      1        52        2

I come along and move node 52, causing a rev on the way and a rev on the
node:

50v1----51v1----52v3

...and a history table becomes:
way_id  way_rev  node_id   node_rev
10      1        50        1
10      1        51        1
10      1        52        2
10      2        50        1
10      2        51        1
10      2        52        3

When you want to find all ways that used node 52v3, you would find way 10.
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk

Reply via email to