Hi Lutz,<div><br></div><div>Thank you very much for sharing this information!</div><div>I have also created this ticket: <a href="https://github.com/pgRouting/pgrouting-contrib/issues/3">https://github.com/pgRouting/pgrouting-contrib/issues/3</a></div>
<div><br></div><div>So you're talking about the following two lines?</div><div><ul><li>Line 191 <a href="https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L191">https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L191</a></li>
<li>Line 205 <a href="https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L205">https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L205</a></li>
</ul><div>Best regards,</div></div><div>Daniel</div><div><br><br><div class="gmail_quote">On Sat, Dec 3, 2011 at 4:26 AM, Worth Lutz <span dir="ltr"><<a href="mailto:wal3@mindspring.com">wal3@mindspring.com</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"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">Hi all,<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">I have found what appears to be a problem in one of the routing_core_smart
functions.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">In the function locate_point_as_geometry there are two lines
which call the function geometryfromtext.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">These functions are called when line_substring returns a
point.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">In the geometryfromtext function calls, there is no second
argument for the srid. This produces a geometry with a “-1”
for the srid.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">When I use shootingstar_smart in my script, MapServer fails
on trying to work with two geometries with different srids.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">Adding the second argument to the geometryfromtext function
fixed this problem. The only geometry with the “-1” srid was
the one created by these function calls.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">I hope this helps someone.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></font></p><span class="HOEnZb"><font color="#888888">
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Arial"><span style="font-size:12.0pt;font-family:Arial">Worth Lutz<u></u><u></u></span></font></p>
</font></span></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>
</div>