<HTML><BODY>If you mean osm relation between POI and every address node, <br>such schema will not ever be widely in use.<br><br>As for relational databases, yep one more SQL relation is an option.<br>And for noSQL data storages there are hundred ways to store such relationships.<br><br>Mon, 19 Jan 2015 12:37:32 +0100 от Markus Lindholm <markus.lindholm@gmail.com>:<br>
<blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div>
<base target="_self" href="https://e.mail.ru/">
<div id="style_14216675650000000531_BODY">On 19 January 2015 at 10:39, Friedrich Volkmann <<a href="/compose?To=bsd@volki.at">bsd@volki.at</a>> wrote:<br>
> On 18.01.2015 22:23, Markus Lindholm wrote:<br>
>> I think addresses are proper features, so a distinct address<br>
>> should be found only once in the database.<br>
><br>
> And I see it the other way. Addresses are just attributes. It may pendend on<br>
> the country, I don't know.<br>
<br>
Treating addresses as attributes might be fast and convenient but that<br>
kind of scheme<br>
becomes incoherent as there is no one-to-one relationship between<br>
addresses and other features.<br>
E.g.<br>
- There are MULTIPLE POIs that all relate to ONE address<br>
- There are MULTIPLE addresses that all relate to ONE building<br>
So you would end up with a database where the address information is<br>
stored "all over the place" and no coherent way to process it. Better<br>
to have bare address nodes and when necessary use a relation to create<br>
an association between the address and other features.<br>
<br>
/Markus<br>
<br>
_______________________________________________<br>
Tagging mailing list<br>
<a href="/compose?To=Tagging@openstreetmap.org">Tagging@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/tagging" target="_blank">https://lists.openstreetmap.org/listinfo/tagging</a><br>
</div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote>
<br></BODY></HTML>