.. 
   ****************************************************************************
    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_withPointsDD:

pgr_withPointsDD - Proposed
===============================================================================


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

``pgr_withPointsDD`` - Returns the driving distance from a starting point.


.. include:: ../../proposedNext.rst
   :start-after: begin-warning
   :end-before: end-warning


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

   Boost Graph Inside

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

Modify the graph to include points and 
using Dijkstra algorithm, extracts all the nodes and points that have costs less
than or equal to the value ``distance`` from the starting point.
The edges extracted will conform the corresponding spanning tree.


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

.. code-block:: none

    pgr_withPointsDD(edges_sql, points_sql, start_vid, distance)
    pgr_withPointsDD(edges_sql, points_sql, start_vid, distance, directed, driving_side, details)
    pgr_withPointsDD(edges_sql, points_sql, start_vids, distance, directed, driving_side, details, equicost)
    RETURNS SET OF (seq, node, edge, cost, agg_cost)

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

.. index::
    single: withPointsDD(Minimal Use) - proposed

Minimal Use
..................................

The minimal signature:
    - Is for a **directed** graph.
    - The driving side is set as **b** both. So arriving/departing to/from the point(s) can be in any direction.
    - No **details** are given about distance of other points of the query.

.. code-block:: none

    pgr_withPointsDD(edges_sql, points_sql, start_vid, distance)
        directed:=true, driving_side:='b', details:=false)
    RETURNS SET OF (seq, node, edge, cost, agg_cost)


:Example:

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

.. index::
    single: withPointsDD(Single Start Vertex) - proposed

Driving distance from a single point
..............................................

Finds the driving distance depending on the optional parameters setup.

.. code-block:: none

    pgr_withPointsDD(edges_sql, points_sql, start_vids, distance,
        directed:=true, driving_side:='b', details:=false)
    RETURNS SET OF (seq, node, edge, cost, agg_cost)

:Example: Right side driving topology

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

.. index::
    single: withPointsDD(Multiple Starting Vertices) - proposed

Driving distance from many starting points
..................................................

Finds the driving distance depending on the optional parameters setup.

.. code-block:: none

    pgr_withPointsDD(edges_sql, points_sql, start_vids, distance,
        directed:=true, driving_side:='b', details:=false, equicost:=false)
    RETURNS SET OF (seq, node, edge, cost, agg_cost)




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

..
    description of the sql queries


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

.. include:: ../../common/src/points_input.h
    :start-after: points_sql_start
    :end-before: points_sql_end


Description of the parameters of the signatures
........................................................


================ ================= =================================================
Parameter        Type              Description
================ ================= =================================================
**edges_sql**    ``TEXT``          Edges SQL query as described above.
**points_sql**   ``TEXT``          Points SQL query as described above.
**start_vid**    ``ANY-INTEGER``   Starting point id
**distance**     ``ANY-NUMERICAL`` Distance from the start_pid
**directed**     ``BOOLEAN``       (optional). When ``false`` the graph is considered as Undirected. Default is ``true`` which considers the graph as Directed.
**driving_side** ``CHAR``          (optional). Value in ['b', 'r', 'l', NULL] indicating if the driving side is:
                                     - In the right or left or
                                     - If it doesn't matter with 'b' or NULL.
                                     - If column not present 'b' is considered.

**details**      ``BOOLEAN``       (optional). When ``true`` the results will include the driving distance to the points with in the ``distance``.
                                   Default is ``false`` which ignores other points of the points_sql.
**equicost**     ``BOOLEAN``       (optional). When ``true`` the nodes will only appear in the closest start_v list. Default is ``false`` which resembles several calls using the single starting point signatures. Tie brakes are arbitrary.                                   
================ ================= =================================================


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

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

============ =========== =================================================
Column           Type              Description
============ =========== =================================================
**seq**      ``INT``     row sequence.
**node**     ``BIGINT``  Identifier of the node within the Distance from ``start_pid``. If ``details =: true`` a negative value is the identifier of a point.
**edge**     ``BIGINT``  Identifier of the edge used to go from ``node`` to the next node in the path sequence.
                           - ``-1`` when ``start_vid`` = ``node``.

**cost**     ``FLOAT``   Cost to traverse ``edge``.
                           - ``0`` when ``start_vid`` = ``node``.

**agg_cost** ``FLOAT``   Aggregate cost from ``start_vid`` to ``node``.
                           - ``0`` when ``start_vid`` = ``node``.

============ =========== =================================================



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

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

:Example: Left side driving topology

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

:Example: Does not matter driving side.

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




The queries use the :ref:`sampledata` network.



.. rubric:: History

* Proposed in version 2.2


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

* :ref:`pgr_drivingDistance` - Driving distance using dijkstra.
* :ref:`pgr_alphashape` - Alpha shape computation.
* :ref:`pgr_points_as_polygon` - Polygon around set of points.

.. rubric:: Indices and tables

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

