<br><br><div class="gmail_quote">On Wed, Aug 10, 2011 at 6:53 PM, Hamish <span dir="ltr"><<a href="mailto:hamish_b@yahoo.com">hamish_b@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">Daniel wrote:<br>
>>> For pgRouting Qucikstart I have to either download a smaller<br>
>>> bbox of Denver area for pgRouting, or we could make the area<br>
>>> smaller in general, and it will also decrease the size of<br>
>>> pgRouting.<br>
<br>
</div>it seems the pgRt version is about 4x as big as the original<br>
OSM postgis DB. does that copy all OSM ways or just the roads?<br>
apparently topology is not cheap :)<br>
<br>
<br></blockquote><div><br></div><div>Interesting. I never compared it. The import program creates two tables: vertices and ways.</div><div>Vertices are actually not needed anymore after the topology has been calculated. Maybe the indices require more space? They are needed for faster routing results.</div>
<div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im"><br>
</div>? is or is not the possibility to specify a bounding box when<br>
calculating topology and loading it into the database?<br></blockquote><div><br></div><div>The topology script can maybe do this, because it's an SQL function, but the import is done by some program named "osm2pgrouting". It first parses the .osm file and picks the right data and then runs the function. There is no parameter to specify the bbox in osm2pgrouting.</div>
<div><br></div><div>Can maybe some other tool make me an extract of the already downloaded osm file? Osmosis maybe? I don't know so well about them. </div><div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
<div class="im">><br>
> Yes, I already made it smaller for the workshop, using just<br>
> Denver downtown. Because it takes too long on weak notebooks<br>
> to run the topology function.<br>
<br>
</div>bbox?<br></blockquote><div><br></div><div>Yes, the workshop uses some really small area only. I need two SQL dumps for those, who get lost and need to start over with some working database eventually. They don't require much space, when they are packed. 2 or 3 MB, I think. </div>
<div>But this is all included in the workshop package, which is not only made for the LiveDVD.</div><div><br></div><div>Daniel</div></div><br clear="all"><br>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>