[osmosis-dev] nodes column in way table and way_nodes table

[Igor Podolskiy]

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