<div dir="ltr">Thanks for your help Jo, <br><br><div class="gmail_extra"><div class="gmail_quote">On Sun, May 12, 2013 at 1:33 AM, 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">Hi eMerzh,<br><br>I'm sorry, you ended up on the todo / procrastrination pile.<br></blockquote><div><br></div><div>
No problems ;-)<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I looked at your files and you have the building shapes converted already... great! I'd like to learn how you did it.<br>
</blockquote><div><br></div><div>I'm not a qgis expert so it may not be the best/easiest way but :<br></div><div>i've open the .shp files as a vector layer, <br></div><div>then i did a count of address in the building polygons (Vector > analysis > pt in polygone) <br>
</div><div>then i save all building with 1 addresses in anither shape file , <br></div><div>then i did a datamanagement tools > join by location to put address attributes in the building.<br><br></div><div>Then saved the shape as a WGS84 and i opened it in josm ... a few attribute renaming and i saved it in .osm.. and voilą :d<br>
<br><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>I would have added associatedStreet relations to the osm files as well. </blockquote><div>
</div><div>mmm yeah ... unfortunately i don't see how i can do that <br><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Combine addr:street:fr and addr:street:nl in addr:street or omit it/them altogether.<br>
</blockquote><div><br></div><div>yes i know that usually we only have addr:street but as in BXL we (don't know who :p ) decided to set the street name as it come from the mapper (fr-nl or nl -fr ) it's really hard to discover...<br>
</div><div>if i don't set it we will not have the relation to the street anymore :s<br></div><div>If somebody knows a better solution?<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Since most buildings are houses, I'd use building=house.<br></blockquote><div>mmmh do not really agree on this one ...<br></div><div>for me building = yes is more generic ... if we know it's house then ok let's change it, but let's not put house everywhere and make the value "house" equivalent to "yes" <br>
<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Lots of houses were already drawn in Brussels. Do you plan to integrate/reusing the existing nodes? Or simply replace what was already there, making sure the shops and amenities get transfered properly?<span class="HOEnZb"><font color="#888888"><br>
<br>Jo</font></span><br><span class="HOEnZb"></span><br><div class="HOEnZb"><div class="h5"></div></div></blockquote><div>Again on this one, i think it will be really hard to merge the nodes of existing houses... and to see what's already beneath is not easy either ..<br>
</div><div>Most (all?) of the building in BXL are traced with bing which is really inaccurate (at least all the building i did are like this : etterbeek, ixelles, ..) and i'm in favor of a ***carefull*** !! remove and replace with merging of amenity, ...<br>
<br></div><div>the integration will be slow but ...<br><br><br><br></div><div>what are you thinking? <br></div><div>any one else on this topic?<br></div><div>let's discuss it here before someone start by himself without discussing it here.<br>
<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">
<br><br><div class="gmail_quote">2013/5/11 eMerzh <span dir="ltr"><<a href="mailto:merzhin@gmail.com" target="_blank">merzhin@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"><div><div><div><div><div><div><div><div><div><div>Hi everyone :)<br><br></div>i take some times to look more in the data of urbis, <br></div>i also played with qgis to try to extract some informations...<br>
</div>i started with buildings and addresses as i think it's the weakest point in brussels...<br><br></div>So here is my take on etterbeek (as it's a small one):<br><br></div>I split it in 3 files :<br></div>- buildings without addresses <br>
</div>- building with 1 address (address on the building shape)<br></div>- building with more than 1 address (address as diffrent points)<br><br></div>What do you guys think?<br><br><br></div><div>before uploading there is still some work to do :<br>
</div><div>- check for duplicated node or self intersecting buildings<br></div><div>- check for existing buildings / address in osm<br><br></div>Any comments?<br><br><a href="http://my.bmaron.net/public.php?service=files&t=c73bc235b68982c874d6e29f9223a741" target="_blank">http://my.bmaron.net/public.php?service=files&t=c73bc235b68982c874d6e29f9223a741</a><br>
<br></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, May 3, 2013 at 10:31 AM, eMerzh <span dir="ltr"><<a href="mailto:merzhin@gmail.com" target="_blank">merzhin@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><div><div>Hi ,<br>Thanks for you researches Jo... i'm
currently reading the user guide given upper, and it may helps you to
understand what's what :p<br><br></div></div>yesterday Cquest from osm-fr gave me his extract of addresses so it must be possible some way ... (see here <a href="http://my.bmaron.net/public.php?service=files&t=7264154f5a483352ebe0846fdeeeabbb" target="_blank">http://my.bmaron.net/public.php?service=files&t=7264154f5a483352ebe0846fdeeeabbb</a> )<br>
<br></div><div>For the integration ... as it seems that the datas are far
better than what's already in osm ( a lot of buildings where drawn by
hand on top of bing ....)<br></div></div><div>and addresses are far from complete ...<br>
</div></div><div>my opinion is that we may try to first "integrate" buildings then
address (address seems to be easier i think it's better if we could link
them to the building).<br></div></div><div><div>Another place where an import will be hard but we can still do smth is roads names.<br>
</div><div><br></div>Then of course there is a lot of other things we can start thinking ... like pharmacy , ...<br><br><div class="gmail_extra">Btw, <br></div>
how do we manage the attribution ? a text in the wiki pointing to URBIS?
a source=* on every object ? or a source=* on the changeset?<br></div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, May 3, 2013 at 10:27 AM, eMerzh <span dir="ltr"><<a href="mailto:merzhin@gmail.com" target="_blank">merzhin@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><div>Hi ,<br>Thanks for you researches Jo... i'm currently reading the user guide given upper, and it may helps you to understand what's what :p<br>
<br></div>yesterday Cquest from osm-fr gave me his extract of addresses so it must be possible some way ... (see in attach)<br>
<br></div>For the integration ... as it seems that the datas are far better than what's already in osm ( a lot of buildings where drawn by hand on top of bing ....)<br></div>and addresses are far from complete ...<br>
</div>my opinion is that we may try to first "integrate" buildings then address (address seems to be easier i think it's better if we could link them to the building).<br></div><div>Another place where an import will be hard but we can still do smth is roads names.<br>
</div><div><br></div>Then of course there is a lot of other things we can start thinking ... like pharmacy , ...<br><div><br><div><div><div><div><div><div><div><div class="gmail_extra">Btw, <br></div><div class="gmail_extra">
how do we manage the attribution ? a text in the wiki pointing to URBIS? a source=* on every object ? or a source=* on the changeset?<br><br><br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>
On Fri, May 3, 2013 at 10:07 AM, Jo <span dir="ltr"><<a href="mailto:winfixit@gmail.com" target="_blank">winfixit@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>Hi eMerzh,<br><br>The data is provided in different ways. I started by looking at the topology files, but everything is totally fragmented in there and I can't seem to find the glue to tie it all together once again. One would have to 'reconstruct' the front, sides and backside of the houses and combine with house numbers.<br>
<br>The adm files seem to be more accessible. PostGIS has a plugin which enables to import dbf and shp files. So from the Urbis site we would download the data in SHP format.<br><br>Unzip and then point Postgis to the DBF files. Don't forget to change the character encoding to LATIN1 (or set it to that for the whole DB, but then it needs to be converted to UTF-8 later on).<br>
<br>Once it's all imported, start QGIS and connect to the DB. Now it's possible to visualise the data.<br><br>Urbadm-bu contains the buildings.<br><br>What we should decide is what do we want to use for import/integration?<br>
<br>Many of the buildings in Brussels are already drawn. Are we going to replace them with this data? Does replacing mean: throw away the nodes and start over, or do we try to keep the nodes and "simply" change their positions? (Not so simple to code, but probably not impossible).<br>
<br>What is probably simple is to create an OSM-file with all the housenumbers. Then it's still a lot of manual labour to put them in and verify with what we already had.<br><br>Creating OSM files with all the building outlines would be a bit harder to accomplish. I've been trying to decipher how the data is organised in the tables for the past few hours...<br>
<br>I can't seem to find the link between the buildings and the housenumbers/streets, but maybe I should have a fresh look at it, once the headache goes away... I do think it's in there somewhere.<span><font color="#888888"><br>
<br>Jo<br><br>
<br>
</font></span><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="http://lists.openstreetmap.org/listinfo/talk-be" target="_blank">http://lists.openstreetmap.org/listinfo/talk-be</a><br>
<br></div></blockquote></div><br></div></div></div></div></div></div></div></div></div></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br></div></div>