[pgrouting-users] routing_core_smart problem

[Daniel Kastl]

On Mon, Dec 5, 2011 at 12:28 AM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> Hi Daniel,
>
> Who wrote the routing_core_smart.sql functions?
>

Anton


> Is there any documentation of them? It would be nice if we had:
>

Right ... would be nice to have ;-)
I actually just decided to publish the wrapper, because there were several
questions in the past how the pgRouting demo could start the route from/to
the point you clicked.


> 1. description of the major public entry points and what the arguments
> should be.
>

It even needs an extra table "network_statistics" to work.
But on the other hand it was supposed to be an example of writing a more
complex wrapper function. It's not really a generic function and may not
work with any type of data.
There are probably several possibilities to improve the functions.

Daniel



> 2. comments in the code that explain what the overview strategy is and/or
> a high level pseudocode of how it executes
>
> Thanks,
>  -Steve
>
>
> On 12/2/2011 9:57 PM, Daniel Kastl wrote:
>
>> Hi Lutz,
>>
>> Thank you very much for sharing this information!
>> I have also created this ticket:
>> https://github.com/pgRouting/**pgrouting-contrib/issues/3<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<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<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
>> <mailto: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 <Pgrouting-users at lists.osgeo.org><mailto:
>> Pgrouting-users at lists.**osgeo.org <Pgrouting-users at lists.osgeo.org>>
>>
>>    http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>
>>
>>
>>
>> --
>> Georepublic UG & Georepublic Japan
>> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl@**georepublic.de<daniel.kastl at georepublic.de>
>> >
>> Web: http://georepublic.de <http://georepublic.de/>
>>
>>
>>
>> ______________________________**_________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
>> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>>
>
> ______________________________**_________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.**org <Pgrouting-users at lists.osgeo.org>
> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<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/20111205/b5f701df/attachment-0001.html