Hello Emre,<div><br></div><div>I'm not sure exactly about the ID's of Navteq data. It's too long ago that I have used it.</div><div>But it's better to have ID's starting with 1 and to keep them low. This might be the reason why it's slow.</div>
<div><br></div><div>So you could create two new columns and renumber ID's. You don't have to run topology function.</div><div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">2011/1/7 Emre Koc <span dir="ltr"><<a href="mailto:emrekoch@gmail.com">emrekoch@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><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>
<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><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>
</div>