<div>Hi List,</div>
<div> </div>
<div>I have a cities table and a roads table.</div>
<div>I've already assign vertex id's and created graph tables.</div>
<div>Now, how can I match the cities and the edges up to choose a city as source and another city as target and run shortest_path_dijsktra</div>
<div>over those points?</div>
<div> </div>
<div>Thanks a lot</div>
<div>Pablo<br><br></div>
<div class="gmail_quote">On Tue, Oct 28, 2008 at 2:38 PM, Pablo Tutino <span dir="ltr"><<a href="mailto:ptutino@gmail.com">ptutino@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Dear Regina
<div><br></div>
<div>Thank you for your help.</div>
<div>Right now I'm devolping using SharpMap. So I think I'm in the right way.</div>
<div><br></div>
<div><br></div>
<div>Pablo
<div>
<div></div>
<div class="Wj3C7c"><br><br>
<div class="gmail_quote">On Tue, Oct 28, 2008 at 2:13 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Pablo,</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">You can try SharpMap. I haven't used it in a while, but it has a good PostGIS driver last time I used it as I recall, though I was using it in <a href="http://asp.net/" target="_blank">ASP.NET</a>, but I think it works in a desktop environment too.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"><a href="http://www.codeplex.com/SharpMap" target="_blank">http://www.codeplex.com/SharpMap</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Another one is MapWindow, but I've never used that one and I think MapWindow is only for desktop development.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"><a href="http://www.mapwindow.org/" target="_blank">http://www.mapwindow.org/</a></font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div><span></span><font face="Arial"><font color="#0000ff"><font size="2">Hope that helps,</font></font></font></div>
<div><font size="+0"><font color="#0000ff"><font size="2"><span></span></font></font></font><span></span><font face="Arial"><font color="#0000ff"><font size="2">R<span>egina</span></font></font></font><br></div>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Pablo Tutino<br>
<b>Sent:</b> Tuesday, October 28, 2008 11:57 AM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] PostGis & pgRouting on Windows<br></font><br></div>
<div>
<div></div>
<div>
<div></div>Dear Stephen
<div><br></div>
<div>Thanks a lot for your help!</div>
<div>Now let me ask one more question: </div>
<div>Could you tell me the best .Net 2.0/3.0/3.5 framework for PostGis?</div>
<div>I have to build a desktop application wich has tointeract with PostGis.</div>
<div><br></div>
<div>Best Regards</div>
<div><br></div>
<div>Pablo</div>
<div><br><br>
<div class="gmail_quote">On Mon, Oct 27, 2008 at 8:44 PM, Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div></div>
<div>Pablo Tutino wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi there,<br><br>I'm Pablo Tutino, from Argentina.<br>I've imported a Garmin .img DB files into polish format, then into shapes and finally into PostGis, using shp2pgsql.exe and QGIS.<br>
Now I have to create the directed graph up to use the pgRouting Library.<br><br>The first error I found is that the create_graph_tables wrapper function is not included neither in pgRouting windows binaries nor sources.<br>
I found the wrapper on this link (<a href="http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html" target="_blank">http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html</a>).<br>
<br>The problem is the DB's schema I was able to import to PostGis is not like the one in the example, <a href="http://www.davidgis.fr/documentation/pgrouting-1.02/" target="_blank">http://www.davidgis.fr/documentation/pgrouting-1.02/</a>.<br>
<br>That schema includes id,source,target,x1,y1,x2,y2,cost,reverse_cost,oneway,length,rule,to_cost, but mine doesn't have x1,y1,x2,y2.<br><br>How can I solve this?<br>I mean: 1) How can I create a graph table from a schema containing only these fields:<br>
{gid integer NOT NULL,"LABEL" character varying(50),"TYPE" character varying(10),"LEVEL" character varying(9),the_geom geometry }? (the source, target and edge were created using assing_vertex_id function)<br>
<br>2) how can I use the correct create_schema_tables function?<br><br>Thanks a lot Pablo<br><br></blockquote><br></div></div>alter table mytable add column x1 float;<br>alter table mytable add column y1 float;<br>alter table mytable add column x2 float;<br>
alter table mytable add column y2 float;<br>update mytable set<br> x1 = x(st_startpoint(the_geom)),<br> y1 = y(st_startpoint(the_geom)),<br> x2 = x(st_endpoint(the_geom)),<br> y2 = y(st_endpoint(the_geom));<br>vacuum analyze mytable;<br>
<br>Should probably do it.<br><br>-Steve<br> <a href="http://imaptools.com/" target="_blank">http://imaptools.com/</a><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>Ing. Pablo Hernán Tutino<br>
DIVENTI - Ingeniería y Desarrollo<br><a href="mailto:pablo.tutino@diventi.com.ar" target="_blank">pablo.tutino@diventi.com.ar</a><br><a href="http://www.diventi.com.ar/" target="_blank">www.diventi.com.ar</a><br>TE: +54-11-1569719001<br>
</div></div></div></div><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Ing. Pablo Hernán Tutino<br>
DIVENTI - Ingeniería y Desarrollo<br><a href="mailto:pablo.tutino@diventi.com.ar" target="_blank">pablo.tutino@diventi.com.ar</a><br><a href="http://www.diventi.com.ar/" target="_blank">www.diventi.com.ar</a><br>TE: +54-11-1569719001<br>
</div></div></div></blockquote></div><br><br clear="all"><br>-- <br>Ing. Pablo Hernán Tutino<br>DIVENTI - Ingeniería y Desarrollo<br><a href="mailto:pablo.tutino@diventi.com.ar">pablo.tutino@diventi.com.ar</a><br><a href="http://www.diventi.com.ar">www.diventi.com.ar</a><br>
TE: +54-11-1569719001<br>