.. 
   ****************************************************************************
    pgRouting Manual
    Copyright(c) pgRouting Contributors

    This documentation is licensed under a Creative Commons Attribution-Share
    Alike 3.0 License: http://creativecommons.org/licenses/by-sa/3.0/
   ****************************************************************************

.. _pgr_ksp:

pgr_ksp
===============================================================================

Name
-------------------------------------------------------------------------------

``pgr_ksp`` — Returns the "K" shortest paths.


.. figure:: ../../../doc/src/introduction/images/boost-inside.jpeg
   :target: http://www.boost.org/libs/graph

   Boost Graph Inside


Synopsis
-------------------------------------------------------------------------------

The K shortest path routing algorithm based on Yen's algorithm. "K" is the number of shortest paths desired.

Signature Summary
-------------------------------------------------------------------------------

.. code-block:: sql

    pgr_ksp(edges_sql, start_vid, end_vid, K);
    pgr_ksp(edges_sql, start_vid, end_vid, k, directed, heap_paths)
    RETURNS SET OF (seq, path_id, path_seq, node, edge, cost, agg_cost) or EMPTY SET

Signatures
-------------------------------------------------------------------------------

.. index:: 
  single: ksp(Minimal Signature)

Minimal Signature
..................

.. code-block:: sql

    pgr_ksp(edges_sql, start_vid, end_vid, K);
    RETURNS SET OF (seq, path_id, path_seq, node, edge, cost, agg_cost) or EMPTY SET


.. index:: 
  single: ksp(Complete Signature)

Complete Signature
...................

.. code-block:: sql

    pgr_ksp(edges_sql, start_vid, end_vid, k, directed, heap_paths)
    RETURNS SET OF (seq, path_id, path_seq, node, edge, cost, agg_cost) or EMPTY SET


Description of the Signatures
-------------------------------------------------------------------------------

.. include:: ../../common/src/edges_input.h
    :start-after: basic_edges_sql_start
    :end-before: basic_edges_sql_end


============== ============ =================================================                                                                                                                                          
Column         Type           Description                                                                                                                                                                                
============== ============ =================================================
**edges_sql**   ``TEXT``    SQL query as described above.
**start_vid**   ``BIGINT``  Identifier of the starting vertex.
**end_vid**     ``BIGINT``  Identifier of the ending vertex.
**k**           ``INTEGER`` The desiered number of paths.
**directed**    ``BOOLEAN`` (optional). When ``false`` the graph is considered as Undirected. Default is ``true`` which considers the graph as Directed.
**heap_paths**  ``BOOLEAN`` (optional). When ``true`` returns all the paths stored in the process heap. Default is ``false`` which only returns ``k`` pahts. 
============== ============ =================================================

Roughly, if the shortest path has ``N`` edges, the heap will contain about than ``N * k`` paths for small value of ``k`` and ``k > 1``.



Description of the return values
...................................

Returns set of ``(seq, path_seq, path_id, node, edge, cost, agg_cost)``

============== =========== =================================================
Column         Type        Description
============== =========== =================================================
**seq**        ``INTEGER`` Sequential value starting from **1**.
**path_seq**   ``INTEGER`` Relative position in the path of ``node`` and ``edge``. Has value **1** for the beginning of a path.
**path_id**    ``BIGINT``  Path identifier. The ordering of the paths For two paths i, j if i < j then agg_cost(i) <= agg_cost(j).
**node**       ``BIGINT``  Identifier of the node in the path.
**edge**       ``BIGINT``  Identifier of the edge used to go from ``node`` to the next node in the path sequence. ``-1`` for the last node of the route.
**cost**       ``FLOAT``   Cost to traverse from ``node`` using ``edge`` to the next node in the path sequence.
**agg_cost**   ``FLOAT``   Aggregate cost from ``start_vid`` to ``node``.
============== =========== =================================================


.. warning:: During the transition to 3.0, because pgr_ksp version 2.0 doesn't have defined a directed flag nor a heap_path flag, when pgr_ksp is used with only one flag version 2.0 signature will be used.


Additional Examples
------------------------------------------------------------------------------------------

Examples to handle the one flag to choose signatures
.........................................................................................

The examples in this section use the following :ref:`fig1`

.. literalinclude:: doc-ksp.queries
    :start-after: --q1
    :end-before: --q2


Examples for queries marked as ``directed`` with ``cost`` and ``reverse_cost`` columns
.........................................................................................

The examples in this section use the following :ref:`fig1`

.. literalinclude:: doc-ksp.queries
    :start-after: --q2
    :end-before: --q3



Examples for queries marked as ``undirected`` with ``cost`` and ``reverse_cost`` columns
.........................................................................................

The examples in this section use the following :ref:`fig2`

.. literalinclude:: doc-ksp.queries
    :start-after: --q3
    :end-before: --q4


Examples for queries marked as ``directed`` with ``cost`` column
.........................................................................................

The examples in this section use the following :ref:`fig3`


.. literalinclude:: doc-ksp.queries
    :start-after: --q4
    :end-before: --q5


Examples for queries marked as ``undirected`` with ``cost`` column
.........................................................................................

The examples in this section use the following :ref:`fig4`

.. literalinclude:: doc-ksp.queries
    :start-after: --q5
    :end-before: --q6

See Also
-------------------------------------------------------------------------------

* http://en.wikipedia.org/wiki/K_shortest_path_routing
* :ref:`sampledata` network.

.. rubric:: Indices and tables

* :ref:`genindex`
* :ref:`search`
