Hi Michel,
For example:
SELECT id, nodes FROM ways WHERE id=55579416;
delivers:
55579416; "{299810549,299809848,299810550,259983366}"
SELECT way_id, node_id, sequence_id FROM way_nodes WHERE way_id=55579416;
delivers:
55579416;299810549;0
55579416;299809848;1
55579416;299810550;2
55579416;259983366;3
hmm, indeed, I overlooked that, sorry. I don't know the reason why it is
stored twice... Apparently it has been added to avoid joins for some
common operations (see commit 6a507fa, [1]). So you're right, it is
stored redundantly. Sorry again for the confusion.
Bye
Igor
[1]
https://github.com/openstreetmap/osmosis/commit/6a507faca5a5c902ce6a24554fae467d79910bc0
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
