<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Thank you Steve,<BR>
I'll test your solution as soon as possible!<BR>
<BR>
Laura<BR>
<BR> <BR>> Date: Mon, 20 Jul 2009 09:58:21 -0400<BR>> From: woodbri@swoodbridge.com<BR>> To: lauracris@hotmail.it<BR>> CC: pgrouting-users@lists.postlbs.org<BR>> Subject: Re: [pgrouting-users] rebuild topology<BR>> <BR>> Laura Criscuolo wrote:<BR>> > Hi everybody,<BR>> > I'm involved in a research on network routing in emergency situations, <BR>> > and I need to menage a huge network database, to wich I'm going to add <BR>> > and remove roads periodically.<BR>> > To rebuild the topology (with the assign_vertex_id function) whenever <BR>> > I modify the network takes really plenty of time; do you know a quicker <BR>> > way to insert in the topology the new data?<BR>> > Thanks in advance!<BR>> > <BR>> > Laura <BR>> <BR>> Hi Laura,<BR>> <BR>> assign_vertex_id() function basically iterates through all the edges in <BR>> your graph and assigns node number to the source and target columns. So <BR>> you could write a function the assigns the source and target node <BR>> numbers to a single edge and call that on each new edge you add to the <BR>> graph.<BR>> <BR>> Since the source and target numbers are stored on the edges removing the <BR>> an edge record will remove it from the graph.<BR>> <BR>> Look at the assign_vertex_id() and it should be pretty straight forward <BR>> and obvious as to how to make a new function. Post your questions and <BR>> results here and we would be happy to review and/or comment on it.<BR>> <BR>> Best regards,<BR>> -Steve<BR><br /><hr />Con Windows Live, puoi organizzare, modificare e <a href='http://www.microsoft.com/italy/windows/windowslive/products/photo-gallery-edit.aspx' target='_new'>condividere le tue foto.</a></body>
</html>