<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Right now its not possible, but when I used it (long time ago) I did something like the following:<br>First of all I after doing an analysis to the the graph, I grabbed the edges that where in conflict and placed them in a different table. That was less than 1% of the total edges. That new table is the one I applied pgr_nodeNetwork, after the nodding was done I carefully reinserted the results (following the example in the documentation and adjusting the idea to my needs) into the original table and re-created the topology.<br>But as for the moment, pgr_createTopology, for the particular section, will erase ALL topology and only create the topology of that section, So pgr_creteTopology has to be called with the whole table, work is in progress so that create topology in a section will keep any topology already in the table. <br><br>I added as a request feature to allow nodding only in particular sections of the table.<br><br>Vicky<br><br><br><br><div><hr id="stopSpelling">From: magoderre@cgq.qc.ca<br>To: pgrouting-users@lists.osgeo.org<br>Date: Fri, 17 Apr 2015 11:47:35 +0000<br>Subject: [pgrouting-users] Using pgr_nodeNetwork on a selection<br><br>
<style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal {
font-size:11.0pt;
font-family:"Calibri","sans-serif";
}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink {
color:blue;
text-decoration:underline;
}
.ExternalClass span.ecxMsoHyperlinkFollowed {
color:purple;
text-decoration:underline;
}
.ExternalClass p.ecxMsoAcetate, .ExternalClass li.ecxMsoAcetate, .ExternalClass div.ecxMsoAcetate {
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
}
.ExternalClass span.ecxEmailStyle17 {
font-family:"Calibri","sans-serif";
color:windowtext;
}
.ExternalClass span.ecxTextedebullesCar {
font-family:"Tahoma","sans-serif";
}
.ExternalClass .ecxMsoChpDefault {
font-family:"Calibri","sans-serif";
}
.ExternalClass div.ecxWordSection1 {
}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal">Can I use pgr_nodeNetwork on only a part of a table or a selection.</p>
<p class="ecxMsoNormal">I started the pgr_nodeNetwork on a table and the process failled because of memory problem. Half of the rows have been processed and the mytable_noded has the data of all data processed. I want to continu the process only on the row that
doesn't been processed.</p>
<p class="ecxMsoNormal"> </p>
<p class="ecxMsoNormal">something like </p>
<p class="ecxMsoNormal">SELECT pgr_nodeNetwork('(select w.* from way w join way_noded wn on w.id <> wn.old_id)r', 5,'id', 'line2d');</p>
<p class="ecxMsoNormal"> </p>
<p class="ecxMsoNormal">Thanks</p>
<p class="ecxMsoNormal">Marc<span style=""></span></p>
<p class="ecxMsoNormal"> </p>
</div>
<br>_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users</div> </div></body>
</html>