[pgrouting-users] routing_core_smart problem

[Daniel Kastl]

Hi Lutz,

Thank you very much for sharing this information!
I have also created this ticket:
https://github.com/pgRouting/pgrouting-contrib/issues/3

So you're talking about the following two lines?

   - Line 191
   https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L191
   - Line 205
   https://github.com/pgRouting/pgrouting-contrib/blob/master/wrapper/routing_core_smart.sql#L205

Best regards,
Daniel


On Sat, Dec 3, 2011 at 4:26 AM, Worth Lutz <wal3 at mindspring.com> wrote:

>  Hi all,****
>
> ** **
>
> I have found what appears to be a problem in one of the routing_core_smart
> functions.****
>
> ** **
>
> In the function locate_point_as_geometry there are two lines which call
> the function geometryfromtext.****
>
> ** **
>
> These functions are called when line_substring returns a point.****
>
> ** **
>
> In the geometryfromtext function calls, there is no second argument for
> the srid.  This produces a geometry with a “-1” for the srid.****
>
> ** **
>
> When I use shootingstar_smart in my script, MapServer fails on trying to
> work with two geometries with different srids.****
>
> ** **
>
> 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.****
>
> ** **
>
> ** **
>
> ** **
>
> I hope this helps someone.****
>
> ** **
>
> Worth Lutz****
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20111203/c5534e2a/attachment.html