<div dir="ltr">I didn't say that we have to repeat the addr:postcode, or addr:province, etc. That's not taken from the node/building anyway. There we really need an area representing the postcode. <div><br></div><div>
So repeating the address field or keeping a reference to another table does make a huge difference, a varchar(1024) or a pointer of 64 bits ? Where the latter saves you a join to find the streetname. You'll need the streetname field anyway, since not everybody is using associatedStreets. And don't forget our Belgian compromise to place the name on the street, the relation and the node/building.</div>
<div><br></div><div>Did you see <a href="http://www.openstreetmap.org/user/Pieren/diary/20385">http://www.openstreetmap.org/user/Pieren/diary/20385</a> ? More or less the same conclusions., associatedStreets aren't accepted.</div>
<div><br></div><div>The associatedStreet relation is the best solution from a database design point, but with the current mappers (non-dba's) and the set of tools we have (both editors and consumers), it seems more like a useless vehicle that's difficult to explain and maintain.</div>
<div><br></div><div><div>And BTW, I can say the same for repeating the name of the city on each busstop, a waste of diskspace :-) </div></div><div><br></div><div>Maybe we should more focus on getting the city and postal code boundaries into OSM, so we do not have to repeat that data on the lower level features (not on the relations, nor on the nodes).</div>
<div>When the data can be found by the position of a node, there is no need to repeat it.</div><div><br></div><div>When we can start the import of AGiV/Crab it might be easy to have the relations and the necessary information on the nodes, but right now, with the current set of tools of JOSM, it's hard to keep it correct. I don't know for other editors.</div>
<div><br></div><div>Furthermore in JOSM you can't add POI's and buildings with the same house number without warnings. This might scare people as well.</div><div><br></div><div>A lot people that add information for the first time, add an address in iD, without associatedStreet. So during the import, a poor soul might figure out how to merge that data with the imported data and update the associatedStreet in the correct way. I'm thinking how I can describe this so less experienced mappers than you and me understand what they should do.</div>
<div><br></div><div>Anyway, off my soapbox. </div><div><br></div><div>For you poor machine, which options to you give to JOSM at startup time? Do you use -Xmx (max heap size) ? Do you use a 64-bit java VM ?</div><div><br>
</div><div>m</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Nov 15, 2013 at 12:38 PM, Jo <span dir="ltr"><<a href="mailto:winfixit@gmail.com" target="_blank">winfixit@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Here are a few applications which suffer from repeating the same information millions of times:<br>
<br></div>PostGIS<br></div>wget<br></div>the bandwith of my internet provider for downloading all that cruft<br>
</div><div>scripts to unpack and read those exorbitantly long XML files, even when I'm not working with those addresses, so I'm unpacking and processing them in vain over and over again.<br><br></div><div>Even with 8G of memory I can't seem to hand JOSM more than about 1G to work with. Every time autosave kicks in, I'm waiting. I'll be waiting even longer when those xml files grow even larger. And technology improvements like SSDs only help so much.<br>
<br></div><div>Applications on mobile platforms (the ones Ivo is talking about) would also benefit from a sensible approach. All that processing drains the battery even faster and memory for those devices are at premium prices. So it would make a lot more sense for those apps to be improved, than for us to start millioniplicating data.<span class="HOEnZb"><font color="#888888"><br>
<br></font></span></div><span class="HOEnZb"><font color="#888888"><div>Jo<br></div></font></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">2013/11/15 Ivo De Broeck <span dir="ltr"><<a href="mailto:ivo.debroeck@gmail.com" target="_blank">ivo.debroeck@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I agree with that, address:street is easily to change or view at all apps for smartphones or tablets too. </div>
<div class="gmail_extra"><div><div><br><br><div class="gmail_quote">2013/11/15 Marc Gemis <span dir="ltr"><<a href="mailto:marc.gemis@gmail.com" target="_blank">marc.gemis@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Got this answer from lonvia on <a href="http://help.osm.org" target="_blank">help.osm.org</a><div><br></div>
<div><p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none">
You've mapped it correctly, Nominatim is just not very good at updating associatedStreet relations. It's a <a href="https://trac.openstreetmap.org/ticket/4619" style="color:rgb(48,96,168);text-decoration:none" target="_blank">known bug</a>.</p>
<p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none">Here is what happened: you've originally put the house into <a href="http://www.openstreetmap.org/browse/relation/2594673" style="color:rgb(48,96,168);text-decoration:none" target="_blank">this associatedStreet relation</a> which does contain the 'Pierstraat - Matenstraat' street. Nominatim simply uses the first street it finds in such a relation for the name an ignores all tags on the relation itself, so that is where the name comes from. Later you have moved the house to the new relation and that move was not caught by Nominatim's update process. The houses will only be updated when they are changed themselves again.</p>
<p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none"><br></p><p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none">
<br></p><p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none">also interesting is this quote from lonvia in the above mentioned bug:</p>
<p style="line-height:18px;max-width:700px;font-size:13px;background-color:rgb(235,255,230);font-family:sans-serif;margin:0px 0px 13px;padding:0px;border:medium none"><br></p><p style="font-size:13px;font-family:Verdana,Arial,'Bitstream Vera Sans',Helvetica,sans-serif">
Nominatim would be perfectly happy if you added only addr:street tags and got rid of the associatedStreet relations. The relations mostly don't carry any additional information and are a bit of a pain to handle. addr:street is much better supported.</p>
</div><div><br></div><div>So I wonder more and more whether we should add those theoretically nice associatedStreet relations....</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Thu, Nov 14, 2013 at 1:10 PM, Marc Gemis <span dir="ltr"><<a href="mailto:marc.gemis@gmail.com" target="_blank">marc.gemis@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">the help thread is here: <a href="https://help.openstreetmap.org/questions/28075/how-to-correctly-map-a-pois-address" target="_blank">https://help.openstreetmap.org/questions/28075/how-to-correctly-map-a-pois-address</a><div>
<br></div><div>seems that Nominatim was not updated after the associatedStreet-relation update</div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Nov 14, 2013 at 10:50 AM, Marc Gemis <span dir="ltr"><<a href="mailto:marc.gemis@gmail.com" target="_blank">marc.gemis@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I'm reading <a href="http://wiki.openstreetmap.org/wiki/Nominatim/Development_overview" target="_blank">http://wiki.openstreetmap.org/wiki/Nominatim/Development_overview</a> again, especially the section on "Building indexing"<div>
<div><br></div><div>Buildings, houses and other lower than street level features (i.e., bus stops, phone boxes, etc.) are indexed by relating them to their most appropriate nearby street.</div><div>The street is calculated as:</div>
<div>1. The street member of an associatedStreet relation</div><div>2. If the node is part of a way:</div><div>2.1 If this way is street level, than that street</div><div>2.2 The street member of an associatedStreet relation that this way is in</div>
<div>2.3 A street way with 50/100 meters and parallel with the way we are in</div><div>3. A nearby street with the name given in addr:street of the feature we are in or the feature we are part of</div><div>4. The nearest street (up to 3 miles)</div>
<div>5. Not linked</div></div><div><br></div><div><br></div><div>It seems that it takes one of the streets from the associatedStreet relation to work with. The segment should be long enough (longer than 50-100 m ?). It then works with this street. It simply ignores the tags on the associatedStreet. This would make the relation useless to solve any issue regarding name and postcode for streets that are the border between 2 villages.</div>
<div><br></div><div><br></div><div>The 2 names in the standard tag are "required", otherwise many QA-tools will complain name:left/right is not recognized, or are they ? (yeah I know do not tag for ... :-) )</div>
<div>You can't use a semi-colon in the name (to indicate multiple names) otherwise another bunch of QA-tools complain that there are 2 names on a "highway".</div><div><br></div><div>BTW, the postcode is also wrong in my example. It should be 2840.</div>
<div><br></div><div>It has time, Glenn, it's wrong for several weeks now, so a day more or less does not matter.</div><span><font color="#888888"><div><br></div><div>m</div><div><br></div><div><br></div>
</font></span></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>
On Thu, Nov 14, 2013 at 10:26 AM, Ben Abelshausen <span dir="ltr"><<a href="mailto:ben.abelshausen@gmail.com" target="_blank">ben.abelshausen@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>
<div dir="ltr"><div class="gmail_extra"><div><br><div class="gmail_quote">On Thu, Nov 14, 2013 at 10:20 AM, Glenn Plas <span dir="ltr"><<a href="mailto:glenn@byte-consult.be" target="_blank">glenn@byte-consult.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>If it can wait I'll check this evening with full attention.<span><font color="#888888"><br></font></span></div>
</blockquote></div><br></div>That's up to marc. But I guess he would like to see his work be made into something useful. :-)<div><br><br clear="all"><div><div dir="ltr">Met vriendelijke groeten,<br>Best regards,<br>
<br>Ben Abelshausen<br>
<br></div></div>
</div></div></div>
<br></div></div><div>_______________________________________________<br>
Talk-be mailing list<br>
<a href="mailto:Talk-be@openstreetmap.org" target="_blank">Talk-be@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-be" target="_blank">https://lists.openstreetmap.org/listinfo/talk-be</a><br>
<br></div></blockquote></div><br></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
<br>_______________________________________________<br>
Talk-be mailing list<br>
<a href="mailto:Talk-be@openstreetmap.org" target="_blank">Talk-be@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-be" target="_blank">https://lists.openstreetmap.org/listinfo/talk-be</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div></div></div><span><font color="#888888">-- <br><div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><font color="#3366ff">Ivo De Broeck</font></div>
<div style="font-size:13px;font-family:arial,sans-serif"><font color="#3366ff">Valleilaan 13</font></div><div style="font-size:13px;font-family:arial,sans-serif">
<font color="#3366ff">3360 Korbeek-lo</font></div><div style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><div><font color="#3366ff">tel <a href="tel:%2B32%2016%2043%2084%2093" value="+3216438493" target="_blank">+32 16 43 84 93</a></font></div>
<div>
<font color="#3366ff">gsm <a href="tel:%2B32%20486%2017%2061%2013" value="+32486176113" target="_blank">+32 486 17 61 13</a></font></div><div>spanje</div><div>tel <a href="tel:%2B34%20966%20841%20726" value="+34966841726" target="_blank">+34 966 841 726</a></div>
<div>gsm <a href="tel:%2B34%20603%20661%20778" value="+34603661778" target="_blank">+34 603 661 778</a></div></div>
</font></span></div>
<br>_______________________________________________<br>
Talk-be mailing list<br>
<a href="mailto:Talk-be@openstreetmap.org" target="_blank">Talk-be@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-be" target="_blank">https://lists.openstreetmap.org/listinfo/talk-be</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Talk-be mailing list<br>
<a href="mailto:Talk-be@openstreetmap.org">Talk-be@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/talk-be" target="_blank">https://lists.openstreetmap.org/listinfo/talk-be</a><br>
<br></blockquote></div><br></div>