Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Peter Körner
Hopefully you don't kill me right off but I re-created this Testcase in the OSM db. I only used a comment tag on each element so they won't get rendered and are identifiable in the history as Testcase later. I also created them near my home where I'm the only active mapper I now of. ==

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Tom Hughes
On 16/09/09 15:17, Peter Körner wrote: == Decisions == The Choice that is up to be made now is between the following three possibilities a) do not implement these calls b) implement them on demand c) implement them with a new column/index [ snipped ] c) this will cost

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Ian Dees
On Wed, Sep 16, 2009 at 9:30 AM, Tom Hughes t...@compton.nu wrote: This is NOT true. As I explained yesterday there is a very good reason why we do not store a node revision in current_way_nodes and way_nodes. The problem is that if you do that then every time a node is changed you have to

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Peter Körner
c) this will cost disk-space and memory for the index. The CPU time will be consumed only once. This is NOT true. As I explained yesterday there is a very good reason why we do not store a node revision in current_way_nodes and way_nodes. I'm sorry I should have mentioned that all

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Peter Körner
Ian Dees schrieb: On Wed, Sep 16, 2009 at 9:30 AM, Tom Hughes t...@compton.nu mailto:t...@compton.nu wrote: This is NOT true. As I explained yesterday there is a very good reason why we do not store a node revision in current_way_nodes and way_nodes. The problem is that

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Ian Dees
On Wed, Sep 16, 2009 at 1:41 PM, Peter Körner osm-li...@mazdermind.dewrote: 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

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Peter Körner
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): 50v151v152v2 ...and a history

Re: [OSM-dev] [OSM-talk] Abstract on getting historic information about usage of a node

2009-09-16 Thread Ian Dees
On Wed, Sep 16, 2009 at 2:19 PM, Peter Körner osm-li...@mazdermind.dewrote: 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