<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Quick note.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>There were some issues in pgRouting 2.2.0 released which this may be one of them. I pushed up pgRouting 2.2.2 in stackbuilder last week for PostgreSQL 9.5 x windows 64-bit<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If you reinstall PostGIS bundle from stackbuilder and then do a <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>ALTER EXTENSION pgRouting UPDATE;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>You should get the new version.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>For others on windows, sorry haven't had a chance to repackage. I do have binaries you can get from here - <a href="http://postgis.net/windows_downloads/">http://postgis.net/windows_downloads/</a> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>In the unreleased section – look for in respective pg version folder<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><a href="http://winnie.postgis.net/download/windows/pg95/buildbot/pgrouting-pg95-binaries-2.2.2w64gcc48.zip">pgrouting-pg95-binaries-2.2.2w64gcc48.zip</a><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Where the 95, w64 will change depending on which version of PostgreSQL you are running.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>These will be the same versions I'll be pushing up.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Pgrouting-users [mailto:pgrouting-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>HuanChun Ye<br><b>Sent:</b> Friday, May 13, 2016 11:57 PM<br><b>To:</b> pgrouting-users@lists.osgeo.org<br><b>Subject:</b> [pgrouting-users] Problem with topology using sample data in the manual<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p><div><p class=MsoNormal style='margin-left:.5in'>I am working through the examples in the manual (v2.2) using the sample data, but encountered a problem with topology, as described below. I apologize for the verbosity, but I want to show the exact steps leading to the problem, starting with just after importing the sample data:<o:p></o:p></p><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select * from edge_table;</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> id | dir | source | target | cost | reverse_cost | x1 | y1 | x2 | y2 | the_geom</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>----+-----+--------+--------+------+--------------+-----+-----+----------------+-----+-----------------------------------------------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>-</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 1 | B | | | 1 | 1 | 2 | 0 | 2 | 1 | 010200000002000000000000000000004000000000000000000000000000000040000000000000F03F</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 2 | TF | | | -1 | 1 | 2 | 1 | 3 | 1 | 0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 3 | TF | | | -1 | 1 | 3 | 1 | 4 | 1 | 0102000000020000000000000000000840000000000000F03F0000000000001040000000000000F03F</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 4 | B | | | 1 | 1 | 2 | 1 | 2 | 2 | 0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 5 | FT | | | 1 | -1 | 3 | 1 | 3 | 2 | 0102000000020000000000000000000840000000000000F03F00000000000008400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 6 | B | | | 1 | 1 | 0 | 2 | 1 | 2 | 01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 7 | B | | | 1 | 1 | 1 | 2 | 2 | 2 | 010200000002000000000000000000F03F000000000000004000000000000000400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 8 | B | | | 1 | 1 | 2 | 2 | 3 | 2 | 0102000000020000000000000000000040000000000000004000000000000008400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 9 | B | | | 1 | 1 | 3 | 2 | 4 | 2 | 0102000000020000000000000000000840000000000000004000000000000010400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 10 | B | | | 1 | 1 | 2 | 2 | 2 | 3 | 0102000000020000000000000000000040000000000000004000000000000000400000000000000840</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 11 | FT | | | 1 | -1 | 3 | 2 | 3 | 3 | 0102000000020000000000000000000840000000000000004000000000000008400000000000000840</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 12 | FT | | | 1 | -1 | 2 | 3 | 3 | 3 | 0102000000020000000000000000000040000000000000084000000000000008400000000000000840</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 13 | FT | | | 1 | -1 | 3 | 3 | 4 | 3 | 0102000000020000000000000000000840000000000000084000000000000010400000000000000840</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 14 | B | | | 1 | 1 | 2 | 3 | 2 | 4 | 0102000000020000000000000000000040000000000000084000000000000000400000000000001040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 15 | B | | | 1 | 1 | 4 | 2 | 4 | 3 | 0102000000020000000000000000001040000000000000004000000000000010400000000000000840</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 16 | B | | | 1 | 1 | 4 | 1 | 4 | 2 | 0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 17 | B | | | 1 | 1 | 0.5 | 3.5 | 1.999999999999 | 3.5 | 010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 18 | B | | | 1 | 1 | 3.5 | 2.3 | 3.5 | 4 | 0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(18 rows)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select pgr_createTopology('edge_table', 0.001);</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: PROCESSING:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: pgr_createTopology('edge_table', 0.001, 'the_geom', 'id', 'source', 'target', rows_where := 'true', clean := f)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Performing checks, please wait .....</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Creating Topology, Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: -------------> TOPOLOGY CREATED FOR 18 edges</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Rows with NULL geometry or NULL id: 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Vertices table for table public.edge_table is: public.edge_table_vertices_pgr</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: ----------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> pgr_createtopology</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>--------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> OK</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select pgr_analyzeGraph('edge_table', 0.001);</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: PROCESSING:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: pgr_analyzeGraph('edge_table',0.001,'the_geom','id','source','target','true')</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Performing checks, please wait ...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for dead ends. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for gaps. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for isolated edges. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for ring geometries. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for intersections. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Isolated segments: 2</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Dead ends: 7</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Potential gaps found near dead ends: 1</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Intersections detected: 1</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Ring geometries: 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> pgr_analyzegraph</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> OK</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select pgr_nodeNetwork('edge_table', 0.001);</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: PROCESSING:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: pgr_nodeNetwork('edge_table', 0.001, 'id', 'the_geom', 'noded', '<NULL>', f)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Performing checks, please wait .....</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Processing, please wait .....</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Splitted Edges: 2</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Untouched Edges: 16</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Total original Edges: 18</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Edges generated: 4</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Untouched Edges: 16</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Total New segments: 20</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: New Table: public.edge_table_noded</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: ----------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> pgr_nodenetwork</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>-----------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> OK</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select pgr_createTopology('edge_table_noded', 0.001);</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: PROCESSING:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: pgr_createTopology('edge_table_noded', 0.001, 'the_geom', 'id', 'source', 'target', rows_where := 'true', clean := f)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Performing checks, please wait .....</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Creating Topology, Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: -------------> TOPOLOGY CREATED FOR 20 edges</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Rows with NULL geometry or NULL id: 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Vertices table for table public.edge_table_noded is: public.edge_table_noded_vertices_pgr</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: ----------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> pgr_createtopology</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>--------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> OK</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select pgr_analyzeGraph('edge_table_noded', 0.001);</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: PROCESSING:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: pgr_analyzeGraph('edge_table_noded',0.001,'the_geom','id','source','target','true')</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Performing checks, please wait ...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for dead ends. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for gaps. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for isolated edges. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for ring geometries. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Analyzing for intersections. Please wait...</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: ANALYSIS RESULTS FOR SELECTED EDGES:</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Isolated segments: 1</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Dead ends: 7</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Potential gaps found near dead ends: 1</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Intersections detected: 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>NOTICE: Ring geometries: 0</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> pgr_analyzegraph</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> OK</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# SELECT a.*</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample-# FROM edge_table_noded a, edge_table_noded_vertices_pgr b, edge_table_noded_vertices_pgr c</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample-# WHERE a.source=<a href="http://b.id">b.id</a> AND b.cnt=1 AND a.target=<a href="http://c.id">c.id</a> AND c.cnt=1;</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> id | old_id | sub_id | source | target | the_geom</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>----+--------+--------+--------+--------+------------------------------------------------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> 20 | 17 | 1 | 17 | 18 | 010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>So the original node id 17, which is a nearly touching T-intersection, remains isolated. This is in contrast to the output shown in the manual, which shows the following:<o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><div style='mso-element:para-border-div;border:dotted #0C3762 1.0pt;padding:10.0pt 10.0pt 10.0pt 10.0pt;background:#F0F0F0;margin-left:.5in;margin-right:0in'><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><b><span style='color:#007020'>SELECT</span></b><span style='color:#333333'> pgr_analyzegraph(</span><span style='color:#4070A0'>'edge_table_noded'</span><span style='color:#333333'>, </span><span style='color:#208050'>0</span><span style='color:#333333'>.</span><span style='color:#208050'>001</span><span style='color:#333333'>);<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: PROCESSING:<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: pgr_analyzeGraph(</span><span style='color:#4070A0'>'edge_table_noded'</span><span style='color:#333333'>,</span><span style='color:#208050'>0</span><span style='color:#333333'>.</span><span style='color:#208050'>001</span><span style='color:#333333'>,</span><span style='color:#4070A0'>'the_geom'</span><span style='color:#333333'>,</span><span style='color:#4070A0'>'id'</span><span style='color:#333333'>,</span><span style='color:#4070A0'>'source'</span><span style='color:#333333'>,</span><span style='color:#4070A0'>'target'</span><span style='color:#333333'>,</span><span style='color:#4070A0'>'true'</span><span style='color:#333333'>)<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Performing checks, pelase wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Analyzing </span><b><span style='color:#007020'>for</span></b><span style='color:#333333'> dead ends. Please wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Analyzing </span><b><span style='color:#007020'>for</span></b><span style='color:#333333'> gaps. Please wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Analyzing </span><b><span style='color:#007020'>for</span></b><span style='color:#333333'> isolated edges. Please wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Analyzing </span><b><span style='color:#007020'>for</span></b><span style='color:#333333'> ring geometries. Please wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Analyzing </span><b><span style='color:#007020'>for</span></b><span style='color:#333333'> intersections. Please wait...<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: ANALYSIS RESULTS </span><b><span style='color:#007020'>FOR</span></b><span style='color:#333333'> SELECTED EDGES:<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Isolated segments: </span><span style='color:#208050'>0</span><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Dead ends: </span><span style='color:#208050'>6</span><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Potential gaps </span><b><span style='color:#007020'>found</span></b><span style='color:#333333'> near dead ends: </span><span style='color:#208050'>0</span><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Intersections detected: </span><span style='color:#208050'>0</span><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>NOTICE: Ring geometries: </span><span style='color:#208050'>0</span><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>pgr_createtopology<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><i><span style='color:#408090'>--------------------</span></i><span style='color:#333333'><o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'> OK<o:p></o:p></span></pre><pre style='margin-bottom:9.0pt;background:#F0F0F0;border:none;padding:0in'><span style='color:#333333'>(</span><span style='color:#208050'>1</span><span style='color:#333333'> </span><b><span style='color:#007020'>row</span></b><span style='color:#333333'>)<o:p></o:p></span></pre></div></div><div><p class=MsoNormal style='margin-left:.5in'>I tried the following but none helped:<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>- increasing the value of tolerance up to 0.5<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>- setting the SRID of the geometry column<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>- converting data to .osm file and run osm2pgrouting<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'>I am using the following versions on Windows 10 64-bit PC:<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>pgr_sample=# select version(), postgis_full_version(), pgr_version();</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> version | postgis_full_version</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> | pgr_version</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>-------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>--------------------------------------------------------+-----------------------------------------------</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'> PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit | POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.9.1, 04 March 2015" GDAL="GDAL 2.0.2, re</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>leased 2016/01/26" LIBXML="2.7.8" LIBJSON="0.12" RASTER | (2.2.0,pgrouting-2.2.0,afc622e,master,1.59.0)</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-size:7.5pt;font-family:"Courier New"'>(1 row)</span><o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><span style='font-family:"Arial",sans-serif'>Thanks in advance for your help!</span><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p></div></div></div></body></html>