Hi eMerzh,<br><br>I'm sorry, you ended up on the todo / procrastrination pile.<br><br>I took another go at trying to import the data into PostGIS, to be able to visualise it in QGIS.<br><br>I noticed there are several hurdles:<br>
<br>LATIN1 encoded instead of UTF-8<br>Lambert72 instead of WGS-84<br><br>And now I noticed the dbf files contain commas as decimal separator...<br><br>Anyway the building shapes are in urbadm_bu, which has an id column.<br>
<br>There is a DBF file UrbAdm_AdPt with all the address information. Hopefully bu_id in that one is a foreign key to that id column.<br><br><br><br>I looked at your files and you have the building shapes converted already... great! I'd like to learn how you did it.<br>
<br><br>I would have added associatedStreet relations to the osm files as well. Combine addr:street:fr and addr:street:nl in addr:street or omit it/them altogether.<br>Since most buildings are houses, I'd use building=house.<br>
<br>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?<br><br>Jo<br><br>
<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 class="HOEnZb"><div class="h5"><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>