Hi Pablo, Probably by coordinates. It is difficult to tell without knowing your data structure. By the way, pgRouting has its own mailing list and support forum. I don't think it is nice to bug PostGIS people with pgRouting questions.
Anton. On Tue, Nov 11, 2008 at 4:06 AM, Pablo Tutino <[EMAIL PROTECTED]> wrote: > Hi List, > > I have a cities table and a roads table. > I've already assign vertex id's and created graph tables. > 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 > over those points? > > Thanks a lot > Pablo > > On Tue, Oct 28, 2008 at 2:38 PM, Pablo Tutino <[EMAIL PROTECTED]> wrote: >> >> Dear Regina >> Thank you for your help. >> Right now I'm devolping using SharpMap. So I think I'm in the right way. >> >> Pablo >> >> On Tue, Oct 28, 2008 at 2:13 PM, Paragon Corporation <[EMAIL PROTECTED]> >> wrote: >>> >>> Pablo, >>> 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 >>> ASP.NET, but I think it works in a desktop environment too. >>> >>> >>> http://www.codeplex.com/SharpMap >>> >>> Another one is MapWindow, but I've never used that one and I think >>> MapWindow is only for desktop development. >>> http://www.mapwindow.org/ >>> >>> Hope that helps, >>> Regina >>> ________________________________ >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of Pablo >>> Tutino >>> Sent: Tuesday, October 28, 2008 11:57 AM >>> To: PostGIS Users Discussion >>> Subject: Re: [postgis-users] PostGis & pgRouting on Windows >>> >>> Dear Stephen >>> Thanks a lot for your help! >>> Now let me ask one more question: >>> Could you tell me the best .Net 2.0/3.0/3.5 framework for PostGis? >>> I have to build a desktop application wich has tointeract with PostGis. >>> Best Regards >>> Pablo >>> >>> On Mon, Oct 27, 2008 at 8:44 PM, Stephen Woodbridge >>> <[EMAIL PROTECTED]> wrote: >>>> >>>> Pablo Tutino wrote: >>>>> >>>>> Hi there, >>>>> >>>>> I'm Pablo Tutino, from Argentina. >>>>> I've imported a Garmin .img DB files into polish format, then into >>>>> shapes and finally into PostGis, using shp2pgsql.exe and QGIS. >>>>> Now I have to create the directed graph up to use the pgRouting >>>>> Library. >>>>> >>>>> The first error I found is that the create_graph_tables wrapper >>>>> function is not included neither in pgRouting windows binaries nor >>>>> sources. >>>>> I found the wrapper on this link >>>>> (http://postgis.refractions.net/pipermail/postgis-users/2007-April/015159.html). >>>>> >>>>> The problem is the DB's schema I was able to import to PostGis is not >>>>> like the one in the example, >>>>> http://www.davidgis.fr/documentation/pgrouting-1.02/. >>>>> >>>>> 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. >>>>> >>>>> How can I solve this? >>>>> I mean: 1) How can I create a graph table from a schema containing >>>>> only these fields: >>>>> {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) >>>>> >>>>> 2) how can I use the correct create_schema_tables function? >>>>> >>>>> Thanks a lot Pablo >>>>> >>>> >>>> alter table mytable add column x1 float; >>>> alter table mytable add column y1 float; >>>> alter table mytable add column x2 float; >>>> alter table mytable add column y2 float; >>>> update mytable set >>>> x1 = x(st_startpoint(the_geom)), >>>> y1 = y(st_startpoint(the_geom)), >>>> x2 = x(st_endpoint(the_geom)), >>>> y2 = y(st_endpoint(the_geom)); >>>> vacuum analyze mytable; >>>> >>>> Should probably do it. >>>> >>>> -Steve >>>> http://imaptools.com/ >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> >>> >>> -- >>> Ing. Pablo Hernán Tutino >>> DIVENTI - Ingeniería y Desarrollo >>> [EMAIL PROTECTED] >>> www.diventi.com.ar >>> TE: +54-11-1569719001 >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> >> >> -- >> Ing. Pablo Hernán Tutino >> DIVENTI - Ingeniería y Desarrollo >> [EMAIL PROTECTED] >> www.diventi.com.ar >> TE: +54-11-1569719001 > > > > -- > Ing. Pablo Hernán Tutino > DIVENTI - Ingeniería y Desarrollo > [EMAIL PROTECTED] > www.diventi.com.ar > TE: +54-11-1569719001 > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
