<br><br><div class="gmail_quote">On Mon, Sep 12, 2011 at 11:20 AM, Ali Taha <span dir="ltr"><<a href="mailto:ali.taha@ritaj.ps">ali.taha@ritaj.ps</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal">Dear All,<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I am trying to setup and test pgrouting, I followed the setups but it is still not working. If ollowed the following steps:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p><u></u><span>1-<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Copay pgrouting libraries to ..\pgsql\8.4\lib</p></div></div>
</blockquote><div><br></div><div>From where did you copy them?</div><div>Did you compile? Which OS?</div><div><br></div><div>Daniel</div><div><br></div><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple"><div><p><u></u><u></u></p><p><u></u><span>2-<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Execute routing_core.sql and routing_core_wrappers.sql<u></u><u></u></p>
<p><u></u><span>3-<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Create a newtwork:<u></u><u></u></p><p style="margin-left:1.0in"><u></u><span>a.<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Added source and target fields<u></u><u></u></p>
<p style="margin-left:1.0in"><u></u><span>b.<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Execute Execute <span style="color:#333333;background:white">assign_vertex_</span>id('<table>', float tolerance, '<geometry column', '<gid>')<u></u><u></u></p>
<p style="margin-left:1.0in"><u></u><span>c.<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Added indices <u></u><u></u></p><p style="margin-left:1.0in"><u></u><span>d.<span style="font:7.0pt "Times New Roman""> </span></span><u></u><span dir="LTR"></span>Added reverse_cost column.<u></u><u></u></p>
<p class="MsoNormal">Then I used the following query to retrieve records:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">SELECT * FROM shortest_path(‘<u></u><u></u></p><p class="MsoNormal">
SELECT gid as id,<u></u><u></u></p>
<p class="MsoNormal">source::integer,<u></u><u></u></p><p class="MsoNormal">target::integer,<u></u><u></u></p><p class="MsoNormal">length::double precision as cost<u></u><u></u></p><p class="MsoNormal">FROM ways’,<u></u><u></u></p>
<p class="MsoNormal">24154,<u></u><u></u></p><p class="MsoNormal">24157,<u></u><u></u></p><p class="MsoNormal">false, false)<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">the query executes without errors, but return no data. I checked the table and the records seems OK. <u></u><u></u></p>
<p class="MsoNormal">is there a way to validate the database and verify the topology? How to make sure that the pgrouting library (dlls) are installed and working correctly?<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p></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"><div><br></div>-- <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>