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

[Igor Podolskiy]

Michel,

please reply to the list, _not_ just to me in person. Thank you.

On 21.12.2011 14:00, Michel Seuthe wrote:
> Hmm okay, but that means all references from the way to it's nodes are
> stored in way_nodes and in way table. Which would be a mass of redundant
> data...
Why do you think it is redundant? It isn't. The node sequences of the 
ways aren't stored anywhere else in the database. The snapshot schema is 
as 2nd normal form as it can get...

The ways table store only the assembled line strings, i.e. the 
_geometry_ of the way derived from the node sequences. If you don't need 
this or if this is a problem for you, use another schema. APIDB, for 
example, does not store assembled geometries.

Bye
Igor