/usr/share/doc/postgresql-9.5-pgrouting-doc/html/en/doc/src/developer/sampledata.html is in postgresql-9.5-pgrouting-doc 2.1.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Sample Data — pgRouting Manual (2.1.0)</title>
<link rel="stylesheet" href="../../../_static/haiku.css" type="text/css" />
<link rel="stylesheet" href="../../../_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '../../../',
VERSION: '2.1.0 (b38118a master)',
COLLAPSE_INDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="../../../_static/jquery.js"></script>
<script type="text/javascript" src="../../../_static/underscore.js"></script>
<script type="text/javascript" src="../../../_static/doctools.js"></script>
<script type="text/javascript" src="../../../_static/mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<link rel="shortcut icon" href="../../../_static/favicon.ico"/>
<link rel="top" title="pgRouting Manual (2.1.0)" href="../../index.html" />
<link rel="next" title="User’s Recipes List" href="../recipes/index.html" />
<link rel="prev" title="Performance Tips" href="../tutorial/performance.html" />
</head>
<body role="document">
<div class="header" role="banner"><img class="rightlogo" src="../../../_static/pgrouting.png" alt="Logo"/><h1 class="heading"><a href="../../../index.html">
<span>pgRouting Manual (2.1.0)</span></a></h1>
<h2 class="heading"><span>Sample Data</span></h2>
</div>
<div class="topnav" role="navigation" aria-label="top navigation">
<p>
«  <a href="../tutorial/performance.html">Performance Tips</a>
  ::  
<a class="uplink" href="../../index.html">Contents</a>
  ::  
<a href="../recipes/index.html">User’s Recipes List</a>  »
</p>
</div>
<div class="content">
<div class="section" id="sample-data">
<span id="sampledata"></span><h1>Sample Data<a class="headerlink" href="#sample-data" title="Permalink to this headline">¶</a></h1>
<p>The documentation provides very simple example queries based on a small sample network.
To be able to execute the sample queries, run the following SQL commands to create a table with a small network data set.</p>
<p class="rubric">Create table</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">edge_table</span> <span class="p">(</span>
<span class="n">id</span> <span class="nb">serial</span><span class="p">,</span>
<span class="n">dir</span> <span class="nb">character</span> <span class="nb">varying</span><span class="p">,</span>
<span class="k">source</span> <span class="nb">integer</span><span class="p">,</span>
<span class="n">target</span> <span class="nb">integer</span><span class="p">,</span>
<span class="n">cost</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">reverse_cost</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">x1</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">y1</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">x2</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">y2</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">the_geom</span> <span class="n">geometry</span>
<span class="p">);</span>
</pre></div>
</div>
<p class="rubric">Insert network data</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">0</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">1</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span><span class="o">-</span><span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span> <span class="mi">2</span><span class="p">,</span><span class="mi">4</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span class="p">,</span><span class="mi">2</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span> <span class="mi">1</span><span class="p">.</span><span class="mi">999999999999</span><span class="p">,</span><span class="mi">3</span><span class="p">.</span><span class="mi">5</span><span class="p">);</span>
<span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">edge_table</span> <span class="p">(</span><span class="n">cost</span><span class="p">,</span><span class="n">reverse_cost</span><span class="p">,</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">,</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="mi">3</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">3</span><span class="p">,</span> <span class="mi">3</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="mi">4</span><span class="p">);</span>
<span class="k">UPDATE</span> <span class="n">edge_table</span> <span class="k">SET</span> <span class="n">the_geom</span> <span class="o">=</span> <span class="n">st_makeline</span><span class="p">(</span><span class="n">st_point</span><span class="p">(</span><span class="n">x1</span><span class="p">,</span><span class="n">y1</span><span class="p">),</span><span class="n">st_point</span><span class="p">(</span><span class="n">x2</span><span class="p">,</span><span class="n">y2</span><span class="p">)),</span>
<span class="n">dir</span> <span class="o">=</span> <span class="k">CASE</span> <span class="k">WHEN</span> <span class="p">(</span><span class="n">cost</span><span class="o">></span><span class="mi">0</span> <span class="k">and</span> <span class="n">reverse_cost</span><span class="o">></span><span class="mi">0</span><span class="p">)</span> <span class="k">THEN</span> <span class="s1">'B'</span> <span class="c1">-- both ways</span>
<span class="k">WHEN</span> <span class="p">(</span><span class="n">cost</span><span class="o">></span><span class="mi">0</span> <span class="k">and</span> <span class="n">reverse_cost</span><span class="o"><</span><span class="mi">0</span><span class="p">)</span> <span class="k">THEN</span> <span class="s1">'FT'</span> <span class="c1">-- direction of the LINESSTRING</span>
<span class="k">WHEN</span> <span class="p">(</span><span class="n">cost</span><span class="o"><</span><span class="mi">0</span> <span class="k">and</span> <span class="n">reverse_cost</span><span class="o">></span><span class="mi">0</span><span class="p">)</span> <span class="k">THEN</span> <span class="s1">'TF'</span> <span class="c1">-- reverse direction of the LINESTRING</span>
<span class="k">ELSE</span> <span class="s1">''</span> <span class="k">END</span><span class="p">;</span> <span class="c1">-- unknown</span>
</pre></div>
</div>
<p>Before you test a routing function use this query to fill the source and target columns.</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">SELECT</span> <span class="n">pgr_createTopology</span><span class="p">(</span><span class="s1">'edge_table'</span><span class="p">,</span><span class="mi">0</span><span class="p">.</span><span class="mi">001</span><span class="p">);</span>
</pre></div>
</div>
<p>This table is used in some of our examples</p>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">vertex_table</span> <span class="p">(</span>
<span class="n">id</span> <span class="nb">serial</span><span class="p">,</span>
<span class="n">x</span> <span class="n">double</span> <span class="k">precision</span><span class="p">,</span>
<span class="n">y</span> <span class="n">double</span> <span class="k">precision</span>
<span class="p">);</span>
</pre></div>
</div>
<div class="highlight-sql"><div class="highlight"><pre><span class="k">INSERT</span> <span class="k">INTO</span> <span class="n">vertex_table</span> <span class="k">VALUES</span>
<span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">0</span><span class="p">),</span> <span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">4</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">1</span><span class="p">),</span> <span class="p">(</span><span class="mi">5</span><span class="p">,</span><span class="mi">0</span><span class="p">,</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">6</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">7</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">),</span>
<span class="p">(</span><span class="mi">8</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">9</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">2</span><span class="p">),</span> <span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">11</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">12</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">3</span><span class="p">),</span> <span class="p">(</span><span class="mi">13</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">4</span><span class="p">);</span>
</pre></div>
</div>
<p class="rubric">Network for queries marked as <code class="docutils literal"><span class="pre">directed</span></code> and <code class="docutils literal"><span class="pre">cost</span></code> and <code class="docutils literal"><span class="pre">reverse_cost</span></code> columns are used:</p>
<div class="figure" id="id1">
<span id="fig1"></span><img alt="../../../_images/Fig1-originalData.png" src="../../../_images/Fig1-originalData.png" />
<p class="caption"><span class="caption-text"><em>Graph 1: Directed, with cost and reverse cost</em></span></p>
</div>
<p>Blue colored lines with line arrows, represent the <code class="docutils literal"><span class="pre">cost</span></code> of the edge table.
Green colored lines with filled arrows, represent the <code class="docutils literal"><span class="pre">reverse_cost</span></code> of the edge table.</p>
<p class="rubric">Network for queries marked as <code class="docutils literal"><span class="pre">undirected</span></code> and <code class="docutils literal"><span class="pre">cost</span></code> and <code class="docutils literal"><span class="pre">reverse_cost</span></code> columns are used:</p>
<div class="figure" id="id2">
<span id="fig2"></span><img alt="../../../_images/Fig6-undirected.png" src="../../../_images/Fig6-undirected.png" />
<p class="caption"><span class="caption-text"><em>Graph 2: Undirected, with cost and reverse cost</em></span></p>
</div>
<p class="rubric">Network for queries marked as <code class="docutils literal"><span class="pre">directed</span></code> and only <code class="docutils literal"><span class="pre">cost</span></code> column is used:</p>
<div class="figure" id="id3">
<span id="fig3"></span><img alt="../../../_images/Fig2-cost.png" src="../../../_images/Fig2-cost.png" />
<p class="caption"><span class="caption-text"><em>Graph 3: Directed, with cost</em></span></p>
</div>
<p class="rubric">Network for queries marked as <code class="docutils literal"><span class="pre">undirected</span></code> and only <code class="docutils literal"><span class="pre">cost</span></code> column is used:</p>
<div class="figure" id="id4">
<span id="fig4"></span><img alt="../../../_images/Fig4-costUndirected.png" src="../../../_images/Fig4-costUndirected.png" />
<p class="caption"><span class="caption-text"><em>Graph 4: Undirected, with cost</em></span></p>
</div>
</div>
</div>
<div class="bottomnav" role="navigation" aria-label="bottom navigation">
<p>
«  <a href="../tutorial/performance.html">Performance Tips</a>
  ::  
<a class="uplink" href="../../index.html">Contents</a>
  ::  
<a href="../recipes/index.html">User’s Recipes List</a>  »
</p>
</div>
<div class="footer" role="contentinfo">
© Copyright pgRouting Contributors - Version 2.1.0 (b38118a master).
Last updated on Feb 05, 2016.
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.3.5.
</div>
</body>
</html>
|