<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 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 class="im"><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 class="im">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 class="im">and addresses are far from complete ...<br>
</div></div><div class="im">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 class="im"><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 class="HOEnZb"><div class="h5"><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>