Hi Charles, Hi list<br><br>Your experience with Navteq data is very interesting.<br>Have a nice vacation and give us some more details when you come back!!<br><br><div class="gmail_quote">2011/1/7 Charles Galpin <span dir="ltr"><<a href="mailto:cgalpin@lhsw.com">cgalpin@lhsw.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div style="word-wrap: break-word;">Hi Emre<div><br></div><div>I am using navteq data and would be happy to help, but I am about to take a week long vacation tomorrow morning so hopefully you are not in a rush.</div>
<div><br></div><div>The short answer is</div><div><br></div><div>- assign_vertex does a good job of generating the source/target nodes using 0.00001 for me</div><div>- for speed, I found I needed to limit the amount of data presented to the routing engine. One was is to reduce the data set (ie remove/limit the func_class 4 roads you don't need). The other is I create a rectangle around the start and the end point and some percentage of the distance between the points as the width and limit the data to that. The narrower the rectangle the less data the routing engine uses, but if you have large arching roads you have to increase this (I use about 70%). Either way it helps speed up the routing for me.</div>
<div>- For z levels search the archives but both Steven Woodbridge and I posted our versions of a 3d assign_vertex. </div><div><br></div><div>I'd be happy to answer any specific questions, and look forward to seeing your progress.</div>
<div><br></div><font color="#888888"><div>charles</div></font><div><div></div><div class="h5"><div><br><div><div>On Jan 7, 2011, at 4:31 AM, Emre Koc wrote:</div><br><blockquote type="cite"><font size="2"><font face="tahoma,sans-serif">Hello,</font></font><div>
<font size="2"><font face="tahoma,sans-serif"><br></font></font></div><div><font face="tahoma, sans-serif">I am new to pgRouting and trying to figure out how to use it with navteq data. I used pgRouting with osm data and it worked perfect but for navteq data i tried to use ref_in_id and nref_in_id but it turned out that pgRouting found the path very slow when I used these for source and target. How can I calculate a correct topology for pgRouting by taking z levels into consideration ? Shall define geometry as 3D with z levels embedded or is it possible to use 2d multilinestring with additional z level column ?</font></div>
<div><font face="tahoma, sans-serif"><br></font></div><div><font face="tahoma, sans-serif">Since I am new to pgRouting these questions are very hard for me to solve, but after I figure out how to use pgRouting I would be more than happy to contribute to project. </font></div>
<div><font face="tahoma, sans-serif"><br></font></div><div><font face="tahoma, sans-serif">Thanks in advance,</font></div><div><font size="2"><font face="tahoma,sans-serif"><br clear="all">
</font></font>Emre<br>
</div></blockquote></div><br></div></div></div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Lorenzo Amato<br><a href="mailto:lorenzo.amato@geosdi.org">lorenzo.amato@geosdi.org</a><br><a href="mailto:lorenzotlc@gmail.com">lorenzotlc@gmail.com</a><br><a href="mailto:lorenzo.amato@nsdi.it">lorenzo.amato@nsdi.it</a><br>
<br>Consiglio Nazionale delle Ricerche<br>Istituto di Metodologie per l'Analisi Ambientale - geoSDI<br>